说明:当开启mysql数据库主从时,会产生大量如mysql-bin.*log的文件,这会大量耗费您的硬盘空间。mysql-bin.1mysql-bin.2mysql-bin.3mysql-bin.4mysql-bin.5…有三种解决方法:1.关闭mysql主从,关闭binlog;2.开启mysql主从,设置expire_logs_days;3.手动清除binlog文件,PURGEMASTERLOGSTO‘MySQL-bin.′;实现:1.关闭mysql主从,关闭binlog#vim/etc/my.cnf//注释掉log-bin,binlog_format#ReplicationMasterServer(default)#binaryloggingisrequiredforreplication#log-bin=mysql-bin#binaryloggingformat-mixedre
转载请注明:http://www.aierlanlan.com/rzdk/7395.html