cPanel makes it easy to optimize databases using the phpMyAdmin feature within your web hosting account. Optimizing your database tables is an important part of keeping your database functioning and should be done regularly from within your web hosting account. To optimize your database tables, please follow the step-by-step user guide listed below:
Once this has been fully completed, your database with all the tables within it would have been fully optimized. This will help your web hosting website load faster.
Please let us know if you have any further questions and our web hosting support team will be glad to assist you.
The best is to install Percona MySQL it is optimized and running a lot faster than regular MySQL server.Posted by Teddy33 - Wed, Jun 27th, 2012 9:46 AM
We are optimizing the MySQL databases every week via crontab. This is saving us a lot of troubles with the server in long run.Posted by Rebecca - Fri, Jun 8th, 2012 10:26 AM
Creation of crontab to optimize and analize the MySQL databases on server is a good idea. This way everything will be automated and MySQL will be always fast.Posted by DaiMiPo - Mon, May 21st, 2012 10:19 AM