Was going to post this. "Sharding" seems like a better term for communicating the idea.
Re:The Slotted Counter Pattern
by zimpenfish on Monday August 01, 2022 @03:30PM
(#32310978)
I dunno - "sharding" would generally imply (to me, at least) that you're spreading the counters amongst different databases (or tables in a smaller context.) All the counters are in the same table here which is counterintuitive to "sharding".
Semantics
Also, it's basically identical to the pattern described as Counter Tables in "High Performance MySQL" (3rd edition), published in 2012.
Indeed, it also calls them "slots":
> You can get higher concurrency by keeping more than one row and updating a random row... just choose a random slot and update it
https://www.oreilly.com/library/view/high-performance-mysql/...
https://download.huihoo.com/google/gdgdevkit/DVD1/developers...
Also in Brett Slatkin's "Building Scalable Web Apps with App Engine" (2008)
https://youtu.be/Oh9_t5W6MTE?t=1181