Page MenuHomePhabricator

Enable statement usage tracking on cebwiki
Open, Needs TriagePublic

Description

As agreed in T188730#7461581 and T188730#7525888, we want to remove the wmgWikibaseDisabledUsageAspects setting for Cebuano Wikipedia, and set $wgWBClientSettings['entityUsageModifierLimits']['C'] to 10 (instead of the default 33). This is expected to increase the number of rows in the wbc_entity_usage to no more than 60 million, most likely much less (currently 14.6 million). We should keep track of the size of the table after making the change, as well as the size of the recentchanges table and the ratio of Wikidata edits there, and check on-wiki Lua modules for obvious mistakes if it grows too large.

Acceptance criteria:

  • cebwiki is removed from the wmgWikibaseDisabledUsageAspects setting
  • a new setting for limiting usage tracking for claims is added to initialliseSettings.php
  • the setting value for cebwiki is set to 10
  • $wgWBClientSettings['entityUsageModifierLimits']['C'] is set to the new setting in Wikibase.php
NOTE: once deployed, we should make sure data is being tracked under "Statement Flags" in the cebwiki dashboard https://grafana.wikimedia.org/d/000000176/wikidata-entity-usage-project?orgId=1&var-project=cebwiki

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
OpenNone
Opennoarave

Event Timeline

2021-11-24:

lucaswerkmeister-wmde@stat1007:~$ sudo -u analytics-wmde analytics-mysql cebwiki <<< 'SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = "cebwiki" AND table_name IN ("wbc_entity_usage", "recentchanges");' | expand -t20
table_name          table_rows
recentchanges       841431
wbc_entity_usage    13725390

Change 754933 had a related patch set uploaded (by Noa wmde; author: Noa wmde):

[operations/mediawiki-config@master] Enable usage tracking for statement for cebwiki

https://gerrit.wikimedia.org/r/754933

Change 754937 had a related patch set uploaded (by Noa wmde; author: Noa wmde):

[operations/mediawiki-config@master] Introduce $wmgEntityUsageModifierLimitsStatement

https://gerrit.wikimedia.org/r/754937