mysql connections

24 messages in this thread

list Sabeer MZ · Thu, 1 Mar 2007 13:07:09 +0530 ·

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 user-bbd62860565a@xymon.invalid

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

list Dominique Frise · Thu, 01 Mar 2007 09:04:03 +0100 ·

▸ quoted from Sabeer MZ

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 user-bbd62860565a@xymon.invalid

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

▸ quoted from Sabeer MZ

        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

list Sabeer MZ · Fri, 2 Mar 2007 16:18:16 +0530 ·

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

▸ quoted from Dominique Frise


On 3/1/07, Dominique Frise <user-78ab6673b600@xymon.invalid> 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 user-bbd62860565a@xymon.invalid

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

--


Warm Regards
Sabeer MZ

list Sabeer MZ · Mon, 5 Mar 2007 16:11:49 +0530 ·

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

▸ quoted from Sabeer MZ


On 3/2/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> 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 <user-78ab6673b600@xymon.invalid> 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 user-bbd62860565a@xymon.invalid

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

--
Warm Regards
Sabeer MZ

--


Warm Regards
Sabeer MZ

list Jason Altrincham Jones · Mon, 5 Mar 2007 10:52:53 -0000 ·

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.

▸ quoted from Sabeer MZ


 
From: Sabeer MZ [mailto:user-c73a09452f94@xymon.invalid] 
Sent: 05 March 2007 10:42
To: user-ae9b8668bcde@xymon.invalid
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 <user-c73a09452f94@xymon.invalid> 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 <user-78ab6673b600@xymon.invalid > 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 user-bbd62860565a@xymon.invalid

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


-- 
Warm Regards
Sabeer MZ 


-- 
Warm Regards
Sabeer MZ

list Sabeer MZ · Mon, 5 Mar 2007 16:35:00 +0530 ·

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

▸ quoted from Jason Altrincham Jones


On 3/5/07, Jones, Jason (Altrincham) <user-ee957b46acd2@xymon.invalid> 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:user-c73a09452f94@xymon.invalid]
*Sent:* 05 March 2007 10:42
*To:* user-ae9b8668bcde@xymon.invalid
*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* <user-c73a09452f94@xymon.invalid> 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* <user-78ab6673b600@xymon.invalid > 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 user-bbd62860565a@xymon.invalid

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


 --
Warm Regards
Sabeer MZ


--
Warm Regards
Sabeer MZ

-- 
Warm Regards
Sabeer MZ

list Charles Goyard · Mon, 5 Mar 2007 12:09:20 +0100 ·

Hi,

▸ quoted from Sabeer MZ


Sabeer MZ wrote :

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

RRD error updating /home/hobbit/data/rrd/abc.abc.com/mysql.rrd from
147.183.128.98: not a simple integer: '106.435'

just wondering : how do you end up with a non-integer number of
connexions ?


-- 
Charles Goyard - user-98f9625a7a59@xymon.invalid - (+33) 1 45 38 01 31

list Sabeer MZ · Mon, 5 Mar 2007 16:46:36 +0530 ·

This is my output when i excute the perl script.
hope this gives you some inputs

[hobbit at abc2 ext]$ perl bb-mysql.pl
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 52.
Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 118.
Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 118.
sh: config bb-mysql.cfg-: command not found
Use of uninitialized value in substitution (s///) at bb-mysql.pl line 128.
Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 131.
Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 131.
Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 131.
sh: line 16: status .mysql green Mon Mar  5 06:15:05 2007 MySQL Server OK

threads: 42
questions: 205976663
slow queries: 10
opens: 6671453
flush tables: 1
open tables: 64
queries per second avg: 7.429
maxcon: 100

Server version: 4.0.24-standard

Uptime: 320 days 21 hours 41 min 19 sec

Server reports timestamp of 2007-03-05 06:15:05
: command not found

thanks
Sabeer MZ

▸ quoted from Charles Goyard


On 3/5/07, Charles Goyard <user-98f9625a7a59@xymon.invalid> wrote:

Hi,

Sabeer MZ wrote :

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

RRD error updating /home/hobbit/data/rrd/abc.abc.com/mysql.rrd from
147.183.128.98: not a simple integer: '106.435'

just wondering : how do you end up with a non-integer number of
connexions ?


--
Charles Goyard - user-98f9625a7a59@xymon.invalid - (+33) 1 45 38 01 31

--


Warm Regards
Sabeer MZ

list Ralph Mitchell · Mon, 5 Mar 2007 06:52:05 -0600 ·

▸ quoted from Sabeer MZ

On 3/5/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> wrote:

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

Nope, it's probably not the above, which is for drawing the graph.
The error message says:

   RRD error updating /home/hobbit/data/rrd/abx.acc.com/mysql.rrd

note where it says "updating".  Isn't that on the input side, not the
the graph drawing side??

Ralph Mitchell

list Sabeer MZ · Mon, 5 Mar 2007 19:03:56 +0530 ·

any guess :)


