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".