As a PM, I want to report on the success or failure of interventions from epic T401284 by measuring any changes in the contents of recentchanges and wbc_entity_usage tables of client wikis.

We hope to reduce database load in recentchanges by 30%, without incurring a significantly higher load in wbc_entity_usage. For the purposes, we will sample the following wikis: enwiki, dewiki, frwiki (large wikis), arwiki, dagwiki, cawiki (smaller wikis)

Acceptance criteria

• Make a spreadsheet for tracking db numbers over time (see comment below)
• Take numbers in recent changes:
  • Before any intervention is rolled out
  • 4 weeks after T401288 and T401286 are rolled out
  • 6 weeks after T401288 and T401286 are rolled out
  • 8 weeks after T401288 and T401286 are rolled out
• Take numbers in wbc_entity_usage:
  • Before any intervention is rolled out
  • 1 day after T401288 is rolled out
  • 3 days T401288 is rolled out
  • 5 days T401288 is rolled out
  • 4 weeks after T401288 and T401286 are rolled out
• Do overall analysis of recentchanges and wbc_entity_usage 8 weeks after T401288 and T401286 are rolled out, and liaise with DBAs to decide if further interventions are required to keep wikibase changes propagated to clients.