Tips on how to improve the performance of your MySQL Server.

Also see: Basic MySQL Performance Monitoring

MySQLTuner can identify the fragmented table count. To defragment all the tables on the MySQL database server

[bash]sudo mysqlcheck –optimize -A -uroot -p[/bash]

MySQLTuner will also provide suggested adjustments to my.cnf.