Create

by Jul 8, 2016

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.