mysql connections

newer
CPU Graphs

older
Solaris ps

sabeer.mz＠gmail.com

1 Mar 2007 1 Mar '07

7:37 a.m.

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

Show replies by date

Dominique.Frise＠unil.ch

1 Mar 1 Mar

8:04 a.m.

New subject: [hobbit] mysql connections

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

sabeer.mz＠gmail.com

2 Mar 2 Mar

10:48 a.m.

New subject: [hobbit] mysql connections

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

sabeer.mz＠gmail.com

5 Mar 5 Mar

10:41 a.m.

New subject: [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

JasonAS_Jones＠mentor.com

10:52 a.m.

New subject: [hobbit] mysql connections

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

sabeer.mz＠gmail.com

11:05 a.m.

New subject: [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.

/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

ralphmitchell＠gmail.com

12:52 p.m.

New subject: [hobbit] mysql connections

On 3/5/07, Sabeer MZ <sabeer.mz at gmail.com> 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

JasonAS_Jones＠mentor.com

4:37 p.m.

New subject: [hobbit] mysql connections

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:

<rrd> <version> 0003 </version> <step> 300 </step>  <lastupdate> 1173112124 </lastupdate>

    &lt;ds>
            &lt;name> runtime &lt;/name>
            &lt;type> GAUGE &lt;/type>

...  <row><v> 1 .0503600000e+01 </v></row>  <row><v> 1 .0325800000e+01 </v></row>  <row><v> 1 .1187333333e+01 </v></row>  <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:ralphmitchell at gmail.com] Sent: 05 March 2007 12:52 To: hobbit at hswn.dk Subject: Re: [hobbit] mysql connections

On 3/5/07, Sabeer MZ <sabeer.mz at gmail.com> 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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

sabeer.mz＠gmail.com

6 Mar 6 Mar

4:30 a.m.

New subject: [hobbit] mysql connections

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 <rrd> <version> 0003 </version> <step> 300 </step>  <lastupdate> 1173155037 </lastupdate>

    &lt;ds>
            &lt;name> threads &lt;/name>
            &lt;type> DERIVE &lt;/type>
            &lt;minimal_heartbeat> 600 &lt;/minimal_heartbeat>
            &lt;min> NaN &lt;/min>
            &lt;max> NaN &lt;/max>

            &lt;!-- PDP Status -->
            &lt;last_ds> 42 &lt;/last_ds>
            &lt;value> NaN &lt;/value>
            &lt;unknown_sec> 237 &lt;/unknown_sec>
    &lt;/ds>

    &lt;ds>
            &lt;name> questions &lt;/name>
            &lt;type> DERIVE &lt;/type>
            &lt;minimal_heartbeat> 600 &lt;/minimal_heartbeat>
            &lt;min> NaN &lt;/min>
            &lt;max> NaN &lt;/max>

            &lt;!-- PDP Status -->
            &lt;last_ds> 207587169 &lt;/last_ds>
            &lt;value> NaN &lt;/value>
            &lt;unknown_sec> 237 &lt;/unknown_sec>
    &lt;/ds>

    &lt;ds>
            &lt;name> slowqueries &lt;/name>
            &lt;type> DERIVE &lt;/type>
            &lt;minimal_heartbeat> 600 &lt;/minimal_heartbeat>
            &lt;min> NaN &lt;/min>
            &lt;max> NaN &lt;/max>

            &lt;!-- PDP Status -->
            &lt;last_ds> 10 &lt;/last_ds>
            &lt;value> NaN &lt;/value>
            &lt;unknown_sec> 237 &lt;/unknown_sec>

Regards Sabeer MZ

On 3/5/07, Jones, Jason (Altrincham) <JasonAS_Jones at mentor.com> 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:

 <rrd> <version> 0003 </version> <step> 300 </step>  <lastupdate> 1173112124 </lastupdate> 
    &lt;ds>
            &lt;name> runtime &lt;/name>
            &lt;type> GAUGE &lt;/type>
...  <row><v> 1 .0503600000e+01 </v></row>  <row><v> 1 .0325800000e+01 </v></row>  <row><v> 1 .1187333333e+01 </v></row>  <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:ralphmitchell at gmail.com] Sent: 05 March 2007 12:52 To: hobbit at hswn.dk Subject: Re: [hobbit] mysql connections

On 3/5/07, Sabeer MZ <sabeer.mz at gmail.com> 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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

cgoyard＠cvf.fr

