计算机►数据库

MySQL日志

general_log

全量日志

1
2
3
4
5
6
7
8
9
10
11
show variables like 'general%';

+------------------+----------------------------------------------------+
| Variable_name    | Value                                              |
+------------------+----------------------------------------------------+
| general_log      | OFF                                                |
| general_log_file | /usr/local/var/mysql/fangzongzhoudeMacBook-Pro.log |
+------------------+----------------------------------------------------+

set global general_log=1;
set global general_log=0;

错误日志

只记录数据库报错

binlog

记录增删改的记录

slowlog

只记录超过阈值的慢查询

文章链接 https://fangzongzhou.github.io/2018/09/07/计算机/技术栈/MYSQL/MySQL日志/