InnoDB Information

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

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.