MySQL设定MAX_BINLOG_SIZE

MySQL设定MAX_BINLOG_SIZE - mysql数据库栏目 - 红黑联盟  https://www.2cto.com/database/201208/149807.html

MySQL设定MAX_BINLOG_SIZE

 

1.修改/etc/my.cnf

 

添加max_binlog_size=512m

  www.2cto.com  

2.在线修改

 

SET @set_value = 1073741824;

 

SET @@global.max_binlog_size = @set_value;

 

SELECT @@global.max_binlog_size;