How to Optimize MySQL Database Using phpMyAdmin in Plesk?

How to Optimize MySQL Database Using phpMyAdmin in Plesk?

In this tutorial, we are going to discuss about how to optimize a database table from phpMyAdmin in Plesk. Table optimization can be used if you have deleted a part of the table, or you have made many changes to the rows or columns of the table with variable length rows etc… 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.

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.

 

If you need any further help, please do reach our support department.