mysql运行久了会放很多日志文件在/var/lib/mysql下,每天几百M,很快会填满硬盘,可以用下面方法清空日志:
shell> mysql -u username -p
mysql> PURGE BINARY LOGS BEFORE '2009-05-01 00:00:00';
Reference: http://systems.takizo.com/2009/08/23/how-to-remove-mysql-binary-log/
mysql运行久了会放很多日志文件在/var/lib/mysql下,每天几百M,很快会填满硬盘,可以用下面方法清空日志:
shell> mysql -u username -p
mysql> PURGE BINARY LOGS BEFORE '2009-05-01 00:00:00';
Reference: http://systems.takizo.com/2009/08/23/how-to-remove-mysql-binary-log/
评论