Page MenuHomePhabricator

Tracking task for mariadb optimizer misbehaviours
Closed, DeclinedPublic

Description

This is a tracking task to track those queries where we have had to place an IGNORE, FORCE, USE index to by pass odd behaviours from the optimizer, that chooses a wrong plan.
This should reviewed once we change versions to see if we can delete these tricks

T223151#5508604 https://gerrit.wikimedia.org/r/#/c/538326/
T71222#4994266 https://gerrit.wikimedia.org/r/#/c/494256/

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 23 2019, 8:11 AM
Marostegui triaged this task as Medium priority.Sep 23 2019, 8:12 AM

Please feel free to edit this task to keep adding past issues (I have added the most recent cases I remember)

Sorry - I wasn't aware of that, I have requested a new tag for it: T233589

Marostegui closed this task as Declined.Oct 4 2019, 8:44 AM

Closing this and will use mariadb-optimizer-bug tag to mark the affected tasks.