MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Show Table Status doesnt show Descreases in table size
Posted by: Ingo Strüwing
Date: February 10, 2006 01:59AM

Hi.

When you delete a record from a MyISAM table, the space it took is marked as free and appended to a "deleted records chain". It will be reused with the next insert.

OPTIMIZE TABLE creates a new table by copying all non-deleted records over and creating all indexes from scratch. This may take some time for big tables.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Show Table Status doesnt show Descreases in table size
4643
Dexter Coelho
February 09, 2006 01:17PM
Re: Show Table Status doesnt show Descreases in table size
2149
Jay Pipes
February 09, 2006 01:36PM
Re: Show Table Status doesnt show Descreases in table size
2610
Dexter Coelho
February 09, 2006 02:48PM
Re: Show Table Status doesnt show Descreases in table size
2355
Ingo Strüwing
February 10, 2006 01:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.