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
-- Charles Goyard - cgoyard at cvf.fr - (+33) 1 45 38 01 31