Result of T262856: Investigate indexes of wb_changes.
These three indexes are unused:
wikidatawiki wb_changes wb_changes_change_type wikidatawiki wb_changes wb_changes_change_object_id wikidatawiki wb_changes wb_changes_change_user_id
Removing them improves the load on master of wikidata as this table is pretty heavy write (twice the rate of edits on wikidata).
| Subject | Author | Repo | Branch | Lines +/- | |
|---|---|---|---|---|---|
| Drop three unused indexes from wb_changes | Ladsgroup | mediawiki/extensions/Wikibase | master | +9 -18 |
Change 630224 had a related patch set uploaded (by Ladsgroup; owner: Ladsgroup):
[mediawiki/extensions/Wikibase@master] Drop three unused indexes from wb_changes
Change 630224 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Drop three unused indexes from wb_changes