MySQL Forums :: InnoDB :: InnoDB File Size

Advanced Search

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 2227 Baskar N 06/09/2011 11:09AM
Re: InnoDB File Size 886 Rick James 06/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.