I found a real good script that aids in the optimization of mysql. It suggests changes according to your server usage.
I couldnt find the homepage for the project after I found it earlier but here is a local copy I have
wget nix101.com/tuning-primer.sh
Check it out, it cant hurt anything. just backup your my.cnf before you start [...]