|
If you have root access to your cPanel/WHM server (eg: a dedicated server or VPS), you can optimise all databases on your server at once by running the following commands in SSH/Shell:
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize
Ensure you run each of these command lines seperately.
You can only run these commands if you have root/admin access to your server. You cannot run these if you are a reseller or shared hosting customer.
Note: Please ensure you backup your databases prior to running these commands. Whilst no damage is expected, we cannot be held responsible should you corrupt/damage your databases by running the above commands.
| 
