How to optimize MySQL database?

Repair & optimize all databases using the following command when SSH using root:

mysqlcheck --check --auto-repair --all-databases
mysqlcheck --optimize --all-databases 
/etc/init.d/mysql restart

Note : If you experience any trouble with this process, please don’t hesitate to contact our technical team.

Updated on: 20/06/2022

Was this article helpful?

Thank you!