开启通用日志
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