SQL monitor

Mike SQL 7
Viewed 0

We use PA monitor at a number of sites for monitoring - great product!

however, it would be really good to have a MySQL plugin that could do SQL-based monitoring. For example, we want to count if a particular table has more than X errors in Y time period, and it would be great if PA could do this, report to us if that has happened and is 'in error', and then again when the problem is resolved.

Currently we have to run the SQL query in a batch file executed by Windows task scheduler, then use a PA log file monitor to check if the number is too great - but the log file monitor can't notify us when the problem is resolved.

something to consider for a future version!

sql monitor
6 Answers

Hi Mike,

We have a HowTo for the monitoring MySQL. Here is the link to How to Monitor MySQL

Thanks
Quinn

Quinn2713

Hi Quinn,

Thanks for your response. To clarify, I don't want to monitor the health of the MySQL application (although this is useful, thanks), I want to run specific queries against the MySQL database and take actions based on the results of those queries.

Mike SQL7

Hi Quinn,

Thanks for your response. To clarify, I don't want to monitor the health of the MySQL application (although this is useful, thanks), I want to run specific queries against the MySQL database and take actions based on the results of those queries.

Mike SQL7

Mike,
There are a few things that you could do.

Poll the Database by running the Execute Script monitor periodically to connect to your database and perform a check. There is an example script that shows how to do that. This method even lets you easily check on a database value (table size for example).

You could also use a Web Page monitor. Create a web page that connects to the database and then returns something like "OK" or "Problem". The Web Page monitor could then check that page and alert if it didn't see "OK". The web page could of course perform any sorts of checks that you need.

Quinn

Quinn2713

Thanks Quinn,

good suggestions. Do you have any plans to introduce a direct SQL monitor?

Thanks,

Mike

Mike SQL7

We do have an SQL monitor listed on our To-Do List but I don't have a date for that project to be worked on.

Thanks
Quinn

Quinn2713
Related