If you need to do a *LOT* of MySQL checks, I have a multithreaded script
I'm using here; I'm a little curious how it'd work for others...
If you're interested let me know and I can send it off list.
Regards,
-jc
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
<user-4c45a83f15cb@xymon.invalid<mailto:user-4c45a83f15cb@xymon.invalid>>
Date: Fri, 10 May 2013 12:26:13 -0400
To: Don Kuhlman <user-5eb2bfadc6c6@xymon.invalid<mailto:user-5eb2bfadc6c6@xymon.invalid>>
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: XXX-XXX-XXXX
Direct: XXX-XXX-XXXX
XXXX Wayne St
Suite XXXX
Troy, OH XXXXX
On Fri, May 10, 2013 at 12:00 PM, Don Kuhlman
<user-5eb2bfadc6c6@xymon.invalid<mailto:user-5eb2bfadc6c6@xymon.invalid>> 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