[mysql] InnoDB 文件数据页File Header结构

博客首页 » mysql InnoDB 文件数据页File Header结构

发布于 02 Mar 2015 08:16
标签 blog
Fields
Bytes Name
4 FIL_PAGE_SPACE_OR_CHKSUM (in < MySQL-4.0.14 tablespace id, otherwise checksum)
4 FIL_PAGE_OFFSET (offset in tablespace)
4 FIL_PAGE_PREV
4 FIL_PAGE_NEXT
8 FIL_PAGE_LSN (lsn of the end of the newest modification)
2 FIL_PAGE_TYPE
8 FIL_PAGE_FILE_FLUSH_LSN
4 FIL_PAGE_ARCH_LOG_NO_OR_SPACE_ID

Source Code
storage/innodb_plugin/include/fil0fil.h

其中FIL PAGE TYPE
Hex Name
45BF FIL_PAGE_INDEX
2 FIL_PAGE_UNDO_LOG
3 FIL_PAGE_INODE
4 FIL_PAGE_IBUF_FREE_LIST
0 FIL_PAGE_TYPE_ALLOCATED
5 FIL_PAGE_IBUF_BITMAP (Insert Buffer Bitmap)
6 FIL_PAGE_TYPE_SYS
7 FIL_PAGE_TYPE_TRX_SYS
8 FIL_PAGE_TYPE_FSP_HDR
9 FIL_PAGE_TYPE_XDES
A FIL_PAGE_TYPE_BLOB
B FIL_PAGE_TYPE_ZBLOB
C FIL_PAGE_TYPE_ZBLOB2


本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用,仅有一个特殊要求,请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。


系列文章

文章列表

  • mysql InnoDB 文件数据页File Header结构

这篇文章对你有帮助吗,投个票吧?

rating: 0+x

留下你的评论

Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License