InnoDB Status
Description
The SHOW ENGINE INNODB STATUS command provides a text output of various internal InnoDB Storage Engine Information. A number of SHOW GLOBAL STATUS variables also present the same details.
Syntax
MySQL/MariaDB
mysql> SHOW ENGINE INNODB STATUS;
Drizzle
drizzle> SHOW ENGINE INNODB STATUS;
Example
===================================== INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 41 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3379694, signal count 2214699 Mutex spin waits 0, rounds 102776302, OS waits 1958549 RW-shared spins 2071148, OS waits 908249 ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 93, free list len 59, seg size 153 Hash table size 3112859, used cells 2280051 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1804864688 Buffer pool size 96000 Free buffers 0 Database pages 89947 Buffer pool hit rate 987 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue