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

With large number of indexes optimizer chooses an inefficient plan

Details

    Description

      With a large number of indexes the optimizer picks the wrong path.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24117 Memory management problem in statistics state for queries that have a large field IN (values) part

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          mentioned in

          Page Failed to load

          Activity

            Ascending order - Click to sort in descending order
            kjoiner Kyle Joiner (Inactive) created issue -
            kjoiner Kyle Joiner (Inactive) made changes -
            Field Original Value New Value
            Assignee Kyle Joiner [ kjoiner ]
            kjoiner Kyle Joiner (Inactive) made changes -
            Assignee Kyle Joiner [ kjoiner ] Igor Babaev [ igor ]
            igor Igor Babaev (Inactive) made changes -
            Fix Version/s 10.2 [ 14601 ]
            igor Igor Babaev (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            igor Igor Babaev (Inactive) made changes -
            Assignee Igor Babaev [ igor ] Sergei Petrunia [ psergey ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ] Igor Babaev [ igor ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            igor Igor Babaev (Inactive) made changes -
            Component/s Optimizer [ 10200 ]
            Fix Version/s 10.2.35 [ 25022 ]
            Fix Version/s 10.3.26 [ 25021 ]
            Fix Version/s 10.4.16 [ 25020 ]
            Fix Version/s 10.5.7 [ 25019 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            alice Alice Sherepa made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels ServiceNow
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels ServiceNow 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z
            serg Sergei Golubchik made changes -
            Labels 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 113818 ] MariaDB v4 [ 158398 ]
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201658 122644
            Zendesk active tickets 201658

            People

              igor Igor Babaev (Inactive)
              kjoiner Kyle Joiner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.