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>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 http://lists.xymon.com/mailman/listinfo/xymon