mysql table not decreased in size after deleting rows

Question

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?

I'm seeking to know are there any methods to solve this problem? — VSB
– VSB, Commented Aug 4, 2015 at 13:14

pkmiec · Accepted Answer · 2015-08-05 20:38:09Z

9

Try optimize table command

OPTIMIZE TABLE <tablename>;

answered Aug 5, 2015 at 20:38

pkmiec

2,69421 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marc Delisle · Accepted Answer · 2015-08-05 20:04:55Z

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".

Collectives™ on Stack Overflow

mysql table not decreased in size after deleting rows

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related