mysql查看二进制日志操作记录

最新推荐文章于 2024-07-28 02:50:43 发布

mysqlnginxzabbix

最新推荐文章于 2024-07-28 02:50:43 发布

阅读量7.5k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/zwldx/article/details/82111625

版权

mysql 专栏收录该内容

5 篇文章 1 订阅

订阅专栏

查看主库所有二进制日志

mysql> show binary logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000001 |       154 |
+------------------+-----------+
1 row in set (0.00 sec)

查看详细信息：

mysql> show binlog events in  'mysql-bin.000001';
+------------------+-----+----------------+-----------+-------------+---------------------------------------+
| Log_name         | Pos | Event_type     | Server_id | End_log_pos | Info                                  |
+------------------+-----+----------------+-----------+-------------+---------------------------------------+
| mysql-bin.000001 |   4 | Format_desc    |         1 |         123 | Server ver: 5.7.22-log, Binlog ver: 4 |
| mysql-bin.000001 | 123 | Previous_gtids |         1 |         154 |                                       |
+------------------+-----+----------------+-----------+-------------+---------------------------------------+
2 rows in set (0.00 sec)

查看二进制日志是否开启

mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.00 sec)