Hopefully you are referring to change below lines. I am not experienced guy and got below code from mailing list. please let me know which line i have to correct it.
[mysql] DEF:t=mysql.rrd:threads:AVERAGE DEF:q=mysql.rrd:questions:AVERAGE DEF:s=mysql.rrd:slowqueries:AVERAGE TITLE Monitoring MySQL YAXIS count LINE1:q#FF0000:Requês GPRINT:q:LAST: \: %3.0lf (cur) GPRINT:q:MAX: \: %3.0lf (max) GPRINT:q:MIN: \: %3.0lf (min) GPRINT:q:AVERAGE: \: %3.0lf (avg)\n LINE1:s#0000FF:Req. lentes GPRINT:s:LAST: \: %3.0lf (cur) GPRINT:s:MAX: \: %3.0lf (max) GPRINT:s:MIN: \: %3.0lf (min) GPRINT:s:AVERAGE: \: %3.0lf (avg)\n LINE1:t#00FF00:Threads GPRINT:t:LAST: \: %3.0lf (cur) GPRINT:t:MAX: \: %3.0lf (max) GPRINT:t:MIN: \: %3.0lf (min) GPRINT:t:AVERAGE: \: %3.0lf (avg)\n
Thanks Sabeer MZ
On 3/5/07, Jones, Jason (Altrincham) <JasonAS_Jones at mentor.com> wrote:
My guess is the problem is what it says in that the number is not a simple integer, try going to 2 decimal places instead of three if possible.
Thanks,
Jason.
*From:* Sabeer MZ [mailto:sabeer.mz at gmail.com] *Sent:* 05 March 2007 10:42 *To:* hobbit at hswn.dk *Subject:* Re: [hobbit] mysql connections
Dear all,
Any comments on below errors. I am not able to see graphs for the data coming. And I see below errors on /var/log/hobbit/rrd-stastus.log
2007-03-05 02:34:05 RRD error updating /home/hobbit/data/rrd/abx.acc.com/mysql.rrd from 147.183.128.102: not a simple integer: '13.617' 2007-03-05 02:34:16 RRD error updating /home/hobbit/data/rrd/abcx.abccom/mysql.rrd from 147.183.128.98 : not a simple integer: '106.435' 2007-03-05 02:35:16 RRD error updating /home/hobbit/data/rrd/abc.abc.com/mysql.rrd from 147.183.128.98: not a simple integer: '106.435 '
thanks Sabeer MZ
On 3/2/07, *Sabeer MZ* <sabeer.mz at gmail.com> wrote:
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
-- Warm Regards Sabeer MZ
-- Warm Regards Sabeer MZ