Articles for optimizing MySQL queries

Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the mo

Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the more optimal you want your system to become, the more you must know about it.

The following 10 articles explain and give some examples of different ways to optimize MySQL:

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

---

Possibly related posts: (automatically generated)

• Ebook: MySQL Manual
• MySQL Resources
• Identifying Slow MySQL Queries