mysqld占用CPU过高
top
top -Hp 9239
3306 [test]> select thread_id,PROCESSLIST_ID ,THREAD_OS_ID from performance_schema.threads where THREAD_OS_ID=9199;
3306 [test]> select THREAD_ID ,SQL_TEXT from performance_schema.events_statements_history where THREAD_ID=35;
找到引起mysqld占用cup过高的语句