4 threads:
SSD:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 4
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 4
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140098
write: 50035
other: 20014
total: 210147
transactions: 10007 (104.48 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190133 (1985.17 per sec.)
other operations: 20014 (208.96 per sec.)
Test execution summary:
total time: 95.7769s
total number of events: 10007
total time taken by event execution: 382.9689
per-request statistics:
min: 6.44ms
avg: 38.27ms
max: 283.05ms
approx. 95 percentile: 95.16ms
Threads fairness:
events (avg/stddev): 2501.7500/6.57
execution time (avg/stddev): 95.7422/0.00
Stopping MySQL database server: mysqld.
Cached:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 4
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 4
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140070
write: 50025
other: 20010
total: 210105
transactions: 10005 (21.63 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190095 (411.03 per sec.)
other operations: 20010 (43.27 per sec.)
Test execution summary:
total time: 462.4894s
total number of events: 10005
total time taken by event execution: 1849.6716
per-request statistics:
min: 29.97ms
avg: 184.87ms
max: 1634.69ms
approx. 95 percentile: 457.95ms
Threads fairness:
events (avg/stddev): 2501.2500/27.67
execution time (avg/stddev): 462.4179/0.03
Stopping MySQL database server: mysqld.
Uncached:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 4
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 4
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140028
write: 50010
other: 20004
total: 210042
transactions: 10002 (10.07 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190038 (191.30 per sec.)
other operations: 20004 (20.14 per sec.)
Test execution summary:
total time: 993.4198s
total number of events: 10002
total time taken by event execution: 3973.0738
per-request statistics:
min: 33.38ms
avg: 397.23ms
max: 2301.43ms
approx. 95 percentile: 1178.94ms
Threads fairness:
events (avg/stddev): 2500.5000/11.10
execution time (avg/stddev): 993.2684/0.08
Stopping MySQL database server: mysqld.
16 threads:
Uncached:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 16
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 16
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140042
write: 50015
other: 20006
total: 210063
transactions: 10003 (14.72 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190057 (279.59 per sec.)
other operations: 20006 (29.43 per sec.)
Test execution summary:
total time: 679.7730s
total number of events: 10003
total time taken by event execution: 10866.4343
per-request statistics:
min: 33.44ms
avg: 1086.32ms
max: 4102.42ms
approx. 95 percentile: 2156.92ms
Threads fairness:
events (avg/stddev): 625.1875/8.87
execution time (avg/stddev): 679.1521/0.23
Stopping MySQL database server: mysqld.
Cached:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 16
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld ..
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 16
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140056
write: 50020
other: 20008
total: 210084
transactions: 10004 (29.31 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190076 (556.80 per sec.)
other operations: 20008 (58.61 per sec.)
Test execution summary:
total time: 341.3714s
total number of events: 10004
total time taken by event execution: 5461.0997
per-request statistics:
min: 45.36ms
avg: 545.89ms
max: 2433.42ms
approx. 95 percentile: 1241.97ms
Threads fairness:
events (avg/stddev): 625.2500/9.87
execution time (avg/stddev): 341.3187/0.01
Stopping MySQL database server: mysqld.
32 threads:
Uncached:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 32
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 32
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140056
write: 50020
other: 20008
total: 210084
transactions: 10004 (14.23 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190076 (270.35 per sec.)
other operations: 20008 (28.46 per sec.)
Test execution summary:
total time: 703.0777s
total number of events: 10004
total time taken by event execution: 22477.2806
per-request statistics:
min: 55.64ms
avg: 2246.83ms
max: 9683.92ms
approx. 95 percentile: 4046.65ms
Threads fairness:
events (avg/stddev): 312.6250/6.84
execution time (avg/stddev): 702.4150/0.20
Stopping MySQL database server: mysqld.
Cached:root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 32
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 32
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (28.80 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (547.27 per sec.)
other operations: 20000 (57.61 per sec.)
Test execution summary:
total time: 347.1779s
total number of events: 10000
total time taken by event execution: 11084.2024
per-request statistics:
min: 31.20ms
avg: 1108.42ms
max: 3427.44ms
approx. 95 percentile: 2119.16ms
Threads fairness:
events (avg/stddev): 312.5000/4.32
execution time (avg/stddev): 346.3813/0.22
Stopping MySQL database server: mysqld.
Cached, synchronous btree updates off:
root@utumno:~# ./bin/sysbench_benchmark.sh
Threads: 32
Table Size: 10000000
Max Req: 30000
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Doing Benchmark READWRITE...
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 32
Doing OLTP test.
Running mixed OLTP 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140028
write: 50010
other: 20004
total: 210042
transactions: 10002 (66.57 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190038 (1264.87 per sec.)
other operations: 20004 (133.14 per sec.)
Test execution summary:
total time: 150.2426s
total number of events: 10002
total time taken by event execution: 4804.4859
per-request statistics:
min: 3.84ms
avg: 480.35ms
max: 2553.35ms
approx. 95 percentile: 1244.95ms
Threads fairness:
events (avg/stddev): 312.5625/7.41
execution time (avg/stddev): 150.1402/0.09
Stopping MySQL database server: mysqld.