4

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?

iwein
  • 25,788
  • 10
  • 70
  • 111
VSB
  • 9,825
  • 16
  • 72
  • 145
  • possible duplicate of [flush tables - access denied](http://stackoverflow.com/questions/9972651/flush-tables-access-denied) – unutbu Aug 04 '15 at 13:09
  • I'm seeking to know are there any methods to solve this problem? – VSB Aug 04 '15 at 13:14

2 Answers2

9

Try optimize table command

OPTIMIZE TABLE <tablename>;
pkmiec
  • 2,594
  • 18
  • 16
4

In phpMyAdmin, click on the database name to show the tables in the main panel. Then tick the checkbox next to the table name you want to decrease, and in the "With selected" drop-down under the list of tables, choose "Optimize".

Marc Delisle
  • 8,879
  • 3
  • 29
  • 29