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

Performance regression occurs with update statements after f11504a

    XMLWordPrintable

Details

    Description

      After commit f11504a, MariaDB performance appears to be degraded when executing the update statement:

      UPDATE comments SET post_id=post_id+1 WHERE id>1000;
      

      We tested it using mysqlslap with the following test statement:

       ./mysqlslap --concurrency=1 --iterations=1 --create-schema=test --query="$mariaDB_inst" -uroot -S $(pwd)/bin/mysql.sock --number-of-queries=10000
      

      The result of the test statement is as follows:

      Before f11504a:
      Average number of seconds to run all queries: 540.658 seconds
      Minimum number of seconds to run all queries: 540.658 seconds
      Maximum number of seconds to run all queries: 540.658 seconds
      Number of clients running queries: 1
      Average number of queries per client: 10000

      After f11504a:
      Average number of seconds to run all queries: 574.658 seconds
      Minimum number of seconds to run all queries: 574.658 seconds
      Maximum number of seconds to run all queries: 574.658 seconds
      Number of clients running queries: 1
      Average number of queries per client: 10000

      you can pre-populated data by init.sql and insert.sql

      Attachments

        1. init.sql
          3 kB
          JinzeSi
        2. insert.sql
          6.04 MB
          JinzeSi

        Issue Links

          Activity

            People

              bar Alexander Barkov
              Jinze JinzeSi
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.