Hi all,
Thanks. Finally i am able to run the perl script and getting the results in the hobbit server.
one issue: my graphs are not coming. pls find below rrd-staus.log error details ...
2007-03-02 02:28:24 RRD error updating /home/hobbit/data/rrd/tor.abc.com/mysql.rrd from 64.88.160.214: not a simple integer: '0.024' 2007-03-02 02:32:51 RRD error updating /home/hobbit/data/rrd/jacc3.zbc.com/mysql.rrd from 147.183.128.102: not a simple integer: '13.910' 2007-03-02 02:38:25 RRD error updating /home/hobbit/data/rrd/abc.example.com/mysql.rrd from 64.88.160.214: not a simple integer: '0.024' 2007-03-02 02:42:53 RRD error updating /home/hobbit/data/rrd/abc.exam.com/mysql.rrd from 147.183.128.102: not a simple integer: '13.908'
Thanks Sabeer MZ
On 3/1/07, Dominique Frise <Dominique.Frise at unil.ch> wrote:
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.
/etc/bb-hosts hostname TRENDS:*,mysql:mysqlslow,mysqlthread
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"
- 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- Warm Regards Sabeer MZ