On 3/5/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> wrote:


This is my output when i excute the perl script.
hope this gives you some inputs

[hobbit at abc2 ext]$ perl bb-mysql.pl
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 52.
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 118.
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 118.
sh: config bb-mysql.cfg-: command not found
Use of uninitialized value in substitution (s///) at bb-mysql.pl line 128.
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 131.
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 131.
Use of uninitialized value in concatenation (.) or user-f7b434c156ce@xymon.invalid 131.
sh: line 16: status .mysql green Mon Mar  5 06:15:05 2007 MySQL Server OK

threads: 42
questions: 205976663
slow queries: 10
opens: 6671453
flush tables: 1
open tables: 64
queries per second avg: 7.429
maxcon: 100

Server version: 4.0.24-standard

Uptime: 320 days 21 hours 41 min 19 sec

Server reports timestamp of 2007-03-05 06:15:05
: command not found

thanks
Sabeer MZ

On 3/5/07, Charles Goyard <user-98f9625a7a59@xymon.invalid> wrote:

Hi,

Sabeer MZ wrote :

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

RRD error updating /home/hobbit/data/rrd/abc.abc.com/mysql.rrd from
147.183.128.98: not a simple integer: '106.435'

just wondering : how do you end up with a non-integer number of
connexions ?


--
Charles Goyard - user-98f9625a7a59@xymon.invalid - (+33) 1 45 38 01 31

--
Warm Regards
Sabeer MZ


-- 
Warm Regards
Sabeer MZ

list Jason Altrincham Jones · Mon, 5 Mar 2007 14:15:08 -0000 ·

It's just a warning I think:

 
[hobbit at abc2 ext]$ perl bb-mysql.pl
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 52.

you use an unitialised variable on line 52


Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 118.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 118.

You use 2 more on line 118


sh: config bb-mysql.cfg-: command not found

this command cannot be found (no prizes for the one :-) )


Use of uninitialized value in substitution (s///) at bb-mysql.pl line
128.

You're using an uninitialised variable in your sed command (or similar
command)


Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 131.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 131.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 131.

3 more on line 131


You should prob initialise the variables before you use them, not sure
on syntax in perl from memory but something like:

 
private int test

test=0

...

 
As for the command not found guessing the call is wrong, maybe a typo?

▸ quoted from Sabeer MZ

Jason.

From: Sabeer MZ [mailto:user-c73a09452f94@xymon.invalid] 
Sent: 05 March 2007 13:34
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

any guess :)

On 3/5/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> wrote:

This is my output when i excute the perl script.
hope this gives you some inputs

[hobbit at abc2 ext]$ perl bb-mysql.pl


Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 52.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 118.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 118.

▸ quoted from Sabeer MZ

sh: config bb-mysql.cfg-: command not found
Use of uninitialized value in substitution (s///) at bb-mysql.pl line
128.


Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 131.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 131.
Use of uninitialized value in concatenation (.) or user-69432286eeb3@xymon.invalid
line 131.

▸ quoted from Sabeer MZ

sh: line 16: status .mysql green Mon Mar  5 06:15:05 2007 MySQL Server
OK

threads: 42
questions: 205976663
slow queries: 10
opens: 6671453
flush tables: 1
open tables: 64
queries per second avg: 7.429
maxcon: 100

Server version: 4.0.24-standard

Uptime: 320 days 21 hours 41 min 19 sec

Server reports timestamp of 2007-03-05 06:15:05
: command not found

thanks 
Sabeer MZ


On 3/5/07, Charles Goyard < user-98f9625a7a59@xymon.invalid <mailto:user-98f9625a7a59@xymon.invalid> >

▸ quoted from Sabeer MZ

wrote:

Hi,

Sabeer MZ wrote :

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

RRD error updating /home/hobbit/data/rrd/abc.abc.com/mysql.rrd from
147.183.128.98: not a simple integer: ' 106.435'

just wondering : how do you end up with a non-integer number of 
connexions ?


--
Charles Goyard - user-98f9625a7a59@xymon.invalid - (+33) 1 45 38 01 31


-- 
Warm Regards
Sabeer MZ 


-- 
Warm Regards
Sabeer MZ

list Stef Coene · Mon, 5 Mar 2007 15:26:19 +0100 ·

On Monday 05 March 2007 14:33, Sabeer MZ wrote:

any guess :)

