How to Optimize MySQL Database By Using phpMyAdmin in Plesk?

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. MySQL Database optimization you can able to delet a part of the table, or you can able to made many changes to the rows or columns of the table. The deleted rows or columns are maintained in the linked list so the insert operations reuse the old portions of the tables. 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 there by you can improve the database performance.  

Kindly use the below procedure to optimize MySQL database by using phpMyAdmin in Plesk

[1] Login to Plesk and go to websites and domains.
[2] Select the “Database” icon.
[3] Go to phpMyAdmin.
[4] Click on the icon “Databases”.
[5]  Select the database you want to optimize from the database list.
[6]  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” option if you want to optimize all of them.
[7] On the drop down box that says “with selected” select “Optimize Table”.
[8] This will optimize the table and take you to a new screen where you can see the list of tables you have optimized.