Please wait while we load your page...


Webmaster Tutorials

Webmaster Tutorials

mySQL Maintenance
It is highly recommended you perform regular mySQL maintenance. You can do this by executing the following commands via SSH:

mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

Repairing and optimizing mySQL databases goes a long ways to keep mySQL operating efficiently, and reducing the chances of mySQL crashing: which necessitates restarting the mySQL server (/etc/init.d/mysqld restart). Ideally you would create a cron job to automatically perfrom these actions at set times. For example, daily.

Last Revised: 2016-04-12 12:24:20

Live Chat Not Available