Try

../bin/bbcmd perl bb-mysql.pl


Stef

list Jason Altrincham Jones · Mon, 5 Mar 2007 16:37:23 -0000 ·

Try:

/<rrd install dir>/bin/rrdtool dump /<hobbit install dir>/data/<servername>/<testname>.rrd | more

You should see the data declarations for the database should be something like:

<!-- Round Robin Database Dump -->
<rrd>
        <version> 0003 </version>
        <step> 300 </step> <!-- Seconds -->
        <lastupdate> 1173112124 </lastupdate> <!-- 2007-03-05 16:28:44 GMT -->

        <ds>
                <name> runtime </name>
                <type> GAUGE </type>
...
<!-- 2007-03-03 22:40:00 GMT / 1172961600 --> <row><v> 1
.0503600000e+01 </v></row>
                        <!-- 2007-03-03 22:45:00 GMT / 1172961900 --> <row><v> 1
.0325800000e+01 </v></row>
                        <!-- 2007-03-03 22:50:00 GMT / 1172962200 --> <row><v> 1
.1187333333e+01 </v></row>
                        <!-- 2007-03-03 22:55:00 GMT / 1172962500 --> <row><v> 1
.0944200000e+01 </v></row>

The values below ... aren't relevant just that it doesn't say NaN (there may be a few initial lines that do) after the timestamp though make sure the <type> and <name> setting are what you expect them to be.

Jason.

▸ quoted from Ralph Mitchell


-----Original Message-----
From: Ralph Mitchell [mailto:user-00a5e44c48c0@xymon.invalid] 
Sent: 05 March 2007 12:52
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

On 3/5/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> wrote:

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

Nope, it's probably not the above, which is for drawing the graph.
The error message says:

   RRD error updating /home/hobbit/data/rrd/abx.acc.com/mysql.rrd

note where it says "updating".  Isn't that on the input side, not the
the graph drawing side??

Ralph Mitchell

list Sabeer MZ · Tue, 6 Mar 2007 10:00:13 +0530 ·

Good suggestions. I checked the mysql.rrd and it has lots of NaN entries.
shall i delete it and create a new one.

[hobbit at linux ~]$ rrdtool dump data/rrd/abc2.acd.com/mysql.rrd | more

▸ quoted from Jason Altrincham Jones

<!-- Round Robin Database Dump --><rrd> <version> 0003 </version>
        <step> 300 </step> <!-- Seconds -->


        <lastupdate> 1173155037 </lastupdate> <!-- 2007-03-05 20:23:57 PST
-->

        <ds>
                <name> threads </name>
                <type> DERIVE </type>
                <minimal_heartbeat> 600 </minimal_heartbeat>
                <min> NaN </min>
                <max> NaN </max>

                <!-- PDP Status -->
                <last_ds> 42 </last_ds>
                <value> NaN </value>
                <unknown_sec> 237 </unknown_sec>
        </ds>

        <ds>
                <name> questions </name>
                <type> DERIVE </type>
                <minimal_heartbeat> 600 </minimal_heartbeat>
                <min> NaN </min>
                <max> NaN </max>

                <!-- PDP Status -->
                <last_ds> 207587169 </last_ds>
                <value> NaN </value>
                <unknown_sec> 237 </unknown_sec>
        </ds>

        <ds>
                <name> slowqueries </name>
                <type> DERIVE </type>
                <minimal_heartbeat> 600 </minimal_heartbeat>
                <min> NaN </min>
                <max> NaN </max>

                <!-- PDP Status -->
                <last_ds> 10 </last_ds>
                <value> NaN </value>
                <unknown_sec> 237 </unknown_sec>

Regards

▸ quoted from Jason Altrincham Jones

Sabeer MZ

On 3/5/07, Jones, Jason (Altrincham) <user-ee957b46acd2@xymon.invalid> wrote:

Try:

/<rrd install dir>/bin/rrdtool dump /<hobbit install
dir>/data/<servername>/<testname>.rrd | more

You should see the data declarations for the database should be something
like:

<!-- Round Robin Database Dump -->
<rrd>
        <version> 0003 </version>
        <step> 300 </step> <!-- Seconds -->
        <lastupdate> 1173112124 </lastupdate> <!-- 2007-03-05 16:28:44 GMT
-->

        <ds>
                <name> runtime </name>
                <type> GAUGE </type>
...
<!-- 2007-03-03 22:40:00 GMT / 1172961600 --> <row><v> 1
.0503600000e+01 </v></row>
                        <!-- 2007-03-03 22:45:00 GMT / 1172961900 -->
<row><v> 1
.0325800000e+01 </v></row>
                        <!-- 2007-03-03 22:50:00 GMT / 1172962200 -->
<row><v> 1
.1187333333e+01 </v></row>
                        <!-- 2007-03-03 22:55:00 GMT / 1172962500 -->
<row><v> 1
.0944200000e+01 </v></row>

The values below ... aren't relevant just that it doesn't say NaN (there
may be a few initial lines that do) after the timestamp though make sure the
<type> and <name> setting are what you expect them to be.

Jason.

-----Original Message-----
From: Ralph Mitchell [mailto:user-00a5e44c48c0@xymon.invalid]
Sent: 05 March 2007 12:52
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

On 3/5/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> wrote:

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

▸ quoted from Jason Altrincham Jones

       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

Nope, it's probably not the above, which is for drawing the graph.
The error message says:

   RRD error updating /home/hobbit/data/rrd/abx.acc.com/mysql.rrd

note where it says "updating".  Isn't that on the input side, not the
the graph drawing side??

Ralph Mitchell

--


Warm Regards
Sabeer MZ

list Sabeer MZ · Tue, 6 Mar 2007 11:14:58 +0530 ·

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

I tried to set on .bash_profile of user hobbit b coz i am running linux and
do have user hobbit
and no luck it s not working.

thanks
Sabeer MZ

▸ quoted from Stef Coene


On 3/5/07, Stef Coene <user-dbffe946c0f4@xymon.invalid> wrote:

On Monday 05 March 2007 14:33, Sabeer MZ wrote:

any guess :)

Try

../bin/bbcmd perl bb-mysql.pl


Stef

--


Warm Regards
Sabeer MZ

list Stef Coene · Tue, 6 Mar 2007 09:32:24 +0100 ·

▸ quoted from Sabeer MZ

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote:

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

The hobbit variables are set with the "bbcmd" command.  That's why you have to execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add the line "print $cmd" before this line.  This will print the command that will be executed when you run the script.  Check the command for errors or missing options.


Stef

list Jason Altrincham Jones · Tue, 6 Mar 2007 09:24:25 -0000 ·

One other thing is that I'm mostly half sure that you will want GAUGE
data types not DERIVE since derive assumes the value will always
increase (I can't remember why this is the case) whereas gauge can
increase and decrease.  What changes have you made to hobbitserver.cfg
for this test?

Jason.

▸ quoted from Stef Coene


-----Original Message-----
From: Stef Coene [mailto:user-dbffe946c0f4@xymon.invalid] 
Sent: 06 March 2007 08:32
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote:

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

The hobbit variables are set with the "bbcmd" command.  That's why you
have to 
execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add
the 
line "print $cmd" before this line.  This will print the command that
will be 
executed when you run the script.  Check the command for errors or
missing 
options.


Stef

list Sabeer MZ · Tue, 6 Mar 2007 15:44:06 +0530 ·

Many thanks. I am seeing some light ....:)
No errors when i run it thru bbcmd.

so now to clear mysql.rrd file.

"[hobbit at abc bin]$ ./bbcmd ../ext/bb-mysql.pl
2007-03-06 02:11:58 Using default environment file
/home/hobbit/server/etc/hobbitserver.cfg
/home/hobbit/server/bin/bb x.x.160.x "status abc,abc,com.mysql green Tue
Mar  6 02:11:59 2007 MySQL Server OK

threads: 1
questions: 14036
slow queries: 0
opens: 7
flush tables: 1
open tables: 6
queries per second avg: 0.020
maxcon: 100

Server version: 4.1.20

Uptime: 8 days 48 min 32 sec

Server reports timestamp of 2007-03-06 02:11:59

Thanks
Sabeer MZ

▸ quoted from Stef Coene


On 3/6/07, Stef Coene <user-dbffe946c0f4@xymon.invalid> wrote:

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote:

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

The hobbit variables are set with the "bbcmd" command.  That's why you
have to
execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add
the
line "print $cmd" before this line.  This will print the command that will
be
executed when you run the script.  Check the command for errors or missing
options.


Stef

--


Warm Regards
Sabeer MZ

list Sabeer MZ · Tue, 6 Mar 2007 15:48:50 +0530 ·

I am not getting data on my graphs. How to clear the old mysql.rrd and
create a new one ?

pls find below mysql entries on hobbitserver.cfg and let me know if i have
to add anything.
I am using hobbit *Hobbit Monitor
4.3.0-20061124<http://hobbitmon.sourceforge.net/>;
• [hobbit at abc etc]$ grep mysql hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tcp,
dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendmail,mailq,
nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,files,procs=processes,
ports,clock,lines",mysql=ncv"

GRAPHS="la,mysql,disk,inode,qtree,files,processes,memory,users,vmstat,iostat,
tcp.http,
tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sendmail,mailq,socks,
bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines"

thanks
Sabeer MZ

▸ quoted from Sabeer MZ


On 3/6/07, Jones, Jason (Altrincham) <user-ee957b46acd2@xymon.invalid> wrote:

One other thing is that I'm mostly half sure that you will want GAUGE
data types not DERIVE since derive assumes the value will always
increase (I can't remember why this is the case) whereas gauge can
increase and decrease.  What changes have you made to hobbitserver.cfg
for this test?

Jason.

-----Original Message-----
From: Stef Coene [mailto:user-dbffe946c0f4@xymon.invalid]
Sent: 06 March 2007 08:32
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote:

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

The hobbit variables are set with the "bbcmd" command.  That's why you
have to
execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add
the
line "print $cmd" before this line.  This will print the command that
will be
executed when you run the script.  Check the command for errors or
missing
options.


Stef

-- 
Warm Regards
Sabeer MZ

list Charles Goyard · Tue, 6 Mar 2007 11:35:15 +0100 ·

Sabeer MZ wrote :

TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tcp,
dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendmail,mailq,
nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,files,procs=processes,
ports,clock,lines",mysql=ncv"

                   ^-- remove that quote

and you have to restart the hobbitd_rrd process, too : "killall
hobbitd_rrd" does the trick on most Linux distributions.

Once you did this, just rm the mysql.rrd file (in
data/rrd/<hostname>/mysql.rrd


Regards,

-- 
Charles Goyard - user-98f9625a7a59@xymon.invalid - (+33) 1 45 38 01 31

list Jason Altrincham Jones · Tue, 6 Mar 2007 10:47:41 -0000 ·

"Our test script provides data that goes up and down in value (it is the
number of bytes of memory used for a Linux kernel bufffer), and for that
kind of data we'll use the RRD GAUGE datatype. So we add an extra
setting to hobbitserver.cfg:

 
        NCV_slab="inodecache:GAUGE,dentrycache:GAUGE"
This tells the hobbitd_rrd module that it should create an RRD file with
two datasets of type GAUGE instead of the default (DERIVE). The setting
must be named NCV_<columnname>." - from help > custom graphs
 
If you do this then it should work properly

▸ quoted from Sabeer MZ

Jason.

From: Sabeer MZ [mailto:user-c73a09452f94@xymon.invalid] 
Sent: 06 March 2007 10:19
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

I am not getting data on my graphs. How to clear the old mysql.rrd and
create a new one ?

pls find below mysql entries on hobbitserver.cfg and let me know if i
have to add anything.


I am using hobbit Hobbit Monitor 4.3.0-20061124
<http://hobbitmon.sourceforge.net/>; 

[hobbit at abc etc]$ grep mysql hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tc
p, 
dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendm
ail,mailq,
nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,fil
es,procs=processes,
ports,clock,lines",mysql=ncv" 

GRAPHS="la,mysql,disk,inode,qtree,files,processes,memory,users,vmstat,io
stat,tcp.http,
tcp,ncv,netstat,ifstat,mrtg::1,ports,temperature,ntpstat,apache,bind,sen
dmail,mailq,socks,

▸ quoted from Sabeer MZ

bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines" 

thanks
Sabeer MZ

On 3/6/07, Jones, Jason (Altrincham) <user-ee957b46acd2@xymon.invalid> wrote: 

One other thing is that I'm mostly half sure that you will want GAUGE
data types not DERIVE since derive assumes the value will always 
increase (I can't remember why this is the case) whereas gauge can
increase and decrease.  What changes have you made to hobbitserver.cfg
for this test?

Jason.

-----Original Message-----
From: Stef Coene [mailto: user-dbffe946c0f4@xymon.invalid]
Sent: 06 March 2007 08:32
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql connections

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote:

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

The hobbit variables are set with the "bbcmd" command.  That's why you
have to
execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add 
the
line "print $cmd" before this line.  This will print the command that
will be
executed when you run the script.  Check the command for errors or
missing
options.


Stef


-- 
Warm Regards
Sabeer MZ

list Sabeer MZ · Tue, 6 Mar 2007 22:12:43 +0530 ·

Graphs still not come. i see below errors too ..
any guess :)

2007-03-06 08:34:31 RRD error updating
/home/hobbit/data/rrd/abc.abc.com/mysql.rrd from x.x.x.x: not a simple
integer: '0.020'

Sabeer MZ

▸ quoted from Sabeer MZ


On 3/6/07, Sabeer MZ <user-c73a09452f94@xymon.invalid> wrote:


Many thanks. I am seeing some light ....:)
No errors when i run it thru bbcmd.

so now to clear mysql.rrd file.

"[hobbit at abc bin]$ ./bbcmd ../ext/bb-mysql.pl
2007-03-06 02:11:58 Using default environment file
/home/hobbit/server/etc/hobbitserver.cfg
/home/hobbit/server/bin/bb x.x.160.x "status abc,abc,com.mysql green Tue
Mar  6 02:11:59 2007 MySQL Server OK

threads: 1
questions: 14036
slow queries: 0
opens: 7
flush tables: 1
open tables: 6
queries per second avg: 0.020
maxcon: 100

Server version: 4.1.20

Uptime: 8 days 48 min 32 sec

Server reports timestamp of 2007-03-06 02:11:59

Thanks
Sabeer MZ

On 3/6/07, Stef Coene <user-dbffe946c0f4@xymon.invalid> wrote:

On Tuesday 06 March 2007 06:44, Sabeer MZ wrote:

good suggestion. i got one more clue.-

Use of uninitialized value in concatenation (.) or string at
bb-mysql.plline 119.
  "config bb-mysql.cfg-"sh: config bb-mysql.cfg-: command not found

this is showing that BB/Hobbit variables are not set.
So Where is the soure profile that We need to execute to get these
variables.
or how to set bb/hobbit env varibales.

The hobbit variables are set with the "bbcmd" command.  That's why you
have to
execute "../bin/bbcmd perl bb-mysql.pl".

For the error, on line 119, you will find "system($cmd);".  You can add
the
line "print $cmd" before this line.  This will print the command that
will be
executed when you run the script.  Check the command for errors or
missing
options.


Stef

--
Warm Regards
Sabeer MZ


-- 
Warm Regards
Sabeer MZ

list Stef Coene · Tue, 6 Mar 2007 19:18:35 +0100 ·

▸ quoted from Sabeer MZ

On Tuesday 06 March 2007 17:42, Sabeer MZ wrote:

Graphs still not come. i see below errors too ..
any guess :)

2007-03-06 08:34:31 RRD error updating
/home/hobbit/data/rrd/abc.abc.com/mysql.rrd from x.x.x.x: not a simple
integer: '0.020'

I had the same problem.  RRD wants integers.

I added the line
$metrics =~ s/(\d)+\.(\d)+/$1/g;

just before
$metrics =~ s/(\d)\s+/$1\n/g; # remplace les espaces qui suivent un chiffre 
par des \n

This will filter out the ".0.20" of "0.020" so "0" is reported.


Stef

list Sabeer MZ · Wed, 7 Mar 2007 12:23:13 +0530 ·

that worked.-

Great community Great work.
Thanks a ton to all of you. (stef.coene, Charles , Jason)

▸ quoted from Stef Coene


Sabeer MZ

On 3/6/07, Stef Coene <user-dbffe946c0f4@xymon.invalid> wrote:

On Tuesday 06 March 2007 17:42, Sabeer MZ wrote:

Graphs still not come. i see below errors too ..
any guess :)

2007-03-06 08:34:31 RRD error updating
/home/hobbit/data/rrd/abc.abc.com/mysql.rrd from x.x.x.x: not a simple
integer: '0.020'

I had the same problem.  RRD wants integers.

I added the line
$metrics =~ s/(\d)+\.(\d)+/$1/g;

just before
$metrics =~ s/(\d)\s+/$1\n/g; # remplace les espaces qui suivent un
chiffre
par des \n

This will filter out the ".0.20" of "0.020" so "0" is reported.


Stef

--


Warm Regards
Sabeer MZ

mysql connections 🔗 link

mysql connections