Maniphest T85248

Remove br_user_email index in WMF production
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Legoktm
	Dec 23 2014, 9:39 PM

Tags

Referenced Files

None

Subscribers

Description

The schema change in https://gerrit.wikimedia.org/r/181626 needs to be deployed.

Details

	Subject	Repo	Branch	Lines +/-
	Remove index on br_user_email in bounce_records	mediawiki/extensions/BounceHandler	wmf/1.25wmf9	+10 -5

Customize query in gerrit

Related Objects

Mentioned In: T85214: Remove table index on br_user_email in bounce_records

Event Timeline

Legoktm created this task.Dec 23 2014, 9:39 PM

Legoktm raised the priority of this task from to Needs Triage.

Legoktm updated the task description. (Show Details)

Legoktm added projects: MediaWiki-extensions-BounceHandler, WMF-General-or-Unknown.

Legoktm mentioned this in T85214: Remove table index on br_user_email in bounce_records.

Legoktm added subscribers: Legoktm, 01tonythomas, • Springle, aaron.

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

Se4598 added a project: Schema-change.Dec 26 2014, 10:49 PM

Se4598 subscribed.

We had to re-add the index back into the repo as one another select statement was using it with patch: https://gerrit.wikimedia.org/r/#/c/182421/. Once that gets merged, we would want this one too ported to production.

Thanks to https://gerrit.wikimedia.org/r/#/c/182421/ , we have re-added the 'br_user_email' index back. Reedy have created the new index 'br_timestamp' in production:

Reedy> tonythomas: I just did CREATE INDEX /*i*/br_timestamp ON /*_*/bounce_records(br_timestamp);

Se4598 unsubscribed.Jan 29 2015, 7:53 PM

Resolving

Change 181872 abandoned by Hoo man:
Remove index on br_user_email in bounce_records

Reason:
Obsolete

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