Ubuntu: How to Troubleshoot High CPU in MySQL
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> From the image above…