MySQL Server上的二进制日志查看记录
MySQL Server上的二进制日志查看记录
清空MySQL上的所有二进制日志:
mysql> reset master; Query OK, 0 rows affected (0.35 sec)
查看MySQL上的二进制日志:
mysql> show binary logs; +------------------+-----------+ | Log_name | File_size | +------------------+-----------+ | mysql-bin.000001 | 120 | +------------------+-----------+ 1 row in set (0.00 sec)
查看二进制日志中的事件:
mysql> show binlog events; +------------------+-----+-------------+-----------+-------------+---------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +------------------+-----+-------------+-----------+-------------+---------------------------------------+ | mysql-bin.000001 | 4 | Format_desc | 2 | 120 | Server ver: 5.6.37-log, Binlog ver: 4 | +------------------+-----+-------------+-----------+-------------+---------------------------------------+ 1 row in set (0.00 sec)
重新开始一个新的日志文件:
mysql> flush logs; Query OK, 0 rows affected (0.01 sec)
评论