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!

1 of 1

One comment on: MySQL Tuning

  1. dlP
    Reply

    Just found your site, great stuff!! We just phased drupal out and replaced with laravel. I’ll be back often…

Leave a Reply