Optimizing MySQL queries

Following articles will explain how to Optimizing MySQL queries

1. Identifying slow MySQL queries


2. MySQL & PHP Performance Optimization Tips


3. MySQL Presentations: Optimizing MySQL


4. MySQL 5 Optimization and Tuning Guide


5. Survive heavy traffic with your Web server


6. Tools to use for MySQL Performance - Peter Zaitsev


7. MySQL Queries Optimization (video) - Peter Zaitsev



8. Table Design and MySQL Index Details


9. MySQL Reference Manual: Optimization Overview


10. MySQL Reference Manual: The MySQL Query Cache