测试参数:sysbench--test=/root/sysbench0.5/sysbench/tests/db/insert.lua--mysql-table-engine=innodb--oltp-table-size=1000000--max-requests=0--max-time=
测试参数:
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 run10张100万行表,并发16个线程,纯插入操作。
mysql参数:
sync_binlog = 0innodb_flush_log_at_trx_commit = 0innodb_flush_method = o_directinnodb_flush_neighbors = 1innodb_buffer_pool_size = 10ginnodb_io_capacity = 500innodb_log_file_size = 512minnodb_log_files_in_group = 3innodb_log_buffer_size = 16m
普通复制延迟:
master_log_file: mysql-bin.000004 read_master_log_pos: 567748597 relay_log_file: host-100-relay-bin.000005 relay_log_pos: 66853042 relay_master_log_file: mysql-bin.000003 slave_io_running: yes slave_sql_running: yes replicate_do_db: replicate_ignore_db: replicate_do_table: replicate_ignore_table: replicate_wild_do_table: replicate_wild_ignore_table: last_errno: 0 last_error: skip_counter: 0 exec_master_log_pos: 469504741还剩1117mb没追完
mariadb [(none)]> select 1024-469504741/1024/1024+567748597/1024/1024;+----------------------------------------------+| 1024-469504741/1024/1024+567748597/1024/1024 |+----------------------------------------------+| 1117.69264221 |+----------------------------------------------+1 row in set (0.00 sec)
并行复制(8个并发线程,未开启gtid模式)延迟:
master_log_file: mysql-bin.000022 read_master_log_pos: 333773843 relay_log_file: host-100-relay-bin.000073 relay_log_pos: 134217580 relay_master_log_file: mysql-bin.000021 slave_io_running: yes slave_sql_running: yes replicate_do_db: replicate_ignore_db: replicate_do_table: replicate_ignore_table: replicate_wild_do_table: replicate_wild_ignore_table: last_errno: 0 last_error: skip_counter: 0 exec_master_log_pos: 722396020还剩653mb没追完
mariadb [(none)]> select 1024-722396020/1024/1024+333773843/1024/1024;+----------------------------------------------+| 1024-722396020/1024/1024+333773843/1024/1024 |+----------------------------------------------+| 653.38101101 |+----------------------------------------------+1 row in set (0.00 sec)