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.

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:
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.