MYSQL记录全部日志功能(哈哈哈,IO消耗致死)

记录所有日志,只要在数据库里执行过,调试的时候测试可以偶尔打开,正式环境禁用
 

# 临时生效
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%"