#Locking • 2 Articles
Articles tagged with #Locking
A curated list of engineering series, deep dives, and notes related to #Locking.
Engineering Database Internals from First Principles • Part 15 2026-10-06
InnoDB Locking Deep Dive: Record Locks, Gap Locks, and Next-Key Locks
Master MySQL InnoDB locking mechanics: Record locks, Gap locks, Next-Key locks, and the supremum pseudo-record to prevent phantom reads.
Engineering Database Internals from First Principles • Part 8 2026-09-11
Two-Phase Locking (2PL) & Deadlock Resolution: Shared vs Exclusive Lock Mechanics
Understand Strict 2-Phase Locking (2PL), lock hierarchy (S, X, IS, IX), lock compatibility matrices, Wait-For Graph deadlock detection, and rollback cost strategies.