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