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
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
I made about tuning mysql, along with a tool and some example settings:
http://drupal.org/node/85768