mysql的binlog空间维护
时间：2021-07-01 10:21:17
帮助过：4人阅读
client]
port=3306
socket=/mysql
/mysql.sock
default-character-set=utf8
[mysqld]
port=3306
user=mysql
default-storage
-engine
=INNODB
basedir=/mysql
/mysql
datadir=/mysql
/data
pid-file=/mysql
/mysql.pid
socket=/mysql
/mysql.sock
log_error=/mysql
/error.
log
max_allowed_packet=500M
max_connections=10000
server-id
=666
expire_logs_days = 30
log-bin=/sql_bak/log_bin/mysql-bin
binlog-format
=mixed
character-set-server
=utf8
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
四，重启Mysql，使设置生效。
mysql的binlog空间维护
标签：物理 cti cli erro port mod creat rac div
