没看懂该选项的说明,烦请嘉宾解释下=1与=2的区别,如果数据库一直运行下去的话,会不会额外增加数据库负担?毕竟要记录一些事件的日志,不知道这样理解对不对?
If the option value is 2, the CHANGE MASTER TO statement is written as an SQL comment, and thus is informative only; it has no effect when the dump file is reloaded. If the option value is 1, the statement is not written as a comment and takes effect when the dump file is reloaded. If no option value is specified, the default value is 1.
上面是官方解释,其实就是在进行dump的时候所带的set master是否会在后期导入时起作用