There are four types of
InnoDB Monitor 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 insert buffer merge activity of the main
InnoDB Lock Monitor is like the
InnoDB Monitor but also provides
extensive lock information.
InnoDB Tablespace Monitor prints a list
of file segments in the shared tablespace and validates the
tablespace allocation data structures.
InnoDB Table Monitor prints the
contents of the
InnoDB internal data
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