记录所有日志,只要在数据库里执行过,调试的时候测试可以偶尔打开,正式环境禁用
# 临时生效
mysql> set global general_log = on;
mysql> set global general_log_file = "/data/3306/mysql_all.log";
# 配置文件永久生效
general_log = on
general_log_file = /data/3306/mysql_all.log
[root@test01 /data/3306]# cat mysql_all.log
/application/mysql/bin/mysqld, Version: 5.5.62-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /data/3306/mysql.sock
Time Id Command Argument
190829 0:09:52 1 Query show variables like "general%"
190829 0:10:40 1 Query show variables like "general%"