FinancePlanetScalealmost 4 years ago
The Slotted Counter Pattern
4 min read
A single-row counter in MySQL causes contention and deadlocks under parallel write bursts. GitHub and PlanetScale engineers solved this with a slotted counters table that distributes increments across multiple rows, reducing lock waits and improving concurrency.
Level
Hype check
Tap to vote and see what everyone thinks.