[01:50:37] <wikibugs>	 6MediaWiki-API-Team, 10MediaWiki-extensions-CentralAuth, 10SUL-Finalization, 5Patch-For-Review: SULF renameuser jobs slow on mediawikiwiki and queries timing out - https://phabricator.wikimedia.org/T96489#1218306 (10Legoktm) From #wikimedia-operations: ``` [18:26:14] <springle> legoktm: 22K queries/sec on...
[01:59:39] <Keegan>	 legoktm: If you're around and can do a daily update of how many renames we've done and what wiki we are at so I can add it to my daily c-level update, that'd be swell. If not, it's Saturday night, I don't blame you :)
[02:02:38] <legoktm>	 Keegan: we're done with all small and medium except for mediawikiwiki which was skipped, and currently on arwiki, the first large one
[02:02:53] * Keegan nods
[02:03:50] <legoktm>	 653,495 renames done as of a few minutes ago
[02:05:13] <Keegan>	 Very nice
[02:05:21] <Keegan>	 Why was mediawiki skipped?
[02:06:49] <legoktm>	 https://phabricator.wikimedia.org/T96489 lots of s3 queries, it was probably just going to fast
[02:07:18] <Keegan>	 Okay, cool. Thank you sir.
[02:14:04] <twentyafterfour>	 https://code.facebook.com/projects/577808328939952/rocksdb/  looks interesting... may be a good upgrade for the mediawiki localization cache?
[03:07:38] <wikibugs>	 6MediaWiki-API-Team, 10MediaWiki-extensions-CentralAuth, 10SUL-Finalization, 5Patch-For-Review: SULF renameuser jobs slow on mediawikiwiki and queries timing out - https://phabricator.wikimedia.org/T96489#1218335 (10aaron) I've seen these lock waits on prior runs. They are probably for users with no actual...
[03:30:12] <legoktm>	 blazecat: serialize?
[03:30:26] <blazecat>	 queue up
[03:30:33] <legoktm>	 ah
[03:54:29] <wikibugs>	 6MediaWiki-API-Team, 10MediaWiki-extensions-CentralAuth, 10SUL-Finalization, 5Patch-For-Review: SULF renameuser jobs slow on mediawikiwiki and queries timing out - https://phabricator.wikimedia.org/T96489#1218344 (10aaron) Anyway, the real problem is that lots of users may have no deleted edits, making the...