MySQL Query Cache Resources

Sat, May 29, 2010

To follow up on my post about Drupal's MySQL performance, I wanted to share some resources I found during that journey.

First, the MySQL documentation has some resources on the subject, which are fairly vanilla type of resources.

General docs/specs about the query cache
A very detailed explanation on how you can use and measure the query cache

There was a commentator on the article that pointed me to his blog, which has an excellent resource on a kind of a "best defaults" configuration for MySQL. His argument is that MySQL's default configuration is made for old 32 MB boxes but most machines we run today have many GBs of memory, so the default configuration isn't very good. Highly recommended:

Cafuego's recommended defaults for MySQL settings

And of course, you can't talk about MySQL performance without referring to the MySQL Performance Blog, which I read regularly and can also recommend.

MySQL Performance Blog's article about the Query Cache