Tom, What type of problems AREN'T you detecting?
I'd take a wild guess and say you're only checking MySQL every 5 minutes or so. You can decrease the frequency between checks for more updated status. There are two variables that you need to look at: normal_check_interval, which is part of the services.cfg file. This determines how often to check your host. The second is interval_length in the nagios.cfg file. normal_check_interval * interval_length = time between checks in s. We decreased interval_length from 60 to 30, so each interval was 30 seconds instead of 60. This cuts the time between checks in half across the board. -J -----Original Message----- From: Tom Freeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 5:04 AM To: [EMAIL PROTECTED] Subject: MySQL Monitoring Tool Hi, I hope this question hasn't been asked loads of times before but I can't see any reference to it in the documentation. Basically I need a way to monitor MySQL to ensure it hasn't gone down. We are using MySQL as the backend of some important sites and need to ensure that if it does crash for whatever reason, an alert (email and SMS) is sent out to an engineer to resolve the problem. We are presently using a program known as NetSaint to monitor our services but it sometimes doesn't seem to be 100% reliable at detecting a MySQL error. Anyway, can anyone tell me a better way to monitor MySQL so that if it has any problems an oncall engineer can respond quickly. I'm sure this must be a common problem so there must be something out there already. Many thanks, Tom --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
