Here’s a great script for optimizing MySQL tables:
http://www.dufault.info/blog/a-script-to-optimize-fragmented-tables-in-mysql/
You can install and run with:
|
1 2 3 |
wget https://raw.github.com/pdufault/mysqlfragfinder/master/mysqlfragfinder.sh chmod 755 ./mysqlfragfinder.sh ./mysqlfragfinder.sh --user root --password "xxxxxx" |