Page MenuHomePhabricator

Remove table index on br_user_email in bounce_records
Closed, ResolvedPublic

Description

As per comments on https://gerrit.wikimedia.org/r/#/c/176366/ :

9:56 PM <tonythomas> hoo: We will have to change our current index.
9:57 PM <tonythomas> https://github.com/wikimedia/mediawiki-extensions-BounceHandler/blob/master/sql/create_index.sql
9:57 PM <hoo> Either that, or create a new one
9:57 PM <hoo> I think changing should be fine
9:57 PM <hoo> selectivity should be high enough, so that br_user_email doesn't need to be in there.

Event Timeline

01tonythomas raised the priority of this task from to Needs Triage.
01tonythomas updated the task description. (Show Details)
01tonythomas set Security to None.
01tonythomas added subscribers: 01tonythomas, hoo, Legoktm.

Change 181626 had a related patch set uploaded (by M4tx):
Remove index on br_user_email in bounce_records

https://gerrit.wikimedia.org/r/181626

Patch-For-Review

Change 181626 merged by jenkins-bot:
Remove index on br_user_email in bounce_records

https://gerrit.wikimedia.org/r/181626

Legoktm assigned this task to m4tx.

T85248 tracks updating WMF production.

Change 181872 had a related patch set uploaded (by 01tonythomas):
Remove index on br_user_email in bounce_records

https://gerrit.wikimedia.org/r/181872

Patch-For-Review