MySQL Tuning Snippet

This is useful for measuring several important performance criteria of your MySQL database within a Drupal site. For each measurement that is under performing you will recieve a message advising you how to tune your MySQL server. Note: In this script all advisements for changes are made using the SET syntax. Make sure you understand how this is only a temporary solution. Permanent changes to the variables can be made by editing your my.cnf file. There is mysql documentation for how to do this.
All sizes are given in bytes. (divide by 1024.0 twice to get the number in M.)

This script has been moved into CVS. You can find it here

Upgrades to 4.7.x

agentrickard - August 14, 2006 - 14:55

The script in cvs is only partially functional. I have ported some changes to a 4.7.x version here

http://drupal.org/node/78575

--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.

Link to a different handbook page

Caleb G - oldacct - September 25, 2006 - 23:27

I made about tuning mysql, along with a tool and some example settings:

http://drupal.org/node/85768

 
 

Drupal is a registered trademark of Dries Buytaert.