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

Extremely high cpu usage and slow performance after upgrade from 5.5.52 to 10.1.29

    XMLWordPrintable

Details

    Description

      After upgrade from MariaDB 5.5.52 to 10.1.19 the performance of our application is about 5 times slower than before.

      It is noticeable that the MariaDB 10.1.19 has a cpu usage of 95%.
      With MariaDB 5.5.52 the cpu usage was only about 5%.

      I appended 2 pictures which shows the difference between these 2 versions.
      For both versions we used the same server with the same test application.
      The only difference is the upgrade of MariaDB.

      The settings of my.ini are appended.

      Attachments

        1. TimeMeasurement for SQLStatements of MariaDB 5.5.52
          21 kB
          Michael Graf
        2. TimeMeasurement for SQLStatements of MariaDB 10.1.19.txt
          21 kB
          Michael Graf
        3. status.txt
          492 kB
          Michael Graf
        4. procdump_output.txt
          4 kB
          Michael Graf
        5. Performance of MariaDB 5.5.52.png
          258 kB
          Michael Graf
        6. Performance of MariaDB 10.1.19.png
          221 kB
          Michael Graf
        7. mysqld.exe.2160.crc
          0.1 kB
          Michael Graf
        8. mysqld.exe.2160.002
          1.42 MB
          Michael Graf
        9. mysqld.exe.2160.001
          10.00 MB
          Michael Graf
        10. mysqld.exe_161202_180716.crc
          0.1 kB
          Michael Graf
        11. mysqld.exe_161202_180716.015
          207 kB
          Michael Graf
        12. mysqld.exe_161202_180716.014
          10.00 MB
          Michael Graf
        13. mysqld.exe_161202_180716.013
          10.00 MB
          Michael Graf
        14. mysqld.exe_161202_180716.012
          10.00 MB
          Michael Graf
        15. mysqld.exe_161202_180716.011
          10.00 MB
          Michael Graf
        16. mysqld.exe_161202_180716.010
          10.00 MB
          Michael Graf
        17. mysqld.exe_161202_180716.009
          10.00 MB
          Michael Graf
        18. mysqld.exe_161202_180716.008
          10.00 MB
          Michael Graf
        19. mysqld.exe_161202_180716.007
          10.00 MB
          Michael Graf
        20. mysqld.exe_161202_180716.006
          10.00 MB
          Michael Graf
        21. mysqld.exe_161202_180716.005
          10.00 MB
          Michael Graf
        22. mysqld.exe_161202_180716.004
          10.00 MB
          Michael Graf
        23. mysqld.exe_161202_180716.003
          10.00 MB
          Michael Graf
        24. mysqld.exe_161202_180716.002
          10.00 MB
          Michael Graf
        25. mysqld.exe_161202_180716.001
          10.00 MB
          Michael Graf
        26. mysqld.exe_161128_064117.crc
          0.1 kB
          Michael Graf
        27. mysqld.exe_161128_064117.002
          7.03 MB
          Michael Graf
        28. mysqld.exe_161128_064117.001
          10.00 MB
          Michael Graf
        29. my.ini
          1 kB
          Michael Graf
        30. MariaDB 10.1.19 caches 400000.png
          77 kB
          Michael Graf
        31. MariaDB 10.1.19 caches 40000.png
          111 kB
          Michael Graf
        32. MariaDB_5.5.52.png
          78 kB
          Michael Graf
        33. callstacks_10_1_19.txt
          43 kB
          Vladislav Vaintroub

        Activity

          People

            axel Axel Schwenke
            migra Michael Graf
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.