Optimising MySQL database tables using phpMyAdmin

Log on to the hosting control panel. Under the “Web Tools” section you will find the MySQL icon. Click on it to continue.

In the MySQL databases page you will see your databases listed at the bottom. Click on the “Manage” button next to the database you wish to open with phpMyAdmin.

Once inside phpMyAdmin select the database in the left hand column, this will display a list with all the tables in this db. At the bottom of the table you will have the option to “select tables having overhead”, click on this and then choose the option to optimise in the dropdown menu.