Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-626

LP:639949 - Non optimal index choice, depending on index creation order

        Details

        • Type: Bug
        • Status: Closed
        • Resolution: Duplicate
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None

          Description

          Hi,

          There are several simple cases where MySQL optimiser doesn't select the right index. This entails strong performance issues, and force the developers to hack their applications, using USE INDEX (when it's possible...)

          This wrong optimizer behaviour is explained in detail here : http://bugs.mysql.com/bug.php?id=36817

          The bugs also occurs both in MariaDB 5.1 & 5.2.

          Since this bug is around for more than 2 years now, I really hope it could be fixed really soon in MariaDB.

          Thanks and regards,
          Jocelyn Fournier

            Gliffy Diagrams

              Attachments

                Issue Links

                is duplicated by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-465 Optimizer : wrong index choice, leading to strong performances issues

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed

                  Activity

                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 639949

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 639949

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      jocelynfournier jocelyn fournier
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      0 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: