mysqld 进程CUP占用过高

一、运营 top 查看服务器mysqld  PID  7279

 二、top -H p 7279 查看占用高的PID 是 14797

 三、mysql中查询当前PID 执行的SQL

SELECT
	a.USER,
	a.HOST,
	a.db,
	b.thread_os_id,
	b.thread_id,
	a.id processlist_id,
	a.command,
	a.time,
	a.state,
	a.info 
FROM
	information_schema.PROCESSLIST a,
	PERFORMANCE_SCHEMA.threads b 
WHERE
	a.id = b.processlist_id 
	AND b.thread_os_id = 7332;

SELECT
	* 
FROM
	PERFORMANCE_SCHEMA.events_statements_current 
WHERE
	thread_id = ( SELECT thread_id FROM PERFORMANCE_SCHEMA.threads WHERE thread_os_id = 524336 );