5. mysqlcheck — A Table Maintenance and Repair Program
即可最佳化所有db
mysqlcheck -a -c -o -r --all-databases -uroot -p
-a = Analyse given tables.
-c = Check table for errors
-o = Optimise table
-r = Can fix almost anything except unique keys that aren't unique