MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
There are four types of InnoDB monitors:
The standard InnoDB Monitor displays the
following types of information:
Work done by the main background thread
Semaphore waits
Data about the most recent foreign key and deadlock errors
Lock waits for transactions
Table and record locks held by active transactions
Pending I/O operations and related statistics
Insert buffer and adaptive hash index statistics
Redo log data
Buffer pool statistics
Row operation data
The InnoDB Lock Monitor prints additional
lock information as part of the standard
InnoDB Monitor output.
The InnoDB Tablespace Monitor prints a list
of file segments in the shared tablespace and validates the
tablespace allocation data structures.
The InnoDB Table Monitor prints the
contents of the InnoDB internal data
dictionary.
The Tablespace Monitor and Table Monitor are deprecated;
expect them to be removed in a future MySQL release. Similar
information for the Table Monitor can be obtained from
InnoDB
INFORMATION_SCHEMA tables. See
Section 21.30, “INFORMATION_SCHEMA InnoDB Tables”.
For additional information about InnoDB table
and tablespace monitors, see
Mark Leith: InnoDB
Table and Tablespace Monitors.