17.17.1 InnoDB Monitor Types

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

17.17.1 InnoDB Monitor Types

There are two types of InnoDB monitor:

  • The standard InnoDB Monitor displays the following types of information:

  • Work done by the main background thread

  • Semaphore waits
  • 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
  • The InnoDB Lock Monitor prints additional lock information as part of the standard InnoDB Monitor output.