MySQL Forums
Forum List  »  InnoDB

InnoDB File Size
Posted by: Baskar N
Date: June 09, 2011 11:09AM

I see that when Inno DB engine is used, the size of the data file never shrinks. I would like to know if any data deletions are adjusted against any data additions made. Let me say the file ibdata1 has a size of 5 k. I am removing 3k of data from the tables and adding 4 k of data then. Does the file size grow to 9k or 6k ?

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB File Size
2340
June 09, 2011 11:09AM
913
June 10, 2011 09:35PM


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.