mysql-binlog常用操作

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