参考文献

  • MySQL 源码

MySQL5.6 File Page Types

  • 来源storage/innobase/include/fil0fil.h
File Page Type 十进制 16进制 含义 说明
FIL_PAGE_INDEX 17855 0x45BF B-tree node B+树叶节点
FIL_PAGE_UNDO_LOG 2 0x0002 Undo log page Undo Log页
FIL_PAGE_INODE 3 0x0003 Index node 索引节点
FIL_PAGE_IBUF_FREE_LIST 4 0x0004 Insert buffer free list Insert Buffer空闲列表
FIL_PAGE_TYPE_ALLOCATED 0 0x0000 Freshly allocated page 该页为最新分配
FIL_PAGE_IBUF_BITMAP 5 0x0005 Insert buffer bitmap Insert Buffer位图
FIL_PAGE_TYPE_SYS 6 0x0006 System page 系统页
FIL_PAGE_TYPE_TRX_SYS 7 0x0007 Transaction system data 事务系统数据
FIL_PAGE_TYPE_FSP_HDR 8 0x0008 File space header File Space Header
FIL_PAGE_TYPE_XDES 9 0x0009 Extent descriptor page 扩展描述页
FIL_PAGE_TYPE_BLOB 10 0x000A Uncompressed BLOB page BLOB页
FIL_PAGE_TYPE_ZBLOB 11 0x000B First compressed BLOB page
FIL_PAGE_TYPE_ZBLOB2 12 0x000C Subsequent compressed BLOB page
FIL_PAGE_TYPE_LAST 12 0x000C Last page type

MySQL8.0 File Page Types

  • 来源storage/innobase/include/fil0fil.h
File Page Type 十进制 16进制 含义
FIL_PAGE_INDEX 17855 0x45BF B-tree node
FIL_PAGE_RTREE 17854 0x45BE R-tree node
FIL_PAGE_SDI 17853 0x45BD Tablespace SDI Index page
FIL_PAGE_TYPE_UNUSED 1 0x1 This page type is unused
FIL_PAGE_UNDO_LOG 2 0x2 Undo log page
FIL_PAGE_INODE 3 0x3 Index node
FIL_PAGE_IBUF_FREE_LIST 4 0x4 Insert buffer free list
FIL_PAGE_TYPE_ALLOCATED 0 0x0 Freshly allocated page
FIL_PAGE_IBUF_BITMAP 5 0x5 Insert buffer bitmap
FIL_PAGE_TYPE_SYS 6 0x6 System page
FIL_PAGE_TYPE_TRX_SYS 7 0x7 Transaction system data
FIL_PAGE_TYPE_FSP_HDR 8 0x8 File space header
FIL_PAGE_TYPE_XDES 9 0x9 Extent descriptor page
FIL_PAGE_TYPE_BLOB 10 0xA Uncompressed BLOB page
FIL_PAGE_TYPE_ZBLOB 11 0xB First compressed BLOB page
FIL_PAGE_TYPE_ZBLOB2 12 0xC Subsequent compressed BLOB page
FIL_PAGE_TYPE_UNKNOWN 13 0xD In old tablespaces, garbage in FIL_PAGE_TYPE is replaced with this value when flushing pages
FIL_PAGE_COMPRESSED 14 0xE Compressed page
FIL_PAGE_ENCRYPTED 15 0xF Encrypted page
FIL_PAGE_COMPRESSED_AND_ENCRYPTED 16 0x10 Compressed and Encrypted page
FIL_PAGE_ENCRYPTED_RTREE 17 0x11 Encrypted R-tree page
FIL_PAGE_SDI_BLOB 18 0x12 Uncompressed SDI BLOB page
FIL_PAGE_SDI_ZBLOB 19 0x13 Commpressed SDI BLOB page
FIL_PAGE_TYPE_LEGACY_DBLWR 20 0x14 Legacy doublewrite buffer page.
FIL_PAGE_TYPE_RSEG_ARRAY 21 0x15 Rollback Segment Array page
FIL_PAGE_TYPE_LOB_INDEX 22 0x16 Index pages of uncompressed LOB
FIL_PAGE_TYPE_LOB_DATA 23 0x17 Data pages of uncompressed LOB
FIL_PAGE_TYPE_LOB_FIRST 24 0x18 The first page of an uncompressed LOB
FIL_PAGE_TYPE_ZLOB_FIRST 25 0x19 The first page of a compressed LOB
FIL_PAGE_TYPE_ZLOB_DATA 26 0x1A Data pages of compressed LOB
FIL_PAGE_TYPE_ZLOB_INDEX 27 0x1B Index pages of compressed LOB. This page contains an array of z_index_entry_t objects
FIL_PAGE_TYPE_ZLOB_FRAG 28 0x1C Fragment pages of compressed LOB
FIL_PAGE_TYPE_ZLOB_FRAG_ENTRY 29 0x1E Index pages of fragment pages (compressed LOB)
FIL_PAGE_TYPE_LAST 29 0x1E Note the highest valid non-index page_type_t