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/
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Declined | None | T233579 Tracking task for mariadb optimizer misbehaviours | |||
| Resolved | Marostegui | T223151 Review special replica partitioning of certain tables by `xx_user` | |||
| Resolved | Marostegui | T233625 Change PK and remove partitions from the logging table | |||
| Resolved | Marostegui | T239453 Remove partitions from revision table | |||
| Resolved | Anomie | T71222 list=logevents slow for users with last log action long time ago |
Please feel free to edit this task to keep adding past issues (I have added the most recent cases I remember)