这里需要用到gem,下面是个人wikigem

innodb_ruby是使用Ruby编写的InnoDB文件格式解析器。innodb_ruby的目的是暴露一些其他隐藏的InnoDB原理。

innodb_ruby不适合使用于生产环境，但可以作为学习工具来使用。

查看使用帮助

$ innodb_space --help

$ sudo innodb_space -s ibdata1 system-spaces
/usr/lib/ruby/gems/1.9.1/gems/innodb_ruby-0.9.15/lib/innodb/space.rb:113:in `raw_fsp_header_flags': Something is very wrong; Page 0 does not seem to be type FSP_HDR; got page type 0 but expected 8 (RuntimeError)

space-index-pages-summary errors if table space has never had data #25中提到的方案：

You can use INNODB_BUFFER_PAGE to wait for the page to be flushed to disk.

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE LIMIT 1\G
*************************** 1. row ***************************
	    POOL_ID: 0
	   BLOCK_ID: 0
	      SPACE: 0
	PAGE_NUMBER: 7
	  PAGE_TYPE: ALLOCATED
	 FLUSH_TYPE: 0
	  FIX_COUNT: 0
	  IS_HASHED: NO
NEWEST_MODIFICATION: 0
OLDEST_MODIFICATION: 0
	ACCESS_TIME: 3236903228
	 TABLE_NAME: NULL
	 INDEX_NAME: NULL
     NUMBER_RECORDS: 0
	  DATA_SIZE: 0
    COMPRESSED_SIZE: 0
	 PAGE_STATE: FILE_PAGE
	     IO_FIX: IO_NONE
	     IS_OLD: NO
    FREE_PAGE_CLOCK: 0
1 row in set (0.24 sec)

Invocation examples:

innodb_space -s ibdata1 [-T tname [-I iname]] [options] Use ibdata1 as the system tablespace and load the tname table (and the iname index for modes that require it) from data located in the system tablespace data dictionary. This will automatically generate a record describer for any indexes.

innodb_space -f tname.ibd [-r ./desc.rb -d DescClass] [options] Use the tname.ibd table (and the DescClass describer where required).

The following options are supported:

--help, -? Print this usage text.

--trace, -t Enable tracing of all data read. Specify twice to enable even more tracing (including reads during opening of the tablespace) which can be quite noisy.

--system-space-file, -s Load the system tablespace file or files : Either a single file e.g. "ibdata1", a comma-delimited list of files e.g. "ibdata1,ibdata1", or a directory name. If a directory name is provided, it will be scanned for all files named "ibdata?" which will then be sorted alphabetically and used to load the system tablespace.

--table-name, -T Use the table name .

--index-name, -I Use the index name .

--space-file, -f Load the tablespace file .

--page, -p Operate on the page .

--level, -l Operate on the level .

--list, -L Operate on the list .

--require, -r Use Ruby's "require" to load the file . This is useful for loading classes with record describers.

--describer, -d Use the named record describer to parse records in index pages.

The following modes are supported:

system-spaces Print a summary of all spaces in the system.

data-dictionary-tables Print all records in the SYS_TABLES data dictionary table.

data-dictionary-columns Print all records in the SYS_COLUMNS data dictionary table.

data-dictionary-indexes Print all records in the SYS_INDEXES data dictionary table.

data-dictionary-fields Print all records in the SYS_FIELDS data dictionary table.

space-summary Summarize all pages within a tablespace. A starting page number can be provided with the --page/-p argument.

space-index-pages-summary Summarize all "INDEX" pages within a tablespace. This is useful to analyze page fill rates and record counts per page. In addition to "INDEX" pages, "ALLOCATED" pages are also printed and assumed to be completely empty. A starting page number can be provided with the --page/-p argument.

space-index-pages-free-plot Use Ruby's gnuplot module to produce a scatterplot of page free space for all "INDEX" and "ALLOCATED" pages in a tablespace. More aesthetically pleasing plots can be produced with space-index-pages-summary output, but this is a quick and easy way to produce a passable plot. A starting page number can be provided with the --page/-p argument.

space-page-type-regions Summarize all contiguous regions of the same page type. This is useful to provide an overall view of the space and allocations within it. A starting page number can be provided with the --page/-p argument.

space-page-type-summary Summarize all pages by type. A starting page number can be provided with the --page/-p argument.

space-indexes Summarize all indexes (actually each segment of the indexes) to show the number of pages used and allocated, and the segment fill factor.

space-lists Print a summary of all lists in a space.

space-list-iterate Iterate through the contents of a space list.

space-extents Iterate through all extents, printing the extent descriptor bitmap.

space-extents-illustrate Iterate through all extents, illustrating the extent usage using ANSI color and Unicode box drawing characters to show page usage throughout the space.

space-extents-illustrate-svg Iterate through all extents, illustrating the extent usage in SVG format printed to stdout to show page usage throughout the space.

space-lsn-age-illustrate Iterate through all pages, producing a heat map colored by the page LSN using ANSI color and Unicode box drawing characters, allowing the user to get an overview of page modification recency.

space-lsn-age-illustrate-svg Iterate through all pages, producing a heat map colored by the page LSN producing SVG format output, allowing the user to get an overview of page modification recency.

space-inodes-summary Iterate through all inodes, printing a short summary of each FSEG.

space-inodes-detail Iterate through all inodes, printing a detailed report of each FSEG.

index-recurse Recurse an index, starting at the root (which must be provided in the first --page/-p argument), printing the node pages, node pointers (links), leaf pages. A record describer must be provided with the --describer/-d argument to recurse indexes (in order to parse node pages).

index-record-offsets Recurse an index as index-recurse does, but print the offsets of each record within the page.

index-digraph Recurse an index as index-recurse does, but print a dot-compatible digraph instead of a human-readable summary.

index-level-summary Print a summary of all pages at a given level (provided with the --level/-l argument) in an index.

index-fseg-internal-lists index-fseg-leaf-lists Print a summary of all lists in an index file segment. Index root page must be provided with --page/-p.

index-fseg-internal-list-iterate index-fseg-leaf-list-iterate Iterate the file segment list (whose name is provided in the first --list/-L argument) for internal or leaf pages for a given index (whose root page is provided in the first --page/-p argument). The lists used for each index are "full", "not_full", and "free".

index-fseg-internal-frag-pages index-fseg-leaf-frag-pages Print a summary of all fragment pages in an index file segment. Index root page must be provided with --page/-p.

page-dump Dump the contents of a page, using the Ruby pp ("pretty-print") module.

page-account Account for a page's usage in FSEGs.

page-validate Validate the contents of a page.

page-directory-summary Summarize the record contents of the page directory in a page. If a record describer is available, the key of each record will be printed.

page-records Summarize all records within a page.

page-illustrate Produce an illustration of the contents of a page.

record-dump Dump a detailed description of a record and the data it contains. A record offset must be provided with -R/--record.

record-history Summarize the history (undo logs) for a record. A record offset must be provided with -R/--record.

undo-history-summary Summarize all records in the history list (undo logs).

undo-record-dump Dump a detailed description of an undo record and the data it contains. A record offset must be provided with -R/--record.