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;