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
