There are couple scripts available which helps to improve the performance of mysql, I found two usefull scripts, that helped me to improve performance of server a lot, earlier mysql was running most CPU intesive, after tunning the parameters it went down a lot.
1. MySQL Performance Tuning Primer Script (http://www.day32.com/MySQL/tuning-primer.sh)
2. High Performance MySQL Tuning Script (http://mysqltuner.com/mysqltuner.pl)
I will write more details in next post.