mysql cpu线上问题排查

查看当前的线程情况
show full processlist
查看当前的线程情况
SELECT * FROM performance_schema.threads WHERE PROCESSLIST_TIME >= 0
查看当前数据库的连接数
SELECT * FROM performance_schema.threads WHERE PROCESSLIST_DB =‘db’ ;

查看当前mysql连接的数
SHOW GLOBAL STATUS LIKE ‘Threads_connected’;