Friday, July 29, 2011

MySQL tuning primer script

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:
sh mysql_tuning.sh 

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:
/etc/init.d/mysql restart 

No comments:

Post a Comment