44.mysqlbinlog

1.只查看第一个binlog文件的内容
show binlog events;


2.查看指定binlog文件的内容
show binlog events in 'mysql-bin.000002';


3.查看当前正在写入的binlog文件
show master status;


4.获取binlog文件列表
show binary logs;


5.查看master上的binlog
show master logs;


6.手动删除binlog
reset master;  //删除master的binlog, 
清除后会发现重启不了。报错mysqld: File './mysql-bin.000004' not found
将原先的mysql-bin.index 移除或者重命名


reset slave;   //删除slave的中继日志


purge master logs before '2012-03-30 17:20:00';  //删除指定日期以前的日志索引中binlog日志文件


purge master logs to 'mysql-bin.000002';   //删除指定日志文件的日志索引中binlog日志文件


7.flush logs; // 启用新的二进制文件




// 用 mysqlbinlog 工具查看
1.mysqlbinlog mysql-bin.000002


2.基于开始/结束时间
mysqlbinlog --start-datetime='2018-04-11 10:58:05' --stop-datetime='2018-04-11 10:58:44' mysql-bin.000003


3.基于 pos 值

mysqlbinlog  --start-position=4 --stop-position=123  mysql-bin.000002

4.当 binlog_format = row 时，用 --base64-output=decode-rows 解码
mysqlbinlog --base64-output=decode-rows -v  mysql-bin.000003

______________________________________________________________________________

https://blog.csdn.net/ouyang111222/article/details/50300851

https://www.cnblogs.com/kevingrace/p/5907254.html

http://www.ttlsa.com/mysql/super-useful-mysqlbinlog-command/