MySQL Tuning Snippet

Last modified: October 6, 2006 - 02:32

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

 
 

Drupal is a registered trademark of Dries Buytaert.