Aikesheng Open Source Community

Jul 17, 2024 · Databases

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.