How to Optimize table in phpMyAdmin

Last modified: July 2, 2022

You are here:

Estimated reading time: < 1 min

In this article

Optimizing MySQL databases

We will be demonstrating how to optimize your MySQL tables.

Note: Some tables can not be optimized.

1. First, log into your cPanel and select the PHPMyAdmin icon.

2. Next, select the database you wish to optimize.

3. Then, select the tables you wish to optimize. Or you can click the select all link located at the bottom of the table list.

4. Click the “with selected” drop-down menu, and select Optimize.

5. Lastly, you will see the results of it on the next screen after the optimization completes.

Was this article helpful?