MySQL Forums :: InnoDB :: Growth of .ibd and .ibdata files

Advanced Search

Growth of .ibd and .ibdata files
Posted by: Tiago 504 ()
Date: October 06, 2016 08:38AM


I am catching all the disk I/O system calls performed by innodb in the data directory. Seems that Innodb grows the .idb and .ibdata files by writing 1 byte each 512 bytes, and then fills up that empty space with some structures, before storing the data related with the tables. However seems that the growth of that files is not reflected on the redo log files. Is this correct? In what part of source code can I look to the growth of that files.

Thanks in advance,
Tiago Oliveira

Options: ReplyQuote

Subject Views Written By Posted
Growth of .ibd and .ibdata files 530 Tiago 504 10/06/2016 08:38AM
Re: Growth of .ibd and .ibdata files 351 Rick James 10/08/2016 12:00PM
Re: Growth of .ibd and .ibdata files 296 Peter Brawley 10/08/2016 06:18PM
Re: Growth of .ibd and .ibdata files 385 Tiago 504 10/11/2016 10:36AM
Re: Growth of .ibd and .ibdata files 251 Rick James 10/16/2016 03:29PM

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.