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.
For additional information about
Mark Leith: InnoDB Table and Tablespace Monitors