MySQL general log

浏览数：28 / 时间：2015年06月12日

1:查看版本

SELECT VERSION();

2：查看当前的日志保存方式

mysql> SHOW VARIABLES LIKE ‘%log_output%‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    | TABLE |
+---------------+-------+
1 row in set (0.00 sec)

3：查看当前是否开启了general log

mysql> SHOW VARIABLES LIKE ‘%general_log%‘;
+------------------+----------------------------+
| Variable_name    | Value                      |
+------------------+----------------------------+
| general_log      | ON                         |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+
2 rows in set (0.00 sec)

4：关闭打开general log

mysql> SET GLOBAL GENERAL_LOG = ON;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL general_log_file =‘/tmp/general.log‘;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL GENERAL_LOG = OFF;
Query OK, 0 rows affected (0.00 sec)

5：设置日志的输出格式

mysql> SHOW VARIABLES LIKE ‘%log_output%‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    | FILE  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> SET GLOBAL log_output = ‘TABLE‘;
Query OK, 0 rows affected (0.00 sec)

郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。

MySQL general log