I would like to understand these ibdata files as these play vital role in the crash recovery procedure. I could not find proper resources over the web for this.
migrated from meta.dba.stackexchange.com Oct 17 '12 at 10:06
This question came from our discussion, support, and feature requests site for database professionals who wish to improve their database skills and learn from others in the community.
The file ibdata1 is the system tablespace for the InnoDB infrastructure.
It contains several classes for information vital for InnoDB
You can divorce Data and Index Pages from ibdata1 by enabling innodb_file_per_table. This will cause any newly created InnoDB table to store data and index pages in an external
Here are my past articles on separating table data and indexes from ibdata1
iblog files (a.k.a.