Hello everybody,
I´m using MONyog 6.53 for some Percona 5.6*-servers. At the monitor “Current Connections” I noticed “Currently running threads” which increased over a short time, if a huge amount of queries run on a server.
I want to get info´s about that queries… I´ve createt a Custom SQL Object with a simple query “SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE Command != ‘Sleep’;”. I tried to create a new monitor, which fetch the result of this query. This new monitor should only be active or fetch results, if “Currently running threads” is at warning (over 20).
I hope somebody can help me.
If you need further informations, please let me know.
Thank you.