MySQL Forums
Forum List  »  InnoDB

Re: Data length for INNODB tables
Posted by: sreekanth pm
Date: February 19, 2018 07:52AM

To find the exact size I have set innodb_file_per_table=OFF. Initially ibdata1 size was set to 500MB and disabled my autoextend. After inserting data into table the "data_length" increased and "data_free" reduced. In some cases after deletion of records the "data_length" was increased and "data_free" reduced.

But the actual result should be reduction of "data_length" and growth of "data_free" on deletion of records.I am not sure why there is a deviation and not able to predict the exact used and free space of a table.

Thanks & Regards
Sreekanth PM

Options: ReplyQuote


Subject
Views
Written By
Posted
241
February 14, 2018 01:05AM
151
February 14, 2018 12:19PM
Re: Data length for INNODB tables
186
February 19, 2018 07:52AM
141
February 19, 2018 01:50PM
110
February 21, 2018 06:50AM
124
February 22, 2018 03:13AM


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.