17.Optimizing Your MySQL Server Configuration
In this chapter, we'll look at some options for speeding up your MySQL server. Server tuning is a huge topic and is something of a black art. In this chapter, we only aim to give you an introduction to the basics of tuning your server setup. We will cover the following:
• Compiling and linking for speed
• Tuning server parameters
• Tuning other factors
The key thing to remember when making any server tuning changes is that you will need to do it empirically. Try one change at a time, and measure performance before and after the change. Only then will you know whether your changes are actually improving performance.
If you are really trying to benchmark correctly, you may want to log a period ...