// With semi-sync

- 30 threads
[umshastr@hod03]~/bugs/sysbench: bin/sysbench --max-requests=0 --max-time=300 --test=sysbench/tests/db/oltp.lua --mysql-user=root  --mysql-socket=/export/umesh/mysql-5.6.20/run/mysqld.sock --mysql-db=test --db-driver=mysql --db-ps-mode=disable --oltp-table-size=10000000 --oltp-point-selects=1 --oltp-index-updates=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --num-threads=30 run
sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 30
Random number generator seed is 0 and will be ignored


Threads started!

OLTP test statistics:
    queries performed:
        read:                            342059
        write:                           1026177
        other:                           684118
        total:                           2052354
    transactions:                        342059 (1140.12 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1368236 (4560.49 per sec.)
    other operations:                    684118 (2280.24 per sec.)

General statistics:
    total time:                          300.0196s
    total number of events:              342059
    total time taken by event execution: 8999.6255s
    response time:
         min:                                  4.10ms
         avg:                                 26.31ms
         max:                                392.84ms
         approx.  95 percentile:              32.06ms

Threads fairness:
    events (avg/stddev):           11401.9667/4.09
    execution time (avg/stddev):   299.9875/0.01

- 3000 threads
[umshastr@hod03]~/bugs/sysbench: bin/sysbench --max-requests=0 --max-time=300 --test=sysbench/tests/db/oltp.lua --mysql-user=root  --mysql-socket=/export/umesh/mysql-5.6.20/run/mysqld.sock --mysql-db=test --db-driver=mysql --db-ps-mode=disable --oltp-table-size=10000000 --oltp-point-selects=1 --oltp-index-updates=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --num-threads=3000 run
sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 3000
Random number generator seed is 0 and will be ignored


Threads started!

OLTP test statistics:
    queries performed:
        read:                            901338
        write:                           2704014
        other:                           1802676
        total:                           5408028
    transactions:                        901338 (2995.84 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 3605352 (11983.35 per sec.)
    other operations:                    1802676 (5991.68 per sec.)

General statistics:
    total time:                          300.8634s
    total number of events:              901338
    total time taken by event execution: 900937.6180s
    response time:
         min:                                 39.30ms
         avg:                                999.56ms
         max:                               1890.85ms
         approx.  95 percentile:            1212.22ms

Threads fairness:
    events (avg/stddev):           300.4460/0.89
    execution time (avg/stddev):   300.3125/0.28

[umshastr@hod03]~/bugs/sysbench:

## Without semi-sync
- 30 threads
[umshastr@hod03]~/bugs/sysbench: bin/sysbench --max-requests=0 --max-time=300 --test=sysbench/tests/db/oltp.lua --mysql-user=root  --mysql-socket=/export/umesh/mysql-5.6.20/run/mysqld.sock --mysql-db=test --db-driver=mysql --db-ps-mode=disable --oltp-table-size=10000000 --oltp-point-selects=1 --oltp-index-updates=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --num-threads=30 run
sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 30
Random number generator seed is 0 and will be ignored


Threads started!

OLTP test statistics:
    queries performed:
        read:                            1941813
        write:                           5825439
        other:                           3883626
        total:                           11650878
    transactions:                        1941813 (6472.67 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 7767252 (25890.69 per sec.)
    other operations:                    3883626 (12945.34 per sec.)

General statistics:
    total time:                          300.0018s
    total number of events:              1941813
    total time taken by event execution: 8996.2419s
    response time:
         min:                                  0.68ms
         avg:                                  4.63ms
         max:                               1665.65ms
         approx.  95 percentile:               4.14ms

Threads fairness:
    events (avg/stddev):           64727.1000/9458.33
    execution time (avg/stddev):   299.8747/0.02

- 3000 threads
[umshastr@hod03]~/bugs/sysbench: bin/sysbench --max-requests=0 --max-time=300 --test=sysbench/tests/db/oltp.lua --mysql-user=root  --mysql-socket=/export/umesh/mysql-5.6.20/run/mysqld.sock --mysql-db=test --db-driver=mysql --db-ps-mode=disable --oltp-table-size=10000000 --oltp-point-selects=1 --oltp-index-updates=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --num-threads=3000 run
sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 3000
Random number generator seed is 0 and will be ignored


Threads started!

OLTP test statistics:
    queries performed:
        read:                            969876
        write:                           2908380
        other:                           1939256
        total:                           5817512
    transactions:                        969380 (3206.28 per sec.)
    deadlocks:                           496    (1.64 per sec.)
    read/write requests:                 3878256 (12827.54 per sec.)
    other operations:                    1939256 (6414.19 per sec.)

General statistics:
    total time:                          302.3383s
    total number of events:              969380
    total time taken by event execution: 902300.4230s
    response time:
         min:                                  0.93ms
         avg:                                930.80ms
         max:                              24209.79ms
         approx.  95 percentile:            3778.56ms

Threads fairness:
    events (avg/stddev):           323.1267/29.45
    execution time (avg/stddev):   300.7668/0.59