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

OLTP performance drop 10.0.22 - 10.0.26

    XMLWordPrintable

    Details

    • Sprint:
      10.0.28, 5.5.55, 10.0.30

      Description

      Sysbench OLTP test shows a performance drop of about 2.16% between
      10.0.22 and 10.0.26.

      System

      uname -a
      Linux ubuntu-trusty-amd64 3.13.0-10-generic #30-Ubuntu SMP Tue Feb 18 23:06:46 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
      

      Build command

      cmake .. -DWITH_SSL=system -DCMAKE_INSTALL_PREFIX=../install && make -j5 install
      

      TPS of 3-runs:

      MariaDB 10.0.22: 173294 (2888.12 per sec.), 174620 (2910.24 per sec.), 173791 (2892.08 per sec.)
       
      MariaDB 10.0.26: 169879 (2831.20 per sec.), 169983 (2832.94 per sec.), 170327 (2838.68 per sec.)
      

      Detailed sysbench output:

      On MariaDB-10.0.22:
       
      sysbench --test=oltp --oltp-table-size=100000 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock prepare
      sysbench --test=oltp --oltp-table-size=100000 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run
       
      sysbench 0.4.12:  multi-threaded system evaluation benchmark
       
      No DB drivers specified, using mysql
      Running the test with following options:
      Number of threads: 8
       
      Doing OLTP test.
      Running mixed OLTP test
      Doing read-only test
      Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
      Using "BEGIN" for starting transactions
      Using auto_inc on the id column
      Threads started!
      Time limit exceeded, exiting...
      (last message repeated 7 times)
      Done.
       
      OLTP test statistics:
          queries performed:
              read:                            2426116
              write:                           0
              other:                           346588
              total:                           2772704
          transactions:                        173294 (2888.12 per sec.)
          deadlocks:                           0      (0.00 per sec.)
          read/write requests:                 2426116 (40433.72 per sec.)
          other operations:                    346588 (5776.25 per sec.)
       
      Test execution summary:
          total time:                          60.0023s
          total number of events:              173294
          total time taken by event execution: 479.5250
          per-request statistics:
               min:                                  1.22ms
               avg:                                  2.77ms
               max:                                154.85ms
               approx.  95 percentile:               2.87ms
       
      Threads fairness:
          events (avg/stddev):           21661.7500/311.98
          execution time (avg/stddev):   59.9406/0.00
       
       
      On MariaDB-10.0.26:
      sysbench --test=oltp --oltp-table-size=100000 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock prepare
      sysbench --test=oltp --oltp-table-size=100000 --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql.sock --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run
      sysbench 0.4.12:  multi-threaded system evaluation benchmark
       
      No DB drivers specified, using mysql
      Running the test with following options:
      Number of threads: 8
       
      Doing OLTP test.
      Running mixed OLTP test
      Doing read-only test
      Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
      Using "BEGIN" for starting transactions
      Using auto_inc on the id column
      Threads started!
      Time limit exceeded, exiting...
      (last message repeated 7 times)
      Done.
       
      OLTP test statistics:
          queries performed:
              read:                            2378306
              write:                           0
              other:                           339758
              total:                           2718064
          transactions:                        169879 (2831.20 per sec.)
          deadlocks:                           0      (0.00 per sec.)
          read/write requests:                 2378306 (39636.74 per sec.)
          other operations:                    339758 (5662.39 per sec.)
       
      Test execution summary:
          total time:                          60.0026s
          total number of events:              169879
          total time taken by event execution: 479.5191
          per-request statistics:
               min:                                  1.23ms
               avg:                                  2.82ms
               max:                                194.25ms
               approx.  95 percentile:               3.34ms
       
      Threads fairness:
          events (avg/stddev):           21234.8750/428.81
          execution time (avg/stddev):   59.9399/0.01
      

        Attachments

          Activity

            People

            Assignee:
            axel Axel Schwenke
            Reporter:
            nirbhay_c Nirbhay Choubey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 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.