mysql -u root -p -e "SHOW ENGINE INNODB STATUS\G"

Category: Databases & SQL

mysql -u root -p -e "SHOW ENGINE INNODB STATUS\G"

Show InnoDB internals

Prints the InnoDB status report: transactions, lock waits, buffer pool, and I/O activity. The \G terminator switches to vertical output so the long text is readable. The first stop for deadlock and lock-wait investigations.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.