mysql的binlog空间维护

最新推荐文章于 2021-03-17 13:33:25 发布

weixin_30764771

最新推荐文章于 2021-03-17 13:33:25 发布

阅读量91

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/aguncn/p/11161966.html

版权

.Binlog空间维护

一，显示当前的logs文件记录

show master logs;

二，清空n天前的日志，减少磁盘空间

PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY);

三，更改配置文件，指定binlog过期日期及binlog存储的物理位置。

My.cnf

[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