Configuring MySQL

We recommend basing your MySQL configuration on the example configuration file my-large.cnf included in the MySQL distribution.

In addition the following changes should be made:

Additionally, there appears to be a bug in certain versions of MySQL that can cause the cleanup of the query cache to take a very long time. If you experience this, please disable the query log by setting the query_cache_size option to 0: query_cache_size= 0