SHOW ENGINE INNODB STATUS
SHOW ENGINE INNODB MUTEX
SHOW ENGINE {NDB | NDBCLUSTER} STATUS
SHOW ENGINE PERFORMANCE_SCHEMA STATUS
Displays extensive information from the standard InnoDB Monitor about the state of the InnoDB storage engine.
There are four types of InnoDB monitors:
• 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