Understanding InnoDB Deadlock Detection Thread and Lock‑Wait Snapshot Construction

This article explains how InnoDB simulates deadlocks, how the ib_srv_lock_to background thread checks for deadlocks, how it builds lock‑wait snapshots, constructs lock‑wait graphs, calculates transaction weights, and finally resolves deadlocks, illustrated with detailed SQL examples and code snippets.

InnoDBlock-waitmysql

0 likes · 14 min read

Understanding InnoDB Deadlock Detection Thread and Lock‑Wait Snapshot Construction