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

huge performance drop after update

    XMLWordPrintable

Details

    Description

      Hi,

      after today update MariaDB from 11.4.5 to 11.4.6 we are facing impact of huge slowdown of SELECT query.

      I am attaching screenshots from older version (11.4.5) and newer (11.4.6).
      + query itself.

      Thank you.

      Attachments

        1. Untitled.png
          Untitled.png
          292 kB
        2. table_structure.sql
          195 kB
        3. Query.txt
          2 kB
        4. BEFORE_UPDATE.png
          BEFORE_UPDATE.png
          210 kB
        5. analyze-json-ok-pretty.json
          10 kB
        6. analyze-json-bad-pretty.json
          10 kB
        7. analyze_json_problematic.txt
          5 kB
        8. analyze_json_ok.txt
          5 kB
        9. AFTER_UPDATE.png
          AFTER_UPDATE.png
          210 kB

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36842 Upgrading MariaDB fails on Ubuntu 24.04

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36766 After upgrade to 10.11.12 we see significant higher InnoDB locking

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36772 After update from 10.11.11 to 10.11.12 thousand times slower

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36766 After upgrade to 10.11.12 we see significant higher InnoDB locking

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36780 In 11.4.6, InnoDB buffer pool reserves all assigned memory even with no/minimum load.

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36785 User report: after upgrade from 11.4.5 to 11.4.6 some tables were not working

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

          Activity

            People

              marko Marko Mäkelä
              shaim Dominik Shaim
              Votes:
              10 Vote for this issue
              Watchers:
              31 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.