binlog相关

SHOW VARIABLES LIKE 'log_%'; 查看binlog是否开启 log_bin on
SHOW VARIABLES LIKE '%binlog_format%'; 查看binlog模式 row
SHOW VARIABLES LIKE '%server_id%'; 查看server_id
SHOW VARIABLES LIKE "%sum%";
SHOW MASTER STATUS;//当前binlog当前位置
show binary logs; //查看binlog目前还存在(可读取到)的文件列表
show binlog events in ‘mysql-bin.000009’limit 10 //指定其中一个binlog查看详情，可以分页看事件
show binlog events in 'mysql-bin.000358' from 25859080 limit 10 //指定位点查询

mysqladmin -uroot -p123456 flush-logs //强制生产新的binlog文件