> ## Content Index
> Fetch the complete content index at: https://blog.hacking.pub/llms.txt
> Use this file to discover other available public pages before exploring further.

# MySQL 通用查询日志
- URL: https://blog.hacking.pub/2017/05/14/mysql-tong-yong-cha-xun-ri-zhi-general-query-log/
- Published: 2017-05-14T07:58:31.000Z
- Updated: 2017-05-14T07:58:31.000Z
- Author: chainhelen
- Tags: mysql, 数据库, 日志

首先推荐一款linux下的mysql客户端mycli

mysql里面有很多日志，如bin日志用来恢复数据，慢查询日志用来监控查询较慢的数据

只记了通用日志的开启方式，其他的日志都是类似命令

```
mysql root@localhost:(none)> show global variables like '%gener%';
+------------------+--------------------------------------------+
| Variable_name    | Value                                      |
|------------------+--------------------------------------------|
| general_log      | OFF                                        |
| general_log_file | /var/lib/mysql/iZwz92pw32r9w6beu4jlfpZ.log |
+------------------+--------------------------------------------+

mysql root@localhost:(none)> SET global general_log = ON;
Query OK, 0 rows affected
Time: 0.001s
mysql root@localhost:(none)> show global variables like '%gener%';
+------------------+--------------------------------------------+
| Variable_name    | Value                                      |
|------------------+--------------------------------------------|
| general_log      | ON                                         |
| general_log_file | /var/lib/mysql/iZwz92pw32r9w6beu4jlfpZ.log |
+------------------+--------------------------------------------+

```

日志也可以记到数据库里面，不输出到文件里

```
mysql root@localhost:(none)> show variables like 'log_output'
+-----------------+---------+
| Variable_name   | Value   |
|-----------------+---------|
| log_output      | FILE    |
+-----------------+---------+

mysql root@localhost:(none)> SET global log_output = 'table';
Query OK, 0 rows affected
Time: 0.001s
mysql root@localhost:(none)> show variables like 'log_output'
+-----------------+---------+
| Variable_name   | Value   |
|-----------------+---------|
| log_output      | TABLE   |
+-----------------+---------+

mysql root@localhost:(none)> set global log_output = 'file';
Query OK, 0 rows affected
Time: 0.001s
mysql root@localhost:(none)> show variables like 'log_output'
+-----------------+---------+
| Variable_name   | Value   |
|-----------------+---------|
| log_output      | FILE    |
+-----------------+---------+

```