cherishman2005 / nginx-modules

nginx, go
MIT License
2 stars 0 forks source link

[mysql]Binary log is not open #64

Open cherishman2005 opened 7 months ago

cherishman2005 commented 7 months ago
cherishman2005 commented 7 months ago

binlog日志文件只对 增删改有记录,查询操作是没有记录的

二进制日志文件,MySql8.0默认已经开启,低版本的MySql需要通过配置文件开启,并配置MySql日志格式,windows系统:myini,Linux系统:my.cnf

1、查看是否开启binlog

show variables like 'log_%';
mysql> show variables like 'log_%';
+----------------------------------------+--------------------------+
| Variable_name                          | Value                    |
+----------------------------------------+--------------------------+
| log_bin                                | OFF                      |
| log_bin_basename                       |                          |
| log_bin_index                          |                          |
| log_bin_trust_function_creators        | OFF                      |
| log_bin_use_v1_row_events              | OFF                      |
| log_builtin_as_identified_by_password  | OFF                      |
| log_error                              | /var/log/mysql/error.log |
| log_error_verbosity                    | 3                        |
| log_output                             | FILE                     |
| log_queries_not_using_indexes          | OFF                      |
| log_slave_updates                      | OFF                      |
| log_slow_admin_statements              | OFF                      |
| log_slow_slave_statements              | OFF                      |
| log_statements_unsafe_for_binlog       | ON                       |
| log_syslog                             | OFF                      |
| log_syslog_facility                    | daemon                   |
| log_syslog_include_pid                 | ON                       |
| log_syslog_tag                         |                          |
| log_throttle_queries_not_using_indexes | 0                        |
| log_timestamps                         | UTC                      |
| log_warnings                           | 2                        |
+----------------------------------------+--------------------------+