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

Query regression after running analyze on 10.4.18

    XMLWordPrintable

Details

    Description

      We have a query that was running for about 0.7 sec on avarage on mariadb server 10.4.17.
      After upgrade to 10.4.18 the query still takes about 0.7.
      However after running analyze on the tables the query starts running for 2.2 sec.

      If I downgrade the server binary to 10.4.17 the query still takes 2.2 sec, but after running analyze again it goes back to 0.7 sec

      I'm attaching here explain and analyze of the query before and after running the analyze.
      Unfortunatelly I cannot provide a dump of the tables, since the data is private.

      I'll be happy to run more tests for you or provide you with more information to fix that regression.

      Attachments

        1. msql-10.4.18-analyzed.txt
          3 kB
        2. msql-10.4.18.txt
          3 kB
        3. MDEV-25205.sql
          0.7 kB
        4. MDEV_25205.dump.sql.gz.02
          2.44 MB
        5. MDEV_25205.dump.sql.gz.01
          9.00 MB
        6. MDEV_25205.dump.sql.gz.00
          9.00 MB

        Activity

          People

            psergei Sergei Petrunia
            lukav Anton Avramov
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.