Master:
rpl_semi_sync_master_enabled=0
Slave:
rpl_semi_sync_slave_enabled=0
Threads: 3000

rcannao@sjd-rg2-26a:~$ msql root -e "set global rpl_semi_sync_master_enabled=0;"
rcannao@sjd-rg2-26a:~$ ssh sjd-rl10-17a -- 'msql root -e "set global rpl_semi_sync_slave_enabled=0; stop slave; start slave;"'
rcannao@sjd-rg2-26a:~$ sysbench --max-requests=0 --max-time=300 --test=oltp --mysql-user=rcannao --mysql-password=rcannao --mysql-db=rcannao --db-driver=mysql --db-ps-mode=disable --oltp-table-size=1000000 --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.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 3000

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
Threads started!
Time limit exceeded, exiting...
(last message repeated 2999 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            997691
        write:                           3987390
        other:                           1994034
        total:                           6979115
    transactions:                        996343 (3310.84 per sec.)
    deadlocks:                           1348   (4.48 per sec.)
    read/write requests:                 4985081 (16565.39 per sec.)
    other operations:                    1994034 (6626.16 per sec.)

Test execution summary:
    total time:                          300.9335s
    total number of events:              996343
    total time taken by event execution: 900695.2745
    per-request statistics:
         min:                                  2.28ms
         avg:                                904.00ms
         max:                              24907.51ms
         approx.  95 percentile:            3029.60ms

Threads fairness:
    events (avg/stddev):           332.1143/25.52
    execution time (avg/stddev):   300.2318/0.23

rcannao@sjd-rg2-26a:~$






=====


Master:
rpl_semi_sync_master_enabled=1
Slave:
rpl_semi_sync_slave_enabled=1
Threads: 3000

rcannao@sjd-rg2-26a:~$ msql root -e "set global rpl_semi_sync_master_enabled=1;"
rcannao@sjd-rg2-26a:~$ ssh sjd-rl10-17a -- 'msql root -e "set global rpl_semi_sync_slave_enabled=1; stop slave; start slave;"'
rcannao@sjd-rg2-26a:~$ sysbench --max-requests=0 --max-time=300 --test=oltp --mysql-user=rcannao --mysql-password=rcannao --mysql-db=rcannao --db-driver=mysql --db-ps-mode=disable --oltp-table-size=1000000 --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.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 3000

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
Threads started!
Time limit exceeded, exiting...
(last message repeated 2999 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            216649
        write:                           866596
        other:                           433298
        total:                           1516543
    transactions:                        216649 (717.62 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1083245 (3588.09 per sec.)
    other operations:                    433298 (1435.24 per sec.)

Test execution summary:
    total time:                          301.9003s
    total number of events:              216649
    total time taken by event execution: 903041.0551
    per-request statistics:
         min:                                  1.75ms
         avg:                               4168.22ms
         max:                              10200.05ms
         approx.  95 percentile:            9370.22ms

Threads fairness:
    events (avg/stddev):           72.2163/2.82
    execution time (avg/stddev):   301.0137/0.56

rcannao@sjd-rg2-26a:~$


====

Master:
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=10000000
Slave:
rpl_semi_sync_slave_enabled=1
Threads: 3000

rcannao@sjd-rg2-26a:~$ msql root -e "set global rpl_semi_sync_master_enabled=1; set global rpl_semi_sync_master_timeout=10000000;"
rcannao@sjd-rg2-26a:~$ ssh sjd-rl10-17a -- 'msql root -e "set global rpl_semi_sync_slave_enabled=1; stop slave; start slave;"'
rcannao@sjd-rg2-26a:~$ sysbench --max-requests=0 --max-time=300 --test=oltp --mysql-user=rcannao --mysql-password=rcannao --mysql-db=rcannao --db-driver=mysql --db-ps-mode=disable --oltp-table-size=1000000 --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.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 3000

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
Threads started!
Time limit exceeded, exiting...
(last message repeated 2999 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            73633
        write:                           294532
        other:                           147266
        total:                           515431
    transactions:                        73633  (241.02 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 368165 (1205.12 per sec.)
    other operations:                    147266 (482.05 per sec.)

Test execution summary:
    total time:                          305.5003s
    total number of events:              73633
    total time taken by event execution: 909743.6532
    per-request statistics:
         min:                                 42.36ms
         avg:                              12355.11ms
         max:                              22039.62ms
         approx.  95 percentile:           19214.22ms

Threads fairness:
    events (avg/stddev):           24.5443/0.70
    execution time (avg/stddev):   303.2479/1.56

rcannao@sjd-rg2-26a:~$







========

Master:
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=10000000
Slave:
rpl_semi_sync_slave_enabled=1
Threads: 30



rcannao@sjd-rg2-26a:~$ sysbench --max-requests=0 --max-time=300 --test=oltp --mysql-user=rcannao --mysql-password=rcannao --mysql-db=rcannao --db-driver=mysql --db-ps-mode=disable --oltp-table-size=1000000 --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.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 30

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
Threads started!
Time limit exceeded, exiting...
(last message repeated 29 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            668769
        write:                           2675076
        other:                           1337538
        total:                           4681383
    transactions:                        668769 (2229.16 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 3343845 (11145.80 per sec.)
    other operations:                    1337538 (4458.32 per sec.)

Test execution summary:
    total time:                          300.0095s
    total number of events:              668769
    total time taken by event execution: 8996.8110
    per-request statistics:
         min:                                  3.38ms
         avg:                                 13.45ms
         max:                                317.53ms
         approx.  95 percentile:              15.66ms

Threads fairness:
    events (avg/stddev):           22292.3000/8.37
    execution time (avg/stddev):   299.8937/0.00

rcannao@sjd-rg2-26a:~$



========

Master:
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=10000000
Slave:
rpl_semi_sync_slave_enabled=1
Threads: 100



rcannao@sjd-rg2-26a:~$ sysbench --max-requests=0 --max-time=300 --test=oltp --mysql-user=rcannao --mysql-password=rcannao --mysql-db=rcannao --db-driver=mysql --db-ps-mode=disable --oltp-table-size=1000000 --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=100 run
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 100

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
Threads started!
Time limit exceeded, exiting...
(last message repeated 99 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            621012
        write:                           2484048
        other:                           1242024
        total:                           4347084
    transactions:                        621012 (2069.83 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 3105060 (10349.16 per sec.)
    other operations:                    1242024 (4139.66 per sec.)

Test execution summary:
    total time:                          300.0301s
    total number of events:              621012
    total time taken by event execution: 29997.7912
    per-request statistics:
         min:                                  7.93ms
         avg:                                 48.30ms
         max:                                 74.49ms
         approx.  95 percentile:              56.74ms

Threads fairness:
    events (avg/stddev):           6210.1200/20.62
    execution time (avg/stddev):   299.9779/0.01

rcannao@sjd-rg2-26a:~$