Verified with PS 5.6. ---------- With --num-threads=30 and normal replication nilnandan@desktop:~$ sysbench --max-requests=0 --max-time=900 --test=/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-user=root --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox21087.sock --mysql-db=dbtest --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: .. transactions: 1980700 (2200.77 per sec.) read/write requests: 7922800 (8803.08 per sec.) other operations: 3961400 (4401.54 per sec.) ... nilnandan@desktop:~$ ---------- With --num-threads=30 and semi-sync replication nilnandan@desktop:~$ nilnandan@desktop:~$ sysbench --max-requests=0 --max-time=900 --test=/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-user=root --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox21087.sock --mysql-db=dbtest --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: ... transactions: 1463881 (1626.51 per sec.) read/write requests: 5855524 (6506.03 per sec.) other operations: 2927762 (3253.02 per sec.) ... nilnandan@desktop:~$ ---------- With --num-threads=300 and normal replication nilnandan@desktop:~$ sysbench --max-requests=0 --max-time=900 --test=/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-user=root --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox21087.sock --mysql-db=dbtest --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=300 run sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 300 Random number generator seed is 0 and will be ignored Threads started! OLTP test statistics: ... transactions: 2425613 (2694.89 per sec.) read/write requests: 9702452 (10779.54 per sec.) other operations: 4851226 (5389.77 per sec.) .. ---------- With --num-threads=300 and semi-sync replication nilnandan@desktop:~$ sysbench --max-requests=0 --max-time=900 --test=/usr/share/doc/sysbench/tests/db/oltp.lua --mysql-user=root --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox21087.sock --mysql-db=dbtest --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=300 run sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 300 Random number generator seed is 0 and will be ignored Threads started! OLTP test statistics: ... transactions: 2078703 (2309.58 per sec.) read/write requests: 8314812 (9238.32 per sec.) other operations: 4157406 (4619.16 per sec.) Also, pt-pmp output while running on semi-sync replication, 1poll,vio_io_wait(viosocket.c:867),vio_socket_io_wait(viosocket.c:100),vio_read(viosocket.c:155),net_read_raw_loop(net_serv.cc:669),net_read_packet_header(net_serv.cc:751),net_read_packet(net_serv.cc:751),my_net_read(net_serv.cc:894),ReplSemiSyncMaster::readSlaveReply(semisync_master.cc:1154),repl_semi_after_send_event(semisync_master_plugin.cc:150),Binlog_transmit_delegate::after_send_event(rpl_handler.cc:374),mysql_binlog_send(rpl_master.cc:1486),com_binlog_dump(rpl_master.cc:767),dispatch_command(sql_parse.cc:1646),do_command(sql_parse.cc:1051),do_handle_one_connection(sql_connect.cc:1532),handle_one_connection(sql_connect.cc:1443),pfs_spawn_thread(pfs.cc:1860),start_thread,clone ... 1 __lll_lock_wait,_L_lock_1087(libpthread.so.0),__GI___pthread_mutex_lock,inline_mysql_mutex_lock(mysql_thread.h:688),MYSQL_BIN_LOG::change_stage(mysql_thread.h:688),MYSQL_BIN_LOG::ordered_commit(binlog.cc:7342),MYSQL_BIN_LOG::commit(binlog.cc:6750),ha_commit_trans(handler.cc:1511),trans_commit(transaction.cc:230),mysql_execute_command(sql_parse.cc:4774),mysql_parse(sql_parse.cc:6922),dispatch_command(sql_parse.cc:1434),do_command(sql_parse.cc:1051),do_handle_one_connection(sql_connect.cc:1532),handle_one_connection(sql_connect.cc:1443),pfs_spawn_thread(pfs.cc:1860),start_thread,clone