5 Mar 5 Mar

11:09 a.m.

New subject: [hobbit] mysql connections

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

sabeer.mz＠gmail.com

11:16 a.m.

New subject: [hobbit] mysql connections

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 string at bb-mysql.plline 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

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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

sabeer.mz＠gmail.com

1:33 p.m.

New subject: [hobbit] mysql connections

any guess :)

On 3/5/07, Sabeer MZ <sabeer.mz at gmail.com> 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 string at bb-mysql.plline 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

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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

-- Warm Regards Sabeer MZ

JasonAS_Jones＠mentor.com

2:15 p.m.

New subject: [hobbit] mysql connections

It's just a warning I think:

[hobbit at abc2 ext]$ perl bb-mysql.pl Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 52.

...

you use an unitialised variable on line 52

Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 118. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl 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 string at bb-mysql.pl line 131. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 131. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl 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?

Jason.

From: Sabeer MZ [mailto:sabeer.mz at gmail.com] Sent: 05 March 2007 13:34 To: hobbit at hswn.dk Subject: Re: [hobbit] mysql connections

any guess :)

On 3/5/07, Sabeer MZ <sabeer.mz at gmail.com> 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 string at bb-mysql.pl line 52. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 118. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 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.pl line 131. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 131. Use of uninitialized value in concatenation (.) or string at bb-mysql.pl line 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 < cgoyard at cvf.fr <mailto:cgoyard at cvf.fr> > 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 - cgoyard at cvf.fr - (+33) 1 45 38 01 31

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

stef.coene＠docum.org

2:26 p.m.

New subject: [hobbit] mysql connections

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

...

any guess :) Try

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

Stef

sabeer.mz＠gmail.com

6 Mar 6 Mar

5:44 a.m.

New subject: [hobbit] mysql connections

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

On 3/5/07, Stef Coene <stef.coene at docum.org> wrote:

...

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

...
any guess :) Try

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

Stef

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

stef.coene＠docum.org

8:32 a.m.

New subject: [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

JasonAS_Jones＠mentor.com

9:24 a.m.

New subject: [hobbit] mysql connections

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:stef.coene at docum.org] Sent: 06 March 2007 08:32 To: hobbit at hswn.dk 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".

Stef

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

sabeer.mz＠gmail.com

10:18 a.m.

New subject: [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=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

On 3/6/07, Jones, Jason (Altrincham) <JasonAS_Jones at mentor.com> 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:stef.coene at docum.org] Sent: 06 March 2007 08:32 To: hobbit at hswn.dk 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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

cgoyard＠cvf.fr

10:35 a.m.

New subject: [hobbit] mysql connections

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

JasonAS_Jones＠mentor.com

10:47 a.m.

New subject: [hobbit] mysql connections

"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 Jason.

From: Sabeer MZ [mailto:sabeer.mz at gmail.com] Sent: 06 March 2007 10:19 To: hobbit at hswn.dk 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, bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,clock,lines"

thanks Sabeer MZ

On 3/6/07, Jones, Jason (Altrincham) <JasonAS_Jones at mentor.com> wrote:

Jason.

-----Original Message----- From: Stef Coene [mailto: stef.coene at docum.org] Sent: 06 March 2007 08:32 To: hobbit at hswn.dk 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".

Stef

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

sabeer.mz＠gmail.com

10:14 a.m.

New subject: [hobbit] mysql connections

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 <stef.coene at docum.org> 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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

sabeer.mz＠gmail.com

4:42 p.m.

New subject: [hobbit] mysql connections

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

On 3/6/07, Sabeer MZ <sabeer.mz at gmail.com> 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 <stef.coene at docum.org> 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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

-- Warm Regards Sabeer MZ

stef.coene＠docum.org

6:18 p.m.

New subject: [hobbit] mysql connections

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

sabeer.mz＠gmail.com

7 Mar 7 Mar

6:53 a.m.

New subject: [hobbit] mysql connections

that worked.-

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

Sabeer MZ

On 3/6/07, Stef Coene <stef.coene at docum.org> 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

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk

-- Warm Regards Sabeer MZ

7049

Age (days ago)

7055

Last active (days ago)

List overview

Download

23 comments

6 participants

participants (6)

cgoyard＠cvf.fr
Dominique.Frise＠unil.ch
JasonAS_Jones＠mentor.com
ralphmitchell＠gmail.com
sabeer.mz＠gmail.com
stef.coene＠docum.org