Chapter 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 worth of queries (an hour , a day, or some average period) and then replay those queries with the new server configuration.