Mysql开启log-bin日志

本篇文章向大家介绍《Mysql开启log-bin日志》，主要包括MySQL，具有一定的参考价值，需要的朋友可以参考一下。

Mysql开启log-bin日志

一 、logbin日志 记录新增、更新、删除的sql 参考1 参考2

二、general_log 记录增删改查所有日志 general log

一 、logbin日志

show binary logs;
show master status;

show binlog events in 'mysql-bin.000090' from 242985028 limit 0,1000

• 1、检查是否开启

  检查是否开启
  show global variables like '%log_bin%';
  log_bin 为 on 则已开启，为 off则未开启。
  
  查询所有日志文件
  show binary logs;
  
  查询最近日志文件
  show master status;

• 2、开启log-bin日志记录

  SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
  
  mysql> show binlog events in 'mysql-bin.000001' from 4 limit 0,5;
  +------------------+-----+----------------+-----------+-------------+---------------------------------------+
  | Log_name         | Pos | Event_type     | Server_id | End_log_pos | Info                                  |
  +------------------+-----+----------------+-----------+-------------+---------------------------------------+
  | mysql-bin.000001 |   4 | Format_desc    |         1 |         123 | Server ver: 5.7.20-log, Binlog ver: 4 |
  | mysql-bin.000001 | 123 | Previous_gtids |         1 |         154 |                                       |
  | mysql-bin.000001 | 154 | Anonymous_Gtid |         1 |         219 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS'  |
  | mysql-bin.000001 | 219 | Query          |         1 |         292 | BEGIN                                 |
  | mysql-bin.000001 | 292 | Table_map      |         1 |         375 | table_id: 125 (test.ins_car_team)    |

• rows in set (0.00 sec)

4、导出文件

是否开启 general_log日志
show variables where variable_name like "%general_log%" or variable_name="log_output";

开启
set global general_log = on;
set global log_output = "table";


查看sql
select * from mysql.general_log where argument like '%select%'   ORDER BY event_time DESC limit 100;

本篇关于《Mysql开启log-bin日志》的介绍就到此结束啦，但是学无止境，想要了解学习更多关于数据库的相关知识，请关注golang学习网公众号！