Ladsgroup added a comment.
First of all, Sorry it took me so long to comment. Vacation, onboarding, etc. I was involved in the work of collapsing aspects and the changes related. IIRC, The reason we kept hywiki and warwiki was that they were using an inefficient module of Wikidata making them practically subscribe to every property of each item they used and I couldn't fix it because it was protected. That's a long time ago and I think the access pattern has been fixed (and if not, I can change protected modules now). We probably should quickly check if it's fixed for these three (hywiki, cebwiki, warwiki) and also we should check other client wikis to see if the access pattern has changed and possibly change the value of collapsing aspects too (or maybe fix their modules). Regarding hywiki and warwiki, I think it's fine to go ahead with the change but keep track of size of rc table in these wikis and if it's growing too fast (and ratio of rc entries from wikidata is high). Then check their lua modules for obvious mistakes. the plan for cebwiki sounds good to me too. Again, keep track of their rc table (and ratio of rc entries from wikidata) and make sure it doesn't explode. But for commons, I suggest avoiding the change for now (and specially enabling injecting rc entries). Commons database is heavily under pressure, there is space on the disk with the new spec but innodb buffer pool is getting less efficient (to a dangerous value). Finishing the actor migration will help a bit but the actual issue is something that will take a while to fix (T222224 <https://phabricator.wikimedia.org/T222224>). FWIW: these are size of wbc_entity_usage in these wikis: - hywiki: 1.8G - warwiki: 325M - cebwiki: 1.4 GB - commonswiki: 62GB HTH, let me know if I can help with anything. TASK DETAIL https://phabricator.wikimedia.org/T188730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Marostegui, 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, joanna_borun, Bongo-Cat, Invadibot, Devnull, LSobanski, maantietaja, Y.ssk, lmata, Muchiri124, CBogen, Akuckartz, Iflorez, RhinosF1, Legado_Shulgin, ReaperDawn, Nandana, lucamauri, Davinaclare77, Techguru.pc, Lahi, Gq86, GoranSMilovanovic, Hfbn0, QZanden, LawExplorer, Minhnv-2809, Zppix, Poyekhali, _jensen, rosalieper, Taiwania_Justo, Scott_WUaS, Ixocactus, Wong128hk, El_Grafo, Dinoguy1000, faidon, Addshore, Steinsplitter, Mbch331, Jay8g, Krenair, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org