Oct 7, 2018

[HDGEM] How to how MySQL process list without sleeping connections

SELECT * FROM information_schema.processlist WHERE command != 'Sleep'

all non-sleeping queries that take some time, for example at least 2 seconds:

SELECT user, time, state, info FROM information_schema.processlist WHERE command != 'Sleep' AND time >= 2 ORDER BY time DESC, id;



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