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. MDEV_25205.dump.sql.gz.00
          9.00 MB
        2. MDEV_25205.dump.sql.gz.01
          9.00 MB
        3. MDEV_25205.dump.sql.gz.02
          2.44 MB
        4. MDEV-25205.sql
          0.7 kB
        5. msql-10.4.18.txt
          3 kB
        6. msql-10.4.18-analyzed.txt
          3 kB

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            lukav Anton Avramov
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration