Two ways: MySQL view the SQL statement being executed

MySQL view the SQL statement being executedAugust 21, 2015 17:32:59 read: 15398

There are 2 ways of doing this:

1, the use of processlist, but there is a disadvantage, is only to view the SQL statements being executed, corresponding to the history, not see. The benefits are not set, and will not be saved.

-- use information_schema;-- show processlist;或者：-- select * from information_schema.`PROCESSLIST` where info is not null;

• 1
• 2
• 3
• 4

2. Turn on log mode

-- 1, settings--SET global log_output =  ' TABLE '; set global general_log =  ' on ';-- Span class= "Hljs-keyword" >set global log_output =  ' TABLE '; Span class= "Hljs-keyword" >set global general_log =  ' OFF ';-- Span class= "Hljs-number" > 2, query select * from Mysql.general_log order by event_time DESC--      

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10

Two ways: MySQL view the SQL statement being executed