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
usage:
wget http://mysqltuner.com/mysqltuner.pl
chmod +x mysqltuner.pl
./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