MySQL Forums
Forum List  »  Optimizer & Parser

Re: actual Size calculation of mysql table (engine innodb)
Posted by: Rick James
Date: December 12, 2014 08:36PM

Additionally...

If you had innodb_file_per_table = OFF when you CREATEd the TABLE, then the data (and indexes) is in the file ibdata1 .
If you had innodb_file_per_table = ON when you CREATEd the TABLE, then the data (and indexes) is in the file tablename.ibd .

In the latter case, the size of the .ibd file is how much space the table is consuming on disk. It is likely to be bigger than Data_length + Index_length because of Data_free. This last value is yet another "overhead" that InnoDB imposes on us -- for performance reasons.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: actual Size calculation of mysql table (engine innodb)
1275
December 12, 2014 08:36PM


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.