Marostegui added a comment.
I can also try to live capture some on db2084. In T262856#6486318 <https://phabricator.wikimedia.org/T262856#6486318>, @Ladsgroup wrote: > Mostly are straightforward but I actually found a query on master in the code that's like this (found it in performance schema of db2079 too): > > SELECT `change_id` , `change_type` , `change_time` , `change_object_id` , `change_revision_id` , `change_user_id` , `change_info` FROM `wb_changes` WHERE `change_revision_id` = ? LIMIT ? > > (With exec count of ~12,510,000 and total latency of 3150724249736000) so I think we need to bring back the index on revision id but the rest can be safely dropped. Doing that now TASK DETAIL https://phabricator.wikimedia.org/T262856 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Kormat, Marostegui, Lucas_Werkmeister_WMDE, Addshore, Aklapper, Ladsgroup, LSobanski, Akuckartz, Iflorez, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
