Oct 7, 2018

[HDGEM] The MySQL threads table contains a row for each server thread.

Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it:

SELECT * FROM performance_schema.threads

To exclude those Sleep threads:

SELECT * FROM performance_schema.threads where PROCESSLIST_COMMAND !='Sleep'

--
Posted By Blogger to HDGEM at 4/04/2017 10:29:00 AM