Is there a plungin to monitor database query

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Pratapa
Posts: 150
Joined: Tue Oct 01, 2019 1:33 am

Is there a plungin to monitor database query

Post by Pratapa »

Hi

Is there a plugin to monitor database query.

We would like to monintor a database query like the one below:

select count(*) from alloc_invn_dtl where stat_code = 11 and (sysdate - mod_date_time) * 24 * 60 > 30"
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Is there a plungin to monitor database query

Post by Box293 »

I am unsure what database you are talking about however Nagios Plugins has check_mysql_query which does require some pre-requisites to be installed as per https://support.nagios.com/kb/article.php?id=569.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked