mysql connections

Sabeer MZ sabeer.mz at gmail.com
Thu Mar 1 08:37:09 CET 2007


Hi all,

cloud anyone help me why there is no graphs showing for me.
I am trying to monitor mysql connections using bb-mysql.pl.


1. /etc/bb-hosts
hostname TRENDS:*,mysql:mysqlslow,mysqlthread

2. 3 entries for mysql at hobbitserver.cfg

TEST2RRD="cpu=la,disk,------cut--------,ports,clock,lines",mysql=ncv"

GRAPHS="la,mysql,disk,-------cut-------clock,lines"

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

3. my hobbitgraph.cfg

[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        YAXIS #
        LINE2:slow#00CCCC:Slow Queries
        COMMENT:\n
        GPRINT:slow:LAST: \: %5.1lf (cur)
        GPRINT:slow:MAX: \: %5.1lf (max)
        GPRINT:slow:MIN: \: %5.1lf (min)
        GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n

[mysqlthread]
        DEF:threads=mysql.rrd:Threads:AVERAGE
        TITLE MySQL Active Threads
        YAXIS #
        AREA:threads#00CCCC:Threads
        COMMENT:\n
        GPRINT:threads:LAST: \: %5.1lf (cur)
        GPRINT:threads:MAX: \: %5.1lf (max)
        GPRINT:threads:MIN: \: %5.1lf (min)
        GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n


-- 
Warm Regards
Sabeer MZ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070301/83cd30b9/attachment.html>


More information about the Xymon mailing list