Recently in turn ginger Teacher's storage engine 2, dry a lot. Combined with Jeremy Cole's InnoDB analysis tool, you can deepen your understanding of INNODB physical structure.
The drawing process references Kang's InnoDB storage engine 2, Jeremy Cole's blog, and GitHub.
The study process of the experiment notes a bit messy not very good post. Map it first. Please correct me if the new driver, who may have painted the wrong place.
650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/9D/D0/wKiom1mGyySQDiz6AAIDZ8JqmmQ111.png "title=" InnoDB illustration. png "alt=" Wkiom1mgyysqdiz6aaidz8jqmmq111.png "/>
############################################################
The following is an analysis of page directory in Mr. Jiang's book:
650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/9D/CF/wKioL1mGzGHxowMyAATVpUtVNs8440.png "title=" Snapshot 2.png "alt=" Wkiol1mgzghxowmyaatvputvns8440.png "/>
This article is from the "notes of a Chicken" blog, please be sure to keep this source http://lee90.blog.51cto.com/10414478/1954013
INNODB IBD Structure diagram