Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.24, 10.1.12, 10.2.0
-
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
|