Re: MySQL Monitoring Alerts

2002-09-10 Thread Eric Lamendola
Mike, I totally agree. The log solution wasn't my idea though . No matter what language you write the script in, any type of ""Get some kind of response by throwing something against the server and seeing if it sticks"" response will get you the information you need. I set up a dummy account

Re: MySQL Monitoring Alerts

2002-09-10 Thread mos
Eric, Isn't letting an outside connection access to your log file a "little dangerous"? Why not create a dummy table with just one record in it, restrict it to read access only, then use your chron job on a remote computer to run a PHP/Perl script to access that record over the net. I

Re: MySQL Monitoring Alerts

2002-09-10 Thread Eric Lamendola
Hey, I noticed another response about "tailing the log" and looking for information in the "err" log which looks like a great solution. However, if you have an extra computer laying around, you can also set up a cron job with a shell script that connects to the server (via telnet or using a m

MySQL Monitoring Alerts

2002-09-10 Thread Tom Freeman
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 w