传统的查询mysql的正在执行进程
show processlist;
此只能查到部分sql。如果想查询到具体的sql
select id, db, user, host, command, time, state, info
from information_schema.processlist
order by time desc
传统的查询mysql的正在执行进程
show processlist;
此只能查到部分sql。如果想查询到具体的sql
select id, db, user, host, command, time, state, info
from information_schema.processlist
order by time desc