Optimize all Mysql tables
Submitted by chris on January 8, 2006 - 01:01. MySQL Information & Links
Optimize all databases.
1) This command will go through all your databases and optimize all your database tables for optimal performance;
mysqlcheck -o -u root -p --all-databases
2) You can also do this using the free MySQL Administrator GUI.
In the GUI select your database.
Select all your tables (Ctrl-A), right mouse click and select "Maintenance -> Optimize Table".
1) This command will go through all your databases and optimize all your database tables for optimal performance;
mysqlcheck -o -u root -p --all-databases
2) You can also do this using the free MySQL Administrator GUI.
In the GUI select your database.
Select all your tables (Ctrl-A), right mouse click and select "Maintenance -> Optimize Table".