mysql tuning

this is good reference how to do about optimizing mysql setting

http://serverfault.com/questions/148926/mysql-optimizing

http://www.ibm.com/developerworks/library/l-tune-lamp-3.html