vim /etc/mysql/mysql.conf.d/mysqld.cnf
log-bin = /usr/local/var/mysql/logs/mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1
binlog_format=MIXED(加入此参数才能记录到insert语句)
show variables like 'log_bin';
MySQL binlog配置
最新推荐文章于 2020-11-25 14:26:10 发布