mysql打开 general_log记录 sql执行情况记录

发布时间：2023-06-05 13:21:38 所属栏目：MySql教程来源：

导读：方法一：更改my.cnf配置文件

vi /usr/local/kkmail/config/mysql/my.cnf
将下面两行注释取消掉，然后重启MysqL
#general_log = 1
#general_log_file = /tmp/kkmail_MysqL.log
# 设置general log保存路径
# 好

方法一：更改my.cnf配置文件

vi /usr/local/kkmail/config/mysql/my.cnf
将下面两行注释取消掉，然后重启MysqL
#general_log = 1
#general_log_file = /tmp/kkmail_MysqL.log
# 设置general log保存路径
# 好像只能设置保存到 /tmp 或 /var 文件夹下。

方法二：在MySQL命令控制台操作

# 需要root用户才有访问此文件的权限
MysqL> show global variables like '%general%';
+------------------+----------------------------------------------------+
| Variable_name | Value |
+------------------+----------------------------------------------------+
| general_log | OFF |
| general_log_file | /usr/local/kkmail/data/MysqL/default/localhost.log |
+------------------+----------------------------------------------------+
2 rows in set (0.00 sec)

MysqL> set global general_log_file='/tmp/kkmail_MysqL.log';
Query OK, 0 rows affected (0.00 sec)

MysqL> set global general_log=on;
Query OK, 0 rows affected (0.05 sec)

MysqL> show global variables like '%general%';
+------------------+----------------------+
| Variable_name | Value |
+------------------+----------------------+
| general_log | ON |
| general_log_file | /tmp/kkmail_MysqL.log |
+------------------+----------------------+
2 rows in set (0.00 sec)

MysqL> set global general_log=off;
Query OK, 0 rows affected (0.00 sec)

MysqL> show global variables like '%general%';
+------------------+----------------------+
| Variable_name | Value |
+------------------+----------------------+
| general_log | OFF |
| general_log_file | /tmp/kkmail_MysqL.log |
+------------------+----------------------+
2 rows in set (0.00 sec)

方法三：将日志保存在MysqL数据库general_log表中

MysqL> set global log_output='table';
Query OK, 0 rows affected (0.00 sec)

MysqL> show global variables like '%general%';
+------------------+----------------------+
| Variable_name | Value |
+------------------+----------------------+
| general_log | OFF |
| general_log_file | /tmp/kkmail_MysqL.log |
+------------------+----------------------+
2 rows in set (0.00 sec)

MysqL> set global general_log=on;
Query OK, 0 rows affected (0.00 sec)

MysqL> show global variables like '%general%';
+------------------+----------------------+
| Variable_name | Value |
+------------------+----------------------+
| general_log | ON |
| general_log_file | /tmp/kkmail_MysqL.log |
+------------------+----------------------+
2 rows in set (0.01 sec)

MysqL> use MysqL
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

MysqL> select * from general_log;

（编辑：驾考网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!