显示 binlog 文件列表
show binary logs;
清理 binlog 文件
purge binary logs to 'mysql-bin.000001';
查看 binlog 内容
show binlog events in 'mysql-bin.000001' limit 1000, 10;
或者SHELL命令行
sudo mysqlbinlog mysql-bin.000001
显示 binlog 文件列表
show binary logs;
清理 binlog 文件
purge binary logs to 'mysql-bin.000001';
查看 binlog 内容
show binlog events in 'mysql-bin.000001' limit 1000, 10;
或者SHELL命令行
sudo mysqlbinlog mysql-bin.000001