Lucas_Werkmeister_WMDE added a comment.
To summarize, I suggest: - For **warwiki** and **hywiki** (both s3), directly remove `wmgWikibaseDisabledUsageAspects` and treat them like all other wikis. Even in the worst possible case, they’re only expected to reach **40 and 65 million rows** in `wbc_entity_usage`, respectively – which is in the vicinity of frwiki, and well below commonswiki – and most likely it’ll be well below that. - For **cebwiki** (s5), remove `wmgWikibaseDisabledUsageAspects`, but set `$wgWBClientSettings['entityUsageModifierLimits']['C']` to 10 (instead of the default 33). This caps the absolute worst case for cebwiki at **60 million rows** (rather than 165 million). - For **commonswiki** (s4), remove `wmgWikibaseDisabledUsageAspects`, but set `$wgWBClientSettings['entityUsageModifierLimits']['C']` to 3 (instead of the default 33 or cebwiki’s 10). This would grow the table to ca. **990 million rows** (currently 731 million). Note that this one isn’t an unrealistic worst case, I’d expect the table to actually grow to that size or something close to it (but not much more). And then later: - Check how many cebwiki rows have `eu_aspect = 'C'` (rather than `C.P31` etc.). If it’s not very many, then we can estimate how many additional rows the table might get when we remove the custom `$wgWBClientSettings['entityUsageModifierLimits']['C']` and use the default (33) for cebwiki, and hopefully decide to make that change. - Gradually increase the `$wgWBClientSettings['entityUsageModifierLimits']['C']` for commonswiki, checking how many `eu_aspect = 'C'` rows remain each time. At some point we may decide to leave the commonswiki limit at a lower value than 33 indefinitely. Note that the table on each wiki would grow fairly gradually – entity usages would only be updated (i.e. “O” rows be replaced with one or more “C” rows) as each page gets re-parsed. If we wanted to see the effect of our changes within a shorter timeframe, we might have to actively purge pages. #dba <https://phabricator.wikimedia.org/tag/dba/> and #sre <https://phabricator.wikimedia.org/tag/sre/> people: does this sound acceptable to you? TASK DETAIL https://phabricator.wikimedia.org/T188730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Lucas_Werkmeister_WMDE Cc: RP88, Michael, Lucas_Werkmeister_WMDE, hoo, daniel, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226, MZMcBride, Ricordisamoa, iecetcwcpggwqpgciazwvzpfjpwomjxn, jayvdb, Daniel_Mietchen, Tobi_WMDE_SW, Legoktm, Abraham, greg, Wikidata-bugs, liangent, jeremyb, aude, Bianjiang, Aklapper, DixonD, PokestarFan, Ladsgroup, karapayneWMDE, Invadibot, maantietaja, Y.ssk, Muchiri124, CBogen, Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Poyekhali, _jensen, rosalieper, Taiwania_Justo, Scott_WUaS, Ixocactus, Wong128hk, El_Grafo, Dinoguy1000, Addshore, Steinsplitter, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org