Tried to reproduce the same above test with 5.1.71, but unable to reproduce.
nilnandan@nilnandan-Dell-XPS:~/sandboxes/msb_5_1_71$ sysbench --test=oltp --oltp-table-size=10000000 --oltp-test-mode=complex --oltp-read-only=on --num-threads=6 --max-time=1800 --max-requests=0 --mysql-db=dbtest --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5171.sock 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: 6
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 5 times)
Done.
OLTP test statistics:
queries performed:
read: 64377852
write: 0
other: 9196836
total: 73574688
transactions: 4598418 (2554.67 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 64377852 (35765.43 per sec.)
other operations: 9196836 (5109.35 per sec.)
Test execution summary:
total time: 1800.0020s
total number of events: 4598418
total time taken by event execution: 10773.4179
per-request statistics:
min: 1.30ms
avg: 2.34ms
max: 39.16ms
approx. 95 percentile: 2.95ms
Threads fairness:
events (avg/stddev): 766403.0000/999.04
execution time (avg/stddev): 1795.5697/0.02
Tried to reproduce the same above test with 5.1.71, but unable to reproduce.
nilnandan@ nilnandan- Dell-XPS: ~/sandboxes/ msb_5_1_ 71$ sysbench --test=oltp --oltp- table-size= 10000000 --oltp- test-mode= complex --oltp-read-only=on --num-threads=6 --max-time=1800 --max-requests=0 --mysql-db=dbtest --mysql- user=msandbox --mysql- password= msandbox --mysql- socket= /tmp/mysql_ sandbox5171. sock 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: 6
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 5 times)
Done.
OLTP test statistics:
queries performed:
read: 64377852
write: 0
other: 9196836
total: 73574688
transactions: 4598418 (2554.67 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 64377852 (35765.43 per sec.)
other operations: 9196836 (5109.35 per sec.)
Test execution summary:
total time: 1800.0020s
total number of events: 4598418
total time taken by event execution: 10773.4179
per-request statistics:
min: 1.30ms
avg: 2.34ms
max: 39.16ms
approx. 95 percentile: 2.95ms
Threads fairness:
events (avg/stddev): 766403.0000/999.04
execution time (avg/stddev): 1795.5697/0.02
nilnandan@ nilnandan- Dell-XPS: ~/sandboxes/ msb_5_1_ 71$