mysql+binlog+查看+加密_MySQL Binlog信息查看

查看Binlog相关信息

##=====================================##

## 在MySQL内部查看binlog文件列表 ##

SHOWBINARYLOGS;

##=====================================##

##查看某个binglog文件中特定pos的操作

SHOW BINLOG EVENTSIN 'mysql-bin.000011' FROM 4742885 LIMIT 15;

##=====================================##

## 使用mysqlbinlog查看binlog ##

## 按时间过滤--start-datetime --stop-datetime，过滤时间格式为'2004-12-25 11:25:56'

## 按位置点过滤--start-position --stop-position，如果不能提供准确的pos值，则会报错

## 按照GTID过滤--include-gtids include-gtids

/export/servers/mysql/bin/mysqlbinlog -vv /export/data/mysql/data/mysql-bin.008735

/export/servers/mysql/bin/mysqlbinlog -vv /export/data/mysql/data/mysql-bin.008735 --start-datetime='2017-01-01 00:00:00' --stop-datetime='2017-01-02 00:00:00'

/export/servers/mysql/bin/mysqlbinlog -vv /export/data/mysql/data/mysql-bin.008735 --start-position=194 --s