HowTo tune your MySQL performance by tuning server variables.

1. Download the tuning primer Script made by one of the MySql Devs.

# wget http://day32.com/MySQL/tuning-primer.sh

2. Make it executable, and use it

chmod +x tuning-primer.sh
./tuning-primer.sh

3. Read the output carefully and follow the instructions

And don't forget to backup your old my.cnf!