共享表空间ibdata1的分析

最近在看《mysql技术内幕 innodb存储引擎》一书，当看到书本第95页时，作者介绍了一个强大功能的python脚本，用来查看表空间中各页的类型和信息，py_innodb_page_info.py。
下载地址：
http://david-mysql-tools.googlecode.com/svn-history/r15/trunk/py_innodb_page_type/，

下载内容：
#wget http://david-mysql-tools.googlecode.com/svn-history/r15/trunk/py_innodb_page_type/py_innodb_page_info.py
#wget http://david-mysql-tools.googlecode.com/svn-history/r15/trunk/py_innodb_page_type/mylib.py
#wget http://david-mysql-tools.googlecode.com/svn-history/r15/trunk/py_innodb_page_type/include.py

注意：需要将三个脚本放在同一目录下
测试下是否成功：
[root@localhost ~]# python py_innodb_page_info.py /data/mysql/ibdata1                        
                
Total number of page: 1152:
Insert Buffer Bitmap: 2
System Page: 244
Transaction system Page: 2
Freshly Allocated Page: 870
Undo Log Page: 7
File Segment inode: 4
B-tree Node: 21
File Space Header: 2

 

转自：

https://blog.51cto.com/linchao52/1352317