Introduction to py_innodb_page_info, innodbpagesize
Py_innodb_page_info
This tool is written by Jiang chengyao, author of MySQL technology insider InnoDB Storage engine, to analyze the types and information of each page in a tablespace and is written in python. I recently read this book. It consists of three files: py_innodb_page_info.py, mylib. py, and include. py. The permission of the three files chmod 755 must be stored in the same directory. Note: py_innodb_page_info is used to view disk files. During running, ensure that all pages in the buffer pool are flushed back to the disk.
Example:
1. py_innodb_page_info.py/usr/local/mysql/data/xiguaproductdb/t_xg_product_sizetable.ibd
2. py_innodb_page_info.py-v/usr/local/mysql/data/xiguaproductdb/t_xg_product_sizetable.ibd
You can use py_innodb_page_info and hexdump to find the values of each part on the mysql DATA page.