如果是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.