mysql-binlog
event-type:https://dev.mysql.com/doc/internals/en/binlog-event-type.html
常用命令
- 查看binlog记录数
show binary logs
- 查看binlog-event
show binlog events in 'mysql-binlog' FROM postion LIMIT N
- 清理binlog数据
purge binary logs to 'mysql-binlog';
event-type:https://dev.mysql.com/doc/internals/en/binlog-event-type.html
show binary logs
show binlog events in 'mysql-binlog' FROM postion LIMIT N
purge binary logs to 'mysql-binlog';