Cheat Sheet logoCheat Sheet Today
MySQL Transactions and Locking Cheatsheet/Inspect InnoDB lock and transaction state

Display detailed InnoDB diagnostics.

Back to sheetBrowse commands
Sign in to save
Section: locking and concurrency

Inspect InnoDB lock and transaction state

sql
sql
SHOW ENGINE INNODB STATUS\G
Explanation

A classic source of deadlock and locking information during production troubleshooting.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing locking and concurrency
Set lock wait timeout for the session
Avoid waiting too long on blocked locks.
OpenIn sheetsqlsame section
Lock selected rows for update
Prevent concurrent modifications to matched rows inside a transaction.
OpenIn sheetsqlsame section
Lock rows for shared reads
Read rows while protecting against conflicting writes.
OpenIn sheetsqlsame section
Set transaction isolation level
Control read consistency and concurrency behavior.
OpenIn sheetsqlsame section
Start a transaction
Begin a transaction explicitly.
OpenIn sheetsql
Commit a transaction
Persist all changes made in the current transaction.
OpenIn sheetsql