[hobbit] MySQL connections ?

[Joost van den Broek]

Hi,

Thanks for the modified version, but I can't get the graphs working. 
What exactly do I have to do to have these graphs? I already added 
',mysql' to the TEST2RRD line in hobbitserver.cfg and TRENDS:*,mysql to 
the related host in bb-hosts. It seems that there aren't any mysql.rrd 
files created.

Thanks,

Joost

Charles Goyard wrote:
> Hi,
> 
> Sabeer MZ wrote :
>> One question: does anybody know if there is a module for Hobbit to
>> monitor the number of MySQL connections ?
> 
> there's one here : http://www.trantor.org/theshire/doku.php/monitors:bb-mysql
> 
> There's anoter version that can fetch its configuration from the hobbit
> server, provided as a attachement in this message.
> 
> And here's the graph setup I use :
> 
> [mysql]
>         DEF:t=mysql.rrd:threads:AVERAGE
>         DEF:q=mysql.rrd:questions:AVERAGE
>         DEF:s=mysql.rrd:slowqueries:AVERAGE
>         TITLE Requêtes SQL
>         YAXIS count
>         LINE1:q#FF0000:Requêtes
>         GPRINT:q:LAST:     cur\: %3.0lf
>         GPRINT:q:MIN:min\: %3.0lf
>         GPRINT:q:MAX:max\: %3.0lf
>         GPRINT:q:AVERAGE:avg\: %3.0lf\n
>         LINE1:s#0000FF:Req. lentes
>         GPRINT:s:LAST:  cur\: %3.0lf
>         GPRINT:s:MIN:min\: %3.0lf
>         GPRINT:s:MAX:max\: %3.0lf
>         GPRINT:s:AVERAGE:avg\: %3.0lf\n
>         LINE1:t#00FF00:Threads
>         GPRINT:t:LAST:      cur\: %3.0lf
>         GPRINT:t:MIN:min\: %3.0lf
>         GPRINT:t:MAX:max\: %3.0lf
>         GPRINT:t:AVERAGE:avg\: %3.0lf\n
> 
> 
> There is also the a multi-db agent here, that looks very fine (never
> tried it) : http://sourceforge.net/projects/hobbit-perl-cl
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk