首页  编辑  

MySQL Slave 同步性能很慢

Tags: /MySQL/   Date Created:
如果是MySQL 5.6以上版本,请使用以下参数提高性能:
slave-parallel-workers,具体请参考: http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#option_mysqld_slave-parallel-workers
--slave-parallel-workers
Introduced        5.6.3
Command-Line Format        --slave-parallel-workers=#
Permitted Values        Type        integer
Default        0
Min Value        0
Max Value        1024
Sets the number of slave worker threads for executing replication events (transactions) in parallel. Setting this variable to 0 (the default) disables parallel execution. The maximum is 1024.
Note
Multi-threaded slaves are not currently supported by MySQL Cluster, which silently ignores the setting for this option. See Section 18.6.3, "Known Issues in MySQL Cluster Replication", for more information.