There are four types of
InnoDBMonitor displays the following types of information:
Work done by the main background thread
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
InnoDBLock Monitor prints additional lock information as part of the standard
InnoDBTablespace Monitor prints a list of file segments in the shared tablespace and validates the tablespace allocation data structures.
InnoDBTable Monitor prints the contents of the
InnoDBinternal data dictionary.Note
The Tablespace Monitor and Table Monitor are deprecated and will be removed in a future MySQL release. Similar information for the Table Monitor can be obtained from
INFORMATION_SCHEMAtables. See Section 21.30, “INFORMATION_SCHEMA InnoDB Tables”.
For additional information about
and tablespace monitors, see
Mark Leith: InnoDB
Table and Tablespace Monitors.