Innodb 内部结构

一、查看 ibdata1 共享表空间的存储页

通过innochecksum命令查看 ibdata1中的页的分配情况 

[root@master-129 mysql_data]# innochecksum -S ibdata1

File::ibdata1
================PAGE TYPE SUMMARY==============
#PAGE_COUNT	PAGE_TYPE
===============================================
      23	Index page  ##索引页
     199	Undo log page ##Undo页
      12	Inode page  ##节点页
       0	Insert buffer free list page ##buffer页
     378	Freshly allocated page  ##空闲页
       8	Insert buffer bitmap
     138	System page  ##系统页
       1	Transaction system page ##事务页
       9	File Space Header
       0	Extent descriptor page
       0	BLOB page
       0	Compressed BLOB page
       0	Other type of page
===============================================
Additional information:
Undo page type: 103 insert, 96 update, 0 other
Undo page state: 0 active, 199 cached, 0 to_free, 0 to_purge, 0 prepared, 0 other