MySQL二进制日志操作
时间:2022-03-14 18:40
二进制日志
概念
查看结果
[root@slave1 ~]# ls /data/3306/mysql-bin/
mysql-bin.000001 mysql-bin.index
2、使用PURGE命令指定删除某个二进制文件之前的二进制文件
[root@slave2 ~]# ls /data/3306/mysql-bin/
mysql-bin.000001 mysql-bin.000003 mysql-bin.000005 mysql-bin.000007 mysql-bin.000009
mysql-bin.000002 mysql-bin.000004 mysql-bin.000006 mysql-bin.000008 mysql-bin.index
mysql> purge master logs to ‘mysql-bin.000005‘; Query OK, 0 rows affected (0.00 sec)
[root@slave2 ~]# ls /data/3306/mysql-bin/
mysql-bin.000005 mysql-bin.000006 mysql-bin.000007 mysql-bin.000008 mysql-bin.000009 mysql-bin.index
3、使用PURGE命令删除指定日期之前的二进制文件
[root@slave2 ~]# date "+%F %T"
2016-03-14 22:12:41
删除5天前的全部二进制日志
mysql> purge master logs before ‘2016-03-10 00:00:00‘; Query OK, 0 rows affected (0.02 sec)
查看结果
[root@slave2 ~]# ls /data/3306/mysql-bin/
mysql-bin.000007 mysql-bin.000008 mysql-bin.000009 mysql-bin.index
删除2016-03-14之前的全部二进制日志
mysql> purge master logs before ‘2016-03-14 00:00:00‘; Query OK, 0 rows affected (0.00 sec)
查看结果
[root@slave2 ~]# ls /data/3306/mysql-bin/
mysql-bin.000008 mysql-bin.000009 mysql-bin.index