Site, where always was placed script for tuning mysql, today is not available.
So I downloaded this script from one of my sites and decided to publish it for everybody:
MySQL tuning primer script in Google docs
it's non-touched original script.
This script will require bc:
apt-get install bc
To run script use:
Script will just show you tips about optimization, nothing will be changed. It's not my script.
Read carefully what is written in the section "memory usage".
If you will edit your my.cnf file, after any changes you will need to restart MySQL: