[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [hobbit] mysql connections

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.
>
>
> 1. /etc/bb-hosts
> hostname TRENDS:*,mysql:mysqlslow,mysqlthread
>
> 2. 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"
>
> 3. 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