mysql page 类型汇总

File page types                     (values of FIL_PAGE_TYPE)	十六进制	十进制	解释	备注
FIL_PAGE_INDEX	45bf	17855	/** B-tree node */B+树（leaf，non-leaf page）		，每个B+ tree使用两个segment来管理page，分别是leaf node segment（叶子节点segment）和non-leaf node segment（非叶子节点segment）。这两个segment的Inode entry地址记录在B+ tree的root page中FSEG_HEADER里面，而root page又被分配在non-leaf segment第一个碎片页上（fragment array）。
FIL_PAGE_RTREE	45be	17854	/** R-tree node */
FIL_PAGE_SDI	45bd	17853	Tablespace SDI Index page	表结构元数据信息
FIL_PAGE_UNDO_LOG	2	2	Undo log page
FIL_PAGE_INODE	3	3	Index node	page2：INODE页就是用于管理segment的，每个Inode entry负责一个segment。
FIL_PAGE_IBUF_FREE_LIST	4	4	Insert buffer free list	/* File page types introduced in MySQL/InnoDB 5.1.7 */page 4 存放的是insert buffer tree 的root page
FIL_PAGE_TYPE_ALLOCATED	0	0	Freshly allocated page
FIL_PAGE_IBUF_BITMAP	5	5	Insert buffer bitmap	page1：存放的是insert buffer 相关信息
FIL_PAGE_TYPE_SYS	6	6	System page	page6 存放的是FSP_FIRST_RSEG_PAGE_NO, 也就是undo log rollback segment的header page. 其他的undo log rollback segment 都在不同的undo log 文件中;                                 page 7 存放的是 FSP_DICT_HDR_PAGE_NO, 存放的是DD 相关的信息
FIL_PAGE_TYPE_TRX_SYS	7	7	Transaction system data	page 5 存放的是trx_sys 模块相关信息, 比如最新的trx id, binlog 信息等等.
FIL_PAGE_TYPE_FSP_HDR	8	8	File space header	page0：第一个XDES 又叫做FSP_HDR, 还有一些额外的信息; extent 空间管理，一个xdes page管理连续256M	用于分配、管理extent和page。
FIL_PAGE_TYPE_XDES	9	9	Extent descriptor page	extent 空间管理，一个xdes page管理连续256M	用于分配、管理extent和page。
FIL_PAGE_TYPE_BLOB = 10;	a	10	Uncompressed BLOB page
FIL_PAGE_TYPE_ZBLOB = 11;	b	11	First compressed BLOB page
FIL_PAGE_TYPE_ZBLOB2 = 12;	c	12	Subsequent compressed BLOB page
FIL_PAGE_TYPE_UNKNOWN = 13;	d	13	/** In old tablespaces, garbage in FIL_PAGE_TYPE is replaced with this value when flushing pages. */
FIL_PAGE_COMPRESSED = 14;	e	14	Compressed page
FIL_PAGE_ENCRYPTED = 15;	f	15	Encrypted page
FIL_PAGE_COMPRESSED_AND_ENCRYPTED		16	Compressed and Encrypted page
FIL_PAGE_ENCRYPTED_RTREE = 17;		17	Encrypted R-tree page
FIL_PAGE_SDI_BLOB = 18;		18	Uncompressed SDI BLOB page
FIL_PAGE_SDI_ZBLOB = 19;		19	Commpressed SDI BLOB page
FIL_PAGE_TYPE_LEGACY_DBLWR = 20;		20	Legacy doublewrite buffer page.
FIL_PAGE_TYPE_RSEG_ARRAY = 21;		21	Rollback Segment Array page
FIL_PAGE_TYPE_LOB_INDEX = 22;		22	Index pages of uncompressed LOB
FIL_PAGE_TYPE_LOB_DATA = 23;		23	Data pages of uncompressed LOB
FIL_PAGE_TYPE_LOB_FIRST = 24;		24	The first page of an uncompressed LOB
FIL_PAGE_TYPE_ZLOB_FIRST = 25;		25	The first page of a compressed LOB
FIL_PAGE_TYPE_ZLOB_DATA = 26;		26	Data pages of compressed LOB
FIL_PAGE_TYPE_ZLOB_INDEX = 27;		27	/** Index pages of compressed LOB. This page contains an array of z_index_entry_t objects.*/
FIL_PAGE_TYPE_ZLOB_FRAG = 28;		28	Fragment pages of compressed LOB.
FIL_PAGE_TYPE_ZLOB_FRAG_ENTRY = 29;		29	Index pages of fragment pages (compressed LOB)