Optimising All Databases
You can optimise your databases using mysql as the root user with the mysqlcheck utility...from an ssh prompt as root type
mysqlcheck -o -u root -p --all-databases
Note:
This will take some time and cause significant load to your server
