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

Thanks, that did the trick!

Regards,

Joost

Charles Goyard wrote:

Joost van den Broek wrote :

...

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.

You have to add ",mysql=ncv" to TEST2RRD, and then restart the hobbitd_rrd processes. On Linux, try :

killall pidof hobbitd_rrd or killall pidof hobbitd_larrd if you have an old hobbit installation.

The processes will respawn a few seconds later.

(or restart you whole hobbit service if you prefer).

Hi,

also on clientdata.log, im getting Unknown token error.

2007-02-28 01:43:04 Tried to down BOARDBUSY: Invalid argument 2007-02-28 01:43:50 Unknown token '[mysql]' ignored at line 382 2007-02-28 01:43:50 Unknown token 'DEF:t=mysql.rrd:threads:AVERAGE' ignored at line 383 2007-02-28 01:43:50 Unknown token 'DEF:q=mysql.rrd:questions:AVERAGE' ignored at line 384 2007-02-28 01:43:50 Unknown token 'DEF:s=mysql.rrd:slowqueries:AVERAGE' ignored at line 385 2007-02-28 01:43:50 Unknown token 'TITLE' ignored at line 386 2007-02-28 01:43:50 Unknown token 'YAXIS' ignored at line 387 2007-02-28 01:43:50 Unknown token 'LINE1:q' ignored at line 388 2007-02-28 01:43:50 Unknown token 'GPRINT:q:LAST:' ignored at line 389 2007-02-28 01:43:50 Unknown token 'GPRINT:q:MIN:min\:' ignored at line 390

Thanks Sabeer MZ

On 2/28/07, Sabeer MZ <sabeer.mz at gmail.com> wrote:

Hi Charles, Many thanks for the info.

i am newbie to hobbit.

1. I am getting error on rrd-status.log. what may be the issue.

2007-02-28 02:41:50 Tried to down BOARDBUSY: Invalid argument 2007-02-28 02:42:29 RRD error updating /home/hobbit/data/rrd/monitor.jrg.com/mysql.rrd from 64.88.160.214: not a simple integer: '0.027' 2007-02-28 02:43:30 RRD error updating /home/hobbit/data/rrd/monitor.jrg.com/mysql.rrd from 64.88.160.214: not a simple integer: '0.027' 2007-02-28 02:45:30 RRD error updating /home/hobbit/data/rrd/monitor.jrg.com/mysql.rrd from 64.88.160.214: not a simple integer: '0.027'

2. I am not sure abt the "getconfig("bb-mysql.cfg-$MACHINEDOTS");" i.e I am not getting idea how to create this file. if possible give me one example.-

or use server-side config : create a etc/clientside/bb-

mysql.cfg-HOSTNAME

on the hobbit server, with the following setup :

mysqlclient=/some/other/client

auth=-uthisuser -pthatpassword -Sothersocket

3. how to setup a client using this perl script.

thanks Sabeer MZ

On 2/23/07, Joost van den Broek <joost at seat-ibiza.nl> wrote:

...

Thanks, that did the trick!

Regards,

Joost

Charles Goyard wrote:

...

Joost van den Broek wrote :

...

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.

You have to add ",mysql=ncv" to TEST2RRD, and then restart the hobbitd_rrd processes. On Linux, try :

killall pidof hobbitd_rrd or killall pidof hobbitd_larrd if you have an old hobbit installation.

The processes will respawn a few seconds later.

(or restart you whole hobbit service if you prefer).

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

-- Warm Regards Sabeer MZ