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

Suspected periodic performance regression after upgrading MariaDB from 10.6.15 to 11.4.7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 11.4.7
    • N/A
    • None
    • None

    Description

      Report and question regarding how to approach suspected significant periodic performance regression after upgrading MariaDB from 10.6.15 to 11.4.7.

      We have many reads and somewhat less writes on a beefy master MariaDB server​, like below.

      The queries are optimized so that there are no slow queries over 1 second, and we have automated alerts for any queries that are over 1 second.

      After upgrading MariaDB from 10.6.15 to 11.4.7, we suspect a significant performance regression.
      Suddenly we get short time periods where performance drops then is normalized.
      The type of queries we sent during time periods are spread out and should not cause periodic problems.
      Before MariaDB master server upgrade our app profile shows very stable MariaDB performance which are the red stripes below:

      After upgrade our app profile shows unstable MariaDB performance which are the red stripes below:​

      Currently as I can't find anything wrong with our app or queries, I am considering downgrading our MariaDB back which will be a huge task.
      Before I do so, any suggestions on how to approach major performance regression after upgrading MariaDB from 10.6.15 to 11.4.7 like above?

      If MariaDB dev team is interested I would be willing to give direct access to the server through remote screen.

      Thank you.
      Have a nice day.

      Attachments

        1. image-2025-08-10-09-22-51-182.png
          36 kB
          F K
        2. image-2025-08-10-09-23-28-379.png
          63 kB
          F K
        3. image-2025-08-10-09-23-52-083.png
          68 kB
          F K
        4. screenshot-1.png
          22 kB
          F K
        5. my.cnf
          3 kB
          F K

        Activity

          People

            Unassigned Unassigned
            FK F K
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.