Ladsgroup added a comment.
While I'm here, I did a quick check on matter of pressure of writes on master. And boy I'm not disappointed: - 6% of all of the write pressure is just this: 95904.00000000001 (6.519%) UPDATE `user` SET `user_editcount` = `user_editcount` + ? WHERE `user_id` = ? AND ( `user_editcount` IS NOT NULL ) In other words, updating user edit count takes 6% of all of writes on master. This is twice as the write pressure of term store!!! I will file a bug for that. - Change dispatching costs us 5% write pressure. Maybe we can optimize it a bit?: 76608.0 (5.208%) UPDATE `wb_changes_dispatch` SET `chd_site` = ? , `chd_db` = ? , `chd_seen` = ? , `chd_touched` = ? , `chd_lock` = ? WHERE `chd_site` = ? - Changes table has write pressure of 1.5 times the write pressure of the term store. We really should clean its design. I assume this would help a lot: T262856: Investigate indexes of wb_changes <https://phabricator.wikimedia.org/T262856>. As matter of read pressure on master, term store is 2% (nice), 11% is `wb_changes_subscription` (maybe needs some improvements) and the rest are core trying to find things to save an edit. Improving read pressure on master is important because it's not scalable (you can't buy more masters). I'm sorry for going a bit off-topic, this is extremely interesting. TASK DETAIL https://phabricator.wikimedia.org/T246415 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Marostegui, Ladsgroup, WMDE-leszek, Aklapper, Addshore, Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, darthmon_wmde, Kent7301, alaa_wmde, joker88john, CucyNoiD, Nandana, jijiki, Klaas_Z4us_V, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, Pablo-WMDE, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, elukey, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs