Whenever you delete large number of records from your MySQL database, it is recommend to optimize your MySQL database for the best performance. In this article, we will show you how to optimize MySQL database using phpMyAdmin.

– Open your phpMyAdmin tool.
– Select the database you want to optimize on the upper left.
– Select the tables you want to optimize (usually checkmark all tables)
– Using the selection box at the bottom, select “Optimize Table”

This will execute the OPTIMIZE TABLE SQL query on the selected tables.

How to optimize MySQL database using phpMyAdmin

Last Updated on

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.