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

Basic Exim troubleshooting (Views: 6200)

What exclusions are there to your "Zero Downtime or Zero Invoice" SLA? (Views: 2687)

Ensim Mail Queue Problems - why are messages stuck in mqueue / mqueue.scanned / FILESYSTEMTEMPLATE/services/sendmail/ and how to process them... (Views: 5820)

How to update CPanel/WHM from shell command line (SSH) ... (Views: 28082)

How do I login to WHM after being blocked by cPHulk (root user)? (Views: 3269)