select * from information_schema.`PROCESSLIST` where info is not null;
或者
-- use information_schema;-- show processlist;show processlist
show processlist 能看到所有库以及用户的执行情况
来源: http://www.bubuko.com/infodetail-2969305.html