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:

下面是10篇从不同角度讨论Mysql优化的文章：

• Identifying slow MySQL queries
• MySQL & PHP Performance Optimization Tips
• MySQL Presentations: Optimizing MySQL
• MySQL 5 Optimization and Tuning Guide
• Survive heavy traffic with your Web server
• Tools to use for MySQL Performance - Peter Zaitsev
• MySQL Queries Optimization (video) - Peter Zaitsev
• Table Design and MySQL Index Details
• MySQL Reference Manual: Optimization Overview
• MySQL Reference Manual: The MySQL Query Cache