Thanks guys. Josh, do you know the name of it on deadcat? I couldn't seem to find that one yesterday.
Thanks again!
Don
From: Josh Luthman <josh at imaginenetworksllc.com<mailto:josh at imaginenetworksllc.com>> Date: Fri, 10 May 2013 12:26:13 -0400 To: Don Kuhlman <don.kuhlman at schawk.com<mailto:don.kuhlman at schawk.com>> Cc: Xymon Email List <xymon at xymon.com<mailto:xymon at xymon.com>> Subject: Re: [Xymon] Anyone know of a MySQL Server monitoring script?
I use one from deadcat, I think.
Mine looks like this:
Fri May 10 12:18:04 2013 MySQL Server OK
threads: 1 questions: 9005502 slow queries: 0 opens: 2011607 flush tables: 1 open tables: 64 queries per second avg: 0.072 maxcon: 100
Server version: 5.0.45 Source distribution Uptime: 1442 days 1 hour 10 min 43 sec
Server reports timestamp of 2013-05-10 12:18:04
Josh Luthman Office: 937-552-2340 Direct: 937-552-2343 1100 Wayne St Suite 1337 Troy, OH 45373
On Fri, May 10, 2013 at 12:00 PM, Don Kuhlman <Don.Kuhlman at schawk.com<mailto:Don.Kuhlman at schawk.com>> wrote: Hi all. Hoping to see if anyone has seen a more recent custom script or has a suggestion on how to best monitor a MySQL server from Xymon.
I found a perl script called bb-SQLServer.pl which looks like it will test a sql server from xymon.
It's a bit older and I was wondering if anyone has a location for one that works with MySQL to check connections to the database and provide timings, etc.?
Thanks
Don K
Xymon mailing list Xymon at xymon.com<mailto:Xymon at xymon.com> http://lists.xymon.com/mailman/listinfo/xymon