Marostegui added a project: mariadb-optimizer-bug. Marostegui added a comment.
Unfortunately hard to tell, but the optimizer behaves differently when there is lots of data and sometimes it does silly things :-(. We have seen over the years, especially with massive tables. The only workaround we've found is sadly, using `FORCE`, `USE` or `IGNORE INDEX` on the queries to bypass those issues. Sometimes issues get fixed by running an `analyze` table so the optimizer gets recent table stats, or just from one version to another. I could try to issue an `analyze` table on the involved tables, to see if that makes some difference. TASK DETAIL https://phabricator.wikimedia.org/T254688 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: aaron, Marostegui Cc: daniel, Lydia_Pintscher, Ladsgroup, Addshore, Aklapper, Marostegui, Akuckartz, darthmon_wmde, WDoranWMF, holger.knust, EvanProdromou, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, Scott_WUaS, Pchelolo, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs