BestHub
Sign in
Tagged articles

Row Locking

4 articles · Page 1 of 1
LuTiao Programming
LuTiao Programming
Sep 27, 2026 · Backend Development

Why the 101st Waitlist User Never Gets Skipped: Atomic Promotion with MySQL Row Locks

This article demonstrates how to implement a correct waitlist auto-promotion system for limited-capacity events using Spring Boot, MySQL InnoDB row locks, and database transactions to atomically handle cancellations and promotions without race conditions, ensuring the first waitlisted user always gets the freed spot.

Database TransactionsInnoDBJava 17
0 likes · 12 min read
Why the 101st Waitlist User Never Gets Skipped: Atomic Promotion with MySQL Row Locks
IT Services Circle
IT Services Circle
Sep 25, 2026 · Databases

Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC uses version chains and ReadViews to enable lock-free snapshot reads, why isolation levels control ReadView creation timing (per-statement vs per-transaction), and why READ UNCOMMITTED and SERIALIZABLE bypass MVCC entirely, while writes still require row locks.

InnoDBMVCCMySQL
0 likes · 8 min read
Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 26, 2024 · Databases

Slow Locking Logic in MySQL InnoDB

This article explains the slow‑path row‑locking algorithm used by InnoDB in MySQL 8.0.32, detailing how the engine checks whether a transaction already holds a lock, determines if it must wait, reuses existing lock structures, and allocates new ones when necessary.

Database InternalsInnoDBMySQL
0 likes · 15 min read
Slow Locking Logic in MySQL InnoDB