mysql中general_log(通用查询日志)关闭
[ 2017-06-23 09:00:34 | 作者: admin ]
通用查询日志--可以关闭
首先，进入mysql，输入
mysql> show global variables like '%general%';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| general_log | ON |
| general_log_file | /opt/mysql/master.log |
+------------------+-----------------------+
2 rows in set (0.00 sec)
之后，输入
评论Feed: http://blog.xg98.com/feed.asp?q=comment&id=2426
首先，进入mysql，输入
mysql> show global variables like '%general%';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| general_log | ON |
| general_log_file | /opt/mysql/master.log |
+------------------+-----------------------+
2 rows in set (0.00 sec)
之后，输入
mysql> set global general_log = off; // 关闭查询日志
mysql> show global variables like '%general%';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| general_log | OFF |
| general_log_file | /opt/mysql/master.log |
+------------------+-----------------------+
2 rows in set (0.00 sec)
mysql> show global variables like '%general%';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| general_log | OFF |
| general_log_file | /opt/mysql/master.log |
+------------------+-----------------------+
2 rows in set (0.00 sec)
评论Feed: http://blog.xg98.com/feed.asp?q=comment&id=2426
这篇日志没有评论。
此日志不可发表评论。
