[FIXED] mysql table not decreased in size after deleting rows

Issue

I deleted 1M rows from a database table. Surprisingly its size did not decrease. Then I have tried: FLUSH TABLES; but whey I ran this statement on phpMyAdmin of my cPanel then I encountered below error:

#1227 - Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

How can I decrease my table size and clear its cache?

Solution

Try optimize table command

OPTIMIZE TABLE <tablename>;

Answered By - pkmiec