mysql开启general_log记录sql执行记录
# 需要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)
页:
[1]