Knowledge Base » Web Hosting

Optimizing a MySQL Database Using phpMyAdmin

Art. Nr: 217  |  Rating: 5/5 from 2 votes  |  Last Updated: Wed, Jan 18, 2012
starstarstarstarstar

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:

  • Login to your cPanel web hosting account
  • Locate the section called "Databases"
  • Click on the "PHPMyAdmin" Icon
  • Select the database from the left menu
  • Select all the database tables in by clicking "Check All"
  • Underneath will be a drop-down menu, you'll see an option to "optimize table".
  • Select the "Optimize table" option, this will run the Optimize table SQL

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.

Comments

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

Post your Comments

Popular Tutorials

RSS Feed
Please see below, some related knowledge base tutorials, which are related to your search query. Please feel free to contact us if you are not able to find what you are looking for.