mysql通用日志general log

开启通用日志
set global general_log=on;
设置通用日志存放方式 文件存储对性能的影响比表存储要小一些，但是表会额外存储user_host和server_id
set global log_output=‘file,table’;
set global log_output=‘table’;
set global log_output=‘file’;

表：

+----------------------------+---------------------------+-----------+-----------+--------------+---------------------------------+
| event_time                 | user_host                 | thread_id | server_id | command_type | argument                        |
+----------------------------+---------------------------+-----------+-----------+--------------+---------------------------------+
| 2018-10-07 20:16:26.360003 | root[root] @ localhost [] |        17 |   1353306 | Query        | select * from mysql.general_log |
+----------------------------+---------------------------+-----------+-----------+--------------+---------------------------------+

文件：

181007 20:17:02	   17 Query	select * from mysql.general_log
181007 20:17:20	   17 Query	select count(*) from mysql.general_log
181007 20:18:29	   17 Query	set global log_output='table'
181007 20:30:49	   17 Query	select * from mysql.general_log
181007 20:37:53	   17 Query	show slave status
181007 20:44:35	   17 Query	show tables
181007 20:45:05	   17 Query	create table yl1 (id int)
181007 20:45:19	   17 Query	insert into yl1 values (1)
181007 20:45:22	   17 Query	insert into yl1 values (3)
181007 20:45:24	   17 Query	insert into yl1 values (2)
181007 20:45:50	   17 Query	update yl1 set id=id+1