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>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