News for hackers. Stuff that matters.
Re:The Slotted Counter Pattern by tantalor on Monday August 01, 2022 @01:17PM (#32309194)
Basically same as "Sharding counters" (2008)

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

Re:The Slotted Counter Pattern by ris on Monday August 01, 2022 @01:31PM (#32309377)
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".
Re:The Slotted Counter Pattern by tantalor on Monday August 01, 2022 @07:23PM (#32313406)
Semantics
Re:The Slotted Counter Pattern by iv42 on Monday August 01, 2022 @02:49PM (#32310484)
Also, it's basically identical to the pattern described as Counter Tables in "High Performance MySQL" (3rd edition), published in 2012.
Re:The Slotted Counter Pattern by tantalor on Monday August 01, 2022 @07:57PM (#32313674)
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/...