MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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.

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


Subject
Views
Written By
Posted
actual Size calculation of mysql table (engine innodb)
2304
Afaque Ahmad Siddiqui
December 10, 2014 09:38AM
Re: actual Size calculation of mysql table (engine innodb)
1259
Rick James
December 12, 2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)
1348
Rick James
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.