Maniphest T257132

Wow let's look at that contribution_status_id index again
Closed, ResolvedPublic1 Estimated Story Points
Actions

Assigned To

Eileenmcnaughton

Authored By

	Eileenmcnaughton
	Jul 5 2020, 2:53 AM

Tags

Referenced Files

None

Subscribers

Eileenmcnaughton

Description

I accidentally tested the benefits of dropping the contribution_status_id index on staging 'approving' a query because it took a few minutes on staging some weeks after forgetting I'd removed the contribution_status_id index. Then when deployed in prod the query had to be killed after 41 hours. I think that makes the case that the possible benefit of keeping it (mostly when searching for cancelled or other non-completed contributions) might not be the winning concern

https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/tools/+/609555

Related Objects

Mentioned In: T247489: My testing suggests that REMOVING the contribution_status_id (& low-cardinality indexes like is_deleted) will speed up queries
T252245: Add and delete fields from the _all_Wikimedia database (civi export to ESP)

Event Timeline

Eileenmcnaughton created this task.Jul 5 2020, 2:53 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 5 2020, 2:53 AM

Eileenmcnaughton updated the task description. (Show Details)Jul 5 2020, 2:56 AM

Eileenmcnaughton mentioned this in T252245: Add and delete fields from the _all_Wikimedia database (civi export to ESP).Jul 5 2020, 5:10 AM

• DStrine moved this task from Triage to Sprint +3 on the Fundraising-Backlog board.Jul 6 2020, 8:31 PM

Eileenmcnaughton mentioned this in T247489: My testing suggests that REMOVING the contribution_status_id (& low-cardinality indexes like is_deleted) will speed up queries.Aug 25 2020, 12:05 AM

Eileenmcnaughton added a project: fundraising Sprint Quackery limited to ducks.Aug 25 2020, 2:00 AM

Eileenmcnaughton set the point value for this task to 1.

Eileenmcnaughton set Final Story Points to 1.

Eileenmcnaughton moved this task from Backlog to Done on the fundraising Sprint Quackery limited to ducks board.

• DStrine moved this task from Sprint +3 to Triage on the Fundraising-Backlog board.Aug 25 2020, 5:54 PM

• DStrine moved this task from Triage to Current Sprint on the Fundraising-Backlog board.Aug 25 2020, 7:38 PM

As a user, I would like indexes on contribution_status_id not to be a barrier to exporting or searching data in a timely manner

Eileenmcnaughton closed this task as Resolved.Aug 27 2020, 4:37 AM

Eileenmcnaughton claimed this task.

• DStrine removed a subscriber: • mepps.Feb 17 2021, 4:27 PM