How to Optimize MySQL Database Using phpMyAdmin in cPanel?

MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language in the Reseller Hosting.The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database in Linux hosting. MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc. You can optimize the unused space of the table for the performance of the server. If you have 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 inhosting cPanel.  

[1]  Login to cPanel and go to “phpMyAdmin”.

[2]  Click On “Databases”.

[3]  Select the database you want to optimize from the database list.

[4] It will take you to the “Structure” tab for the database where you can select the table you want to optimize. Check the box in front of each one, or click on Select All if you want to optimize all of them.

[5]  On the drop down box that says “with selected” select “Optimize Table.”

[6] This will optimize the table and take you to a new screen where you can see the list of tables which you have optimized.