Friday, May 1, 2009

MySQL performance tunning - Part 1

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.

-Babu Satasiya

No comments:

Post a Comment