Comments on: A Simple Approach to Troubleshooting High CPU in MySQL https://www.percona.com/blog/a-simple-approach-to-troubleshooting-high-cpu-in-mysql/ Mon, 02 Oct 2023 13:43:14 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Tarik https://www.percona.com/blog/a-simple-approach-to-troubleshooting-high-cpu-in-mysql/#comment-10972301 Tue, 02 Jun 2020 14:29:36 +0000 https://www.percona.com/blog/?p=67247#comment-10972301 As the column THREAD_OS_ID is not available on mysql 5.6, do we have an alternative? Thank you

]]>
By: Asif Iqbal https://www.percona.com/blog/a-simple-approach-to-troubleshooting-high-cpu-in-mysql/#comment-10972153 Thu, 23 Apr 2020 16:58:30 +0000 https://www.percona.com/blog/?p=67247#comment-10972153 I would use pidstat -t -C "mysqld" 1 will save you some time from getting PID for mysqld. If you don’t use interval, yes it may show mysqld_safe as well, but in this case with interval 1 it will not.

]]>