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.