Create

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.