Test parameters: sysbench -- testrootsysbench0.5sysbenchtestsdbinsert. lua -- mysql-table-engineinnodb -- oltp-table-size1000000-max-requests0 -- max-time
Test parameter: sysbench -- test =/root/sysbench0.5/sysbench/tests/db/insert. lua -- mysql-table-engine = innodb -- oltp-table-size = 1000000 -- max-requests = 0 -- max-time =
Test parameters:
Sysbench -- test =/root/sysbench0.5/sysbench/tests/db/insert. lua -- mysql-table-engine = innodb -- oltp-table-size = 1000000 -- max-requests = 0 -- max-time = 300 -- num-threads = 16 -- oltp-tables- count = 10 -- report-interval = 10 -- mysql-host = 10.8.8.100 -- mysql-port = 3312 -- mysql-user = admin -- mysql-password = 123456 -- mysql-db = test run
10 1 million-row tables with 16 concurrent threads and pure insert operations.
MySQL parameters:
Sync_binlog = bytes = 0innodb_flush_method = bytes = 1innodb_buffer_pool_size = 10Ginnodb_io_capacity = 500innodb_log_file_size = bytes = 3innodb_log_buffer_size = 16 M
Normal replication latency:
Master_Log_File: mysql-bin.000004 runtime: 567748597 Relay_Log_File: host-100-relay-bin.000005 Relay_Log_Pos: 66853042 runtime: mysql-bin.000003 runtime: Yes runtime: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 469504741
MB remaining
MariaDB [(none)]> select 1024-469504741/1024/1024 + 567748597/1024/1024; + rows + | 1024-469504741/1024/1024 + 567748597/1024/1024 | + ---------------------------------------------- + | 1117.69264221 | + rows + 1 row in set (0.00 sec)
Parallel replication (8 concurrent threads without GTID enabled) latency:
Master_Log_File: mysql-bin.000022 runtime: 333773843 Relay_Log_File: host-100-relay-bin.000073 Relay_Log_Pos: 134217580 runtime: mysql-bin.000021 runtime: Yes runtime: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 722396020
653MB left.
MariaDB [(none)]> select 1024-722396020/1024/1024 + 333773843/1024/1024; + rows + | 1024-722396020/1024/1024 + 333773843/1024/1024 | + ---------------------------------------------- + | 653.38101101 | + rows + 1 row in set (0.00 sec)