命令

• show processlist:根据不同的账号权限可以看到所有用户的，当前用户的对应的连接。只有100条

• show full processlist:展示所有的连接数据

sql

select id, db, user, host, command, time, state, info
from information_schema.processlist
where command != 'Sleep'
and db='lts'
order by time desc