mysql bin-log 日志清理
发现mysql数据库目录中bin-log中日志文件非常大[root@localhost var]# du -sh mysql-bin* | sort1020K mysql-bin.0000021.1G mysql-bin.0000211.1M mysql-bin.000018136K mysql-bin.000019172K mysql-bin.000014191M mysql-bin.000013224M mysql-bin.00001728K mysql-bin.0000013.5M mysql-bin.0000124.0K mysql-bin.0000034.0K mysql-bin.0000044.0K mysql-bin.0000054.0K mysql-bin.0000064.0K mysql-bin.0000074.0K mysql-bin.0000154.0K mysql-bin.0000164.0K mysql-bin.index5.5M mysql-bin.00001163M mysql-bin.00000864K mysql-bin.00000965M mysql-bin.00002272K mysql-bin.000010863M mysql-bin.000020[root@localhost var]#登陆到mysql查看bin-logmysql> show binary logs;+------------------+------------+| Log_name | File_size |+------------------+------------+| mysql-bin.000001 | 27338 || mysql-bin.000002 | 1038693 || mysql-bin.000003 | 1272 || mysql-bin.000004 | 126 || mysql-bin.000005 | 126 || mysql-bin.000006 | 126 || mysql-bin.000007 | 126 || mysql-bin.000008 | 64950073 || mysql-bin.000009 | 57911 || mysql-bin.000010 | 69548 || mysql-bin.000011 | 5735460 || mysql-bin.000012 | 3564763 || mysql-bin.000013 | 199226556 || mysql-bin.000014 | 170872 || mysql-bin.000015 | 838 || mysql-bin.000016 | 126 || mysql-bin.000017 | 233747353 || mysql-bin.000018 | 1128493 || mysql-bin.000019 | 133652 || mysql-bin.000020 | 903932814 || mysql-bin.000021 | 1073745163 || mysql-bin.000022 | 67963674 |+------------------+------------+22 rows in set (0.00 sec)mysql>
删除2014-06-01 00:01:01 之前的日志：
mysql> PURGE BINARY LOGS BEFORE '2014-06-01 00:01:01'; Query OK, 0 rows affected (0.21 sec)mysql>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++保留最后一次bin-logs
mysql> PURGE BINARY LOGS TO 'mysql-bin.000022';Query OK, 0 rows affected (0.60 sec)mysql>mysql>mysql>mysql>mysql>mysql> show binary logs; +------------------+-----------+| Log_name | File_size |+------------------+-----------+| mysql-bin.000022 | 68830784 |+------------------+-----------+1 row in set (0.00 sec)mysql>