MySQL-查询线程信息

1. 系统命令

1）PS 命令查看

ps -eLlf|head -1;ps -eLlf|grep mysql

ps –Lf $pid

2）top

top -Hp $pid

3) pidstat

pidstat  -t -p 16370

2. MySQL查看

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;

MySQL-查询线程信息

原文：https://www.cnblogs.com/binliubiao/p/12589059.html