MySQL: Configuration Options

In this chapter, we will explain a process by which you can create a good configuration file for your MySQL server.

After you've set MySQL's basic configuration options correctly, the potential gains from further changes are usually small.

On the other hand, the potential downside of fiddling with the configuration can be great.

Make sure the basics such as the innoDB buffer pool and log file size are appropriate, set a few safety and sanity options if
you wish to prevent bad behavior(but note that these usually won't improve performance--they'll only avoid problems)

It's best to start your search of performance problems with queries and their response times, not with configuration options.

Unexpected bugs can arise when you change default configuration options needlessly.