Settings and activity
6 results found
-
9 votesAdminJean-François Gagné (Senior Software Engineer, Aiven.io) supported this idea ·
-
3 votesAdminJean-François Gagné (Senior Software Engineer, Aiven.io) supported this idea ·
-
5 votesAdminJean-François Gagné (Senior Software Engineer, Aiven.io) supported this idea ·
-
2 votesAdminJean-François Gagné (Senior Software Engineer, Aiven.io) supported this idea ·
-
2 votes
An error occurred while saving the comment AdminJean-François Gagné (Senior Software Engineer, Aiven.io) supported this idea · -
8 votesAdminJean-François Gagné (Senior Software Engineer, Aiven.io) supported this idea ·
Another interesting optimizer_switch: prefer-ordering-index
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html#optflag_prefer-ordering-index
Explanations:
https://blog.jcole.us/2019/09/30/reconsidering-access-paths-for-index-ordering-a-dangerous-optimization-and-a-fix/
https://jfg-mysql.blogspot.com/2022/11/bad-optimizer-plan-on-queries-combining-where-order-by-and-limit.html
https://hackmysql.com/post/infamous-order-by-limit-query-optimizer-bug/