Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There are two tables and their default engine is InnoDB.

I want know the following

  • What's inside the ibdata file ?
  • How does InnoDB store these two tables ?
share|improve this question

closed as unclear what you're asking by ypercubeᵀᴹ, Paul White, Kin, Michael - sqlbot, Mark Storey-Smith Apr 13 '14 at 10:40

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

InnoDB Architecture

InnoDB Architecture

Percona created this picture a long time ago. As you can see, ibdata1 contains many classes of data structures. There are as follows:

  • Table Data Pages (if innodb_file_per_table disabled)
  • Table Index Pages (if innodb_file_per_table disabled)
  • Data Dictionary (Tablespace IDs, Logical-to-Physical Mapping to Tables)
  • Double Write Buffer (Handles Data Redundancy to Support Crash Recovery)
  • Insert Buffer (Handles Updates to Secondary Indexes)
  • Rollback Segments (Manages Reverse Engineering of Uncommitted Transactions)
  • Undo Space (Containers of Information for Rollback Operations)

BTREEs in InnoDB

If you are concerned how indexes are stored, please read my earlier posts about InnoDB indexes

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.