[hobbit] mysql connections

[Dominique Frise]

Sabeer MZ wrote:
> 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

Double-check your settings using the documentation from your Hobbit 
installation at http|https://$BBSERVERWWWNAME/$BBSERVERWWWURL/help/howtograph.html

or use Henrik's:

http://www.hswn.dk/hobbit/help/howtograph.html



Dominique
UNIL - University of Lausanne