Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Optimisation is a complicated task because it ultimately requires understanding of the whole system. While it may be possible to do some local optimisations with little knowledge of your system or application, the more optimal you want your system to become the more you will have to know about it.
This chapter will try to explain and give some examples of different ways to optimise MySQL. Remember, however, that there are always some (increasingly harder) additional ways to make the system even faster.