1)PS 命令查看
ps -eLlf|head -1;ps -eLlf|grep mysql
ps –Lf $pid
2)top
top -Hp $pid
3) pidstat
pidstat -t -p 16370
select THREAD_ID,PROCESSLIST_ID,THREAD_OS_ID,name,TYPE from performance_schema.threads; SELECT a.THREAD_ID, a.NAME, a.TYPE, a.PROCESSLIST_ID, a.PROCESSLIST_USER, a.PROCESSLIST_HOST, a.PROCESSLIST_DB, a.PROCESSLIST_COMMAND, a.PROCESSLIST_TIME, a.CONNECTION_TYPE, a.THREAD_OS_ID FROM performance_schema.threads a;
原文:https://www.cnblogs.com/binliubiao/p/12589059.html