您好,欢迎访问一九零五行业门户网

MariaDB 10之并行复制--延迟测试结果

测试参数: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)
其它类似信息

推荐信息