There are four types of
InnoDBMonitor displays the following types of information:
Table and record locks held by each active transaction.
Lock waits of a transaction.
Semaphore waits of threads.
Pending file I/O requests.
Buffer pool statistics.
Purge and change buffer merge activity of the main
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.29, “INFORMATION_SCHEMA Tables for InnoDB”.
For additional information about
Mark Leith: InnoDB Table and Tablespace Monitors