mysql 查询正在执行的sql

https://www.cnblogs.com/sxmny/p/10441346.html

 

select * from information_schema.`PROCESSLIST` where info is not null;

或者

 
-- use information_schema;
-- show processlist;

 

show processlist

  show processlist  能看到所有库以及用户的执行情况