Working on some performance tuning for MySQL today. Here are by far the best resources I have found:
Best General Tuning Guide:
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
Expanded point from that Guide:
http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/
I ran into an issue when I adjusted a log file size (MySQL wouldn’t start), this was the fix:
http://dba.stackexchange.com/questions/1261/how-to-safely-change-mysql-innodb-variable-innodb-log-file-size
In my case MySQL was running on a dedicated VPS with 2 Gb of Ram so I had quite a bit of room to work. If you are on shared hosting or even a VPS sharing space with Apache your numbers are going to look different. This was, of course, an effort to fix performance on a Drupal site that was running really really rough even though it has low traffic. The tuning helped a lot but I still have a ways to go.
Anyhow, thought I would pass the helpful links along as anyone searching for MySQL Performance tuning should be finding this stuff first imho.
Cheers!
Just found your site, great stuff!! We just phased drupal out and replaced with laravel. I’ll be back often…