How do you approach database optimization in PHP applications, and what tools or techniques do you use?

Database optimization is crucial. I start by profiling queries using tools like EXPLAIN in MySQL to identify bottlenecks. I optimize queries, use proper indexing, and normalize databases to eliminate redundancy. Caching frequently accessed data and employing database connection pooling also contribute to improved performance.