Failure#f1
Catalogue / fathom-2020-viral-customer-backlog
One viral Fathom customer backlogs the shared pageview queue, and a slow database disk and unindexed tables prolong it
Fathom Analytics, 2020. Pageview queue and MySQL database.
Records
Failure#f2
Unindexed backlog tables and a text-typed site ID kept the database slow after the disk was fixed
Decision#d1
Cap concurrent queue workers on purpose to protect the database, accepting a bigger backlog
Decision#d2
Limit pageviews processed per site per minute so one viral site cannot block the rest, then drop it
Sign in to read what was chosen, what was rejected and what it cost, each with its place in the source. An account is free.