Page MenuHomePhabricator

Drop unused indexes of wb_changes
Closed, ResolvedPublic

Description

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).