[ІТ Ідеї] mysql tuning

[ІТ Ідеї] mysql tuning

for high load mysql servers you most probably will need suggestion what
parameter you should change to improve performance

First of all I recommend to run mysqltuner script

wget http://mysqltuner.com/mysqltuner.pl
chmod +x mysqltuner.pl

You will be prompted to enter valid mysql credentials and after that
you will see recommendation what should you tune on your mysql server

mysql optimize tables

and there I found nice perl script which can be run on your server and
you can optimize tables in DB
you can download it from there