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

MariaDB 10.6.11 performance 65% slower than MySQL 8.0.32

    XMLWordPrintable

Details

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

    Description

      Hi guys,

      Here is the benchmark result :

      When MySQL reaches the 100 virtual users (vUSER), it can easily reach 2.5 million or more transactions per minute (TPM).
      MariaDB cannot even reach 1 million TPM.
      What is going on with MariaDB's performance? Why does it seem to be throttled to under 1 million TPM?

      Please show me the right direction to improve the MariaDB configuration and maybe match the MySQL 8 performance.

      Regards.
      Irwandy.

      Attachments

        1. image-2023-01-30-09-28-41-271.png
          image-2023-01-30-09-28-41-271.png
          22 kB
        2. image-2023-01-30-23-14-59-419.png
          image-2023-01-30-23-14-59-419.png
          31 kB
        3. 10.8.7-MariaDB_vs_mysql8.png
          10.8.7-MariaDB_vs_mysql8.png
          29 kB
        4. innodb_io_data_writes.png
          innodb_io_data_writes.png
          46 kB
        5. innodb_io_writes.png
          innodb_io_writes.png
          72 kB
        6. mariadb_vs_mysql_NOPM.png
          mariadb_vs_mysql_NOPM.png
          31 kB
        7. tpcc2.png
          tpcc2.png
          13 kB
        8. mariadbmysql4.png
          mariadbmysql4.png
          32 kB
        9. mariadbmysql1.png
          mariadbmysql1.png
          46 kB
        10. mariadbmysql2.png
          mariadbmysql2.png
          35 kB
        11. mariadbmysql3.png
          mariadbmysql3.png
          47 kB
        12. mariadbmysql5.png
          mariadbmysql5.png
          29 kB
        13. fg_mdb11_withsps.svg
          720 kB
        14. fg_mysql57_withsps.svg
          575 kB
        15. fg_mysql8_withsps.svg
          647 kB

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              e1d Irwandy
              Votes:
              2 Vote for this issue
              Watchers:
              15 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.