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

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)

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