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?