How to Optimize MySQL Database Using phpMyAdmin in Linux Reseller Hosting?

SiliconHouse servers comes with free cPanel/WHM.In this session you can able to see How to Optimize MySQL Database Using phpMyAdmin in Linux Reseller Hosting.  

SiliconHouse servers comes with free cPanel/WHM.In this session you can able to see How to Optimize MySQL Database Using phpMyAdmin in Linux Reseller Hosting.

In the cPanel hosting plan, you can made a lot of changes to the table, optimizing the table can delete the unused space thereby you can improve the database performance. You can follow procedure to Optimize MySQL Database Using phpMyAdmin in Reseller Hosting cPanel.

[1] Login to cPanel 
[2] Go to “phpMyAdmin” option
[3] Click On “Databases” section
[4] Select the database you want to optimize 
[5[ Enter into the “Structure” tab for the database 
[5] Check the box in front of each one, or click on Select All if you want to optimize all of them
[6] On the drop down box that says “with selected” select “Optimize Table”
[7] This will optimize the table and take you to a new screen where you can see the list of tables which you have optimized

Done! Hereby we come to know How to Optimize MySQL Database Using phpMyAdmin in Linux Reseller Hosting.