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

Query completes quickly on 10.5. Same query gets bogged down and never completes on 10.11.

    XMLWordPrintable

Details

    • Q4/2025 Server Maintenance

    Description

      The query has many subqueries with EXISTS (SELECT ...)

      10.5 can handle all 26 of these.
      10.11 can reach up to 11 of these at which point it gets exponentially slower for each subquery added.

      Attachments

        1. 1.zip
          73 kB
        2. CS0757389_TEST.zip
          559 kB
        3. otf.json
          71 kB
        4. ots.json
          1.02 MB
        5. postgres.sql
          4 kB
        6. query_very_slow_10.11.png
          query_very_slow_10.11.png
          46 kB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36331 Optimizer prunes efficient join orders when optimizer_prune_level=1

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            People

              psergei Sergei Petrunia
              edward Edward Stoever
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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