Page MenuHomePhabricator

Check that all UserMerge hooked extensions actually have the proper indexes for UserMerge queries
Open, Needs TriagePublic

Description

For example, today we discovered that image and flaggedrevs don't have indexes on the fields we use in our queries.

Event Timeline

Legoktm created this task.Jul 10 2015, 3:43 AM
Legoktm raised the priority of this task from to Needs Triage.
Legoktm updated the task description. (Show Details)
Legoktm added a subscriber: Legoktm.
Restricted Application added subscribers: Steinsplitter, Aklapper. · View Herald TranscriptJul 10 2015, 3:43 AM

Core tables:

  • image has index on img_user_text
  • filearchive has file_user_timestamp which uses fa_user_text
  • oldimage has oi_usertext_timestamp which uses oi_user_text
  • recentchanges has rc_user_text which uses rc_user_text
  • No index for ipblocks.ipb_by