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.
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.
![](https://casbay.com.my/guide/wp-content/uploads/2021/03/optimize-table-phpMyAdmin-Step2-Select-database-to-optimze.png)
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.
![](https://casbay.com.my/guide/wp-content/uploads/2021/03/optimize-table-phpMyAdmin-Step3-Select-table-to-optimize.png)
4. Click the “with selected” drop-down menu, and select Optimize.
![](https://casbay.com.my/guide/wp-content/uploads/2021/03/optimize-table-phpMyAdmin-Step4-With-selected.png)
5. Lastly, you will see the results of it on the next screen after the optimization completes.
![](https://casbay.com.my/guide/wp-content/uploads/2021/03/optimize-table-phpMyAdmin-Step5-successful-message.png)
We hope this article helped you to learn about how to optimize MySQL table in phpMyAdmin. For more articles, please go to Knowledge Base.