- Run ‘top’ to check PID of mysqld causes high CPU load
- Run the following command to check thread ID: pidstat -t -p <mysqld_pid> 1
- Login to mysql as root user and run the following command to get slow query causes high CPU load: select * from performance_schema.threads where THREAD_OS_ID = <TID>
