Comment 16 for bug 1089333

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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$