Mysql查询日志

Mysql查询日志

Mysql查询日志默认是关闭状态的。

mysql> show variables like '%general_log%';
+------------------+---------------------+
| Variable_name    | Value               |
+------------------+---------------------+
| general_log      | OFF                 |
| general_log_file | DESKTOP-0JS7U4E.log |
+------------------+---------------------+
2 rows in set, 1 warning (0.00 sec)

# 开启查询日志
mysql>
mysql> set global  general_log = 1;
Query OK, 0 rows affected (0.01 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13

• 查询日志文件DESKTOP-0JS7U4E.log里面的内容

记录所有的查询语句。

C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.26 (MySQL Community Server - GPL). started with:
TCP Port: 3306, Named Pipe: MySQL
Time                 Id Command    Argument
2024-08-19T13:02:31.525320Z	   21 Query	SELECT DATABASE()
2024-08-19T13:02:31.525809Z	   21 Init DB	test
2024-08-19T13:02:36.806746Z	   21 Query	select * from account
2024-08-19T13:03:22.238296Z	   21 Query	select * from account
2024-08-19T13:03:23.085120Z	   21 Query	select * from account

1
2
3
4
5
6
7
8
9

学习交流，知识分享