This tutorial assumes you’ve already logged in to phpMyAdmin
We will be demonstrating how to optimize your MySQL tables.
1) Select the database you wish to optimize.
2) Select the tables you wish to optimize. Or you can click the select all link located at the bottom of the table list.
3) Click the “with selected” drop-down menu, and select optimize.
That’s it! You should see a message confirming the requested operation.