mysql table size unchanged after rows deleted

Question

Had a table with about 2,000,000 rows (168 MB)

Deleted 1,800,000 rows but the table size is unchanged!?

Why is that? The rows where deleted about two days ago now, but the table size is still 168 MB?

MySQL 5.6.20 innodb table

Possible duplicate of MySQL InnoDB not releasing disk space after deleting data rows from table — Lukasz Szozda
– Lukasz Szozda, Commented Oct 12, 2015 at 8:37
did you try to optimize it, to save disk operation the file is not optimize on every delete and hence the "Table" size remain unchanged. — Sumit Gupta
– Sumit Gupta, Commented Oct 12, 2015 at 8:38
@sumit, create an anwser :) table optimize solved the problem — clarkk
– clarkk, Commented Oct 12, 2015 at 8:45

Sumit Gupta · Accepted Answer · 2015-10-12 08:46:33Z

1

Did you try to optimize it, to save disk operation the file is not optimize on every delete and hence the "Table" size remain unchanged.

You need to optimize it and sometime Re-index can also reset the table size.

answered Oct 12, 2015 at 8:46

Sumit Gupta

2,2024 gold badges31 silver badges47 bronze badges

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

2 Comments

Rana Hyder Sep 3 at 9:07

How to do that?

Sumit Gupta Sep 16 at 7:08

One way is running OPTIMIZE TABLE <table_name>; or if you use PHPMyAdmin like tool then under Operations or table setting you might find a button for it.

om_mish99 · Accepted Answer · 2015-10-12 08:54:02Z

0

try to optimize the table because you have used delete statement. 'shrink' size of table for optimization.

answered Oct 12, 2015 at 8:54

om_mish99

112 bronze badges

Collectives™ on Stack Overflow

mysql table size unchanged after rows deleted

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related