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 were deprecated in MySQL 5.6.3 and have been removed in MySQL 5.7.4. For the Tablespace Monitor, equivalent functionality will be introduced before the GA release of MySQL 5.7. For the Table Monitor, equivalent information can be obtained from
For additional information about
Mark Leith: InnoDB Table and Tablespace Monitors