InnoDB Logical Storage

InnodbLogical Storage

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/83/42/wKiom1duQjrQy1BwAAIv5uQNlmk338.png-wh_500x0-wm_3 -wmp_4-s_3192428505.png "title=" 1.png "alt=" Wkiom1duqjrqy1bwaaiv5uqnlmk338.png-wh_50 "/>

Segment: Data segment, rollback segment ...

Extent: A extent page , a large segment can apply for 4 extent

Page: A page 16k, a extent16*64=1024k=1m

Segment: like Oracle , in a way, a segment can be understood as a table

Bufferand thePageRelationship

1. Buffer interacts data from the data file into memory in page (conservative attitude);

2. MySQL is also divided into physical reading and logical reading, similar to Oracle ;

3. Page interacts in memory, a page corresponds to a buffer,[ Note in the terminology ];

4. Buffer divided into free[ never used ],clean[ and data files in consistency ],dirty[ Inconsistent with data in data file ]

Memory Chain Management

1. Freelist corresponds to free buffer;

2. Flushlist corresponds to dirty buffer, need to be refreshed;

3. Lrulist corresponds to Cleanbuffer, pay attention to hit ratio;

4. List linked list, which can be used from the back to the rear.

This article is from the "90SirDB" blog, be sure to keep this source http://90sirdb.blog.51cto.com/8713279/1792870

InnoDB Logical Storage