MySQL connections ?

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