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

  • 4 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

How do I stop Cpanel reporting /usr/bin/crontab permissions are wrong. Please set to 4755.

If you get this message in CPanel when adding/ediiting/viewing the cron jobs ......

How do I force Statistics (Webalizer and AWstats) to run on Plesk Servers ?

Updating Webalizer and AWStats on Linux Plesk Servers from SSH The plesk control panel is...

How much is HELM ? What Helm licences do you offer ?

Web Host Automation (HELM Authors) sold the control panel rights and code some years ago to...

How much is CPanel ? What CPanel licences do you offer ?

We work with a CPANEL authorised NOC partner, able to offer you discounted CPanel licences for...

How much is Plesk ? What Plesk licences do you offer ?

We are a PLESK authorised sales partner, able to offer you discounted Plesk licences for both...

Powered by WHMCompleteSolution