Knowledgebase

How do I OPTIMISE all MySQL databases on my virtual / dedicated server?

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

Add to Favourites    Print this Article

How do I clear the exim sendmail statistics on CPanel / WHM ? (Views: 8402)

Set up SSH for use without a password? (Views: 2051)

Linux How-To Monitor DD Progress Copying A Drive to a New One (Views: 45012)

How do I convert to MailDir Format from MBox (for IMAP) on Cpanel/WHM Servers ? (Views: 3571)

How do I Allow Remote Access to MySQL for Specific Users to My Virtual/Dedicated/Cloud Server (Views: 4609)