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 ?
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.
Percona created this picture a long time ago. As you can see, ibdata1 contains many classes of data structures. There are as follows:
BTREEs in InnoDB
If you are concerned how indexes are stored, please read my earlier posts about InnoDB indexes