mysqlbinlog相关

1.输出binlog到文件
mysqlbinlog --base64-output=decode-rows -v /home/mysql/binlog/binlog.000011>/tmp/aa.txt

2.查看某个pos后的多少行
show binlog events IN 'binlog.000011' FROM 686264000 LIMIT 100;

 

3.清理binlog

 

mysql> show variables like '%expire_logs_days%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| expire_logs_days | 3 |
+------------------+-------+
1 row in set (0.00 sec)

 

-- 删除指定日志文件(该文件不会删除)之前的所有日志文件
PURGE BINARY LOGS TO 'binlog.001720';

 

-- 删除指定日期之前的所有日志文件
purge binary logs BEFORE '2025-02-14 00:00:00';