Tag
phantoms
- Aug 1, 2024 The Read Phenomena Ladder and What Each Isolation Level Still Permits Why the four SQL isolation levels are defined by the anomalies they forbid rather than the guarantees they give, and which anomalies fall through the definitions. databases
- Nov 24, 2023 Gap Locks and Next-Key Locking in an Index-Ordered Store How a locking engine prevents phantoms by locking the space between index entries, why the locks are taken on index records rather than rows, and what the resulting deadlocks look like. databases