Summary of InnoDB Lock Module Articles

Module Summary

This article reviews the 27 previously published pieces on the InnoDB lock module, offering a quick reference for readers interested in MySQL storage engine internals.

Theoretical Articles

Issue 16 : "InnoDB Table Locks" – introduction to various table lock types.

Issue 17 : "What Types of Row Locks Exist in InnoDB?" – explanation of row lock modes and precise locking.

Issue 18 : "What Do Locks Look Like in Memory?" – description of the internal structures of table and row locks.

Issue 19 : "What Is Inside the Lock Module?" – overview of global lock‑module objects and their initialization.

Issue 20 : "How to Acquire Table Locks" – main workflow for adding table locks.

Issues 21‑22 : "Row Lock (1) Fast Locking" and "Row Lock (2) Slow Locking" – main processes for acquiring row locks.

Issue 23 : "Lock Wait" – backend thread handling of lock wait.

Issue 24 : "Lock Wait Timeout" – handling of lock wait timeout.

Issues 25‑27 : "Deadlock (1) Preparation", "Deadlock (2) Detection", and "Deadlock (3) Resolution" – workflow of the background thread that resolves deadlocks.

Issue 28 : "When Are Locks Released?" – timing of row‑lock and AUTO‑INC lock release.

Issue 29 : "Granting Locks" – scenarios for obtaining table and row locks.

Issue 30 : "Detailed Analysis of Deadlock Logs" – explanation of each field in the deadlock log output.

Issue 31 : "Implicit Locks" – definition, detection, and conversion to explicit locks.

Practical Articles

Issue 32 : "Insert Record – Which Lock Is Acquired on Primary‑Key Conflict?"

Issue 33 : "RR Isolation – Lock on Unique‑Index Conflict During Insert"

Issue 34 : "RC Isolation – Lock on Unique‑Index Conflict During Insert"

Issue 35 : "Lock on Primary‑Key Equality Query"

Issue 36 : "Lock on Non‑Unique Index Equality Query"

Issue 37 : "Lock on Primary‑Key Range Query"

Issue 38 : "Lock on Non‑Unique Index Range Query"

Issue 39 : "Deadlock Case Study (1) – Insert Intent Locks"

Issues 40‑42 : "Insert‑On‑Duplicate Lock Analysis (1‑3)" – detailed analysis of row locks added in various duplicate‑key scenarios.

Community Interaction

The article concludes with a community activity inviting readers to share feedback, win prizes, and preview the upcoming Undo log module.