Marostegui added a comment.
So a quick look (this needs to be taken with care) reveals that some of them are indeed unused: root@db2091.codfw.wmnet[sys]> select * from schema_unused_indexes where object_name='wb_changes'; +---------------+-------------+-------------------------------+ | object_schema | object_name | index_name | +---------------+-------------+-------------------------------+ | wikidatawiki | wb_changes | wb_changes_change_type | | wikidatawiki | wb_changes | wb_changes_change_object_id | | wikidatawiki | wb_changes | wb_changes_change_user_id | | wikidatawiki | wb_changes | wb_changes_change_revision_id | +---------------+-------------+-------------------------------+ 4 rows in set (0.054 sec) My advise would be to drop these on an active slave and see if we see performance regressions. 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, Akuckartz, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs