MySQL Forums
Forum List  »  MyISAM

Re: MyISAM tables files don't become smaller after deleting rows
Posted by: Ingo Strüwing
Date: April 28, 2005 02:47AM

Please note that this is intentionally. The deleted records are marked as deleted only, so that their space can be reused quickly. A resizing would mean to move down all data above the deleted record and to fix the new record positions in the indexes. That takes a lot of time. You want to do it only seldom and when you can afford waiting applications. Use OPTIMIZE TABLE then, or ALTER TABLE.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MyISAM tables files don't become smaller after deleting rows
2727
April 28, 2005 02:47AM


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.