mysql查看占用内存或者CPU高的SQL

获取mysql进程id

ps -ef | grep -i mysql

实时查看mysql进程中占用CPU，内存最多的操作系统线程ID

top -p 2341 -H

根据操作系统线程ID，查看mysql数据库中对应的线程ID

select thread_id,name ,PROCESSLIST_ID,THREAD_OS_ID from threads where thread_os_id = 2341 ;

根据mysql数据库的线程ID获取sql

select sql_text from performance_schema.events_statements_current where thread_id = 34 \G;