JavaEdge
Jul 21, 2020 · Databases
Mastering MySQL Row Locks: Two‑Phase Locking, Deadlocks & Performance Tips
This article explains how MySQL implements row‑level locking, the two‑phase locking protocol, common deadlock scenarios with online ticket sales, and practical strategies—including lock ordering, deadlock detection settings and sharding tricks—to improve concurrency and reduce CPU overhead.
deadlockmysqlrow lock
0 likes · 9 min read
