发现 MySQL 文件夹下生成了大量 mysql-bin.xxxx 文件,占用了几十个 G ,赶紧注释了 my.cnf 以下两行,然后重启 MySQL
#log-bin=mysql-bin #binlog_format=mixed 然后按照网上的删除 mysql-bin.xxxx 文件教程:
PURGE MASTER LOGS TO 'MySQL-bin.010'; PURGE MASTER LOGS BEFORE '2023-03-21 13:00:00'; PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 1 DAY); RESET MASTER; PURGE BINARY LOGS TO 'MySQL-bin.010'; PURGE BINARY LOGS BEFORE '2023-03-21 13:00:00'; 以上这些语句全都没用,mysql-bin 毫无变化,所以这些 mysql-bin.xxxx 到底该怎么删除?
