graphs with external script

22 messages in this thread

list Etienne Roulland · Mon, 25 Jul 2005 11:28:49 +0200 ·

Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd
which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts :
x.x.x.x  box1.cvf.fr       # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-07-25 11:25:56 RRD update param 04:
'1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

-- 
Etienne Roulland -- CVF Bordeaux

list Etienne Roulland · Tue, 16 Aug 2005 16:23:14 +0200 ·

Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day
(16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"
and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

▸ quoted from Etienne Roulland

Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd
which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts :
x.x.x.x  box1.cvf.fr       # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-07-25 11:25:56 RRD update param 04:
'1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

-- 
Etienne Roulland -- CVF Bordeaux

list Etienne Roulland · Wed, 17 Aug 2005 15:49:13 +0200 ·

Hi,

i have also add mysql in the GRAPHS section...

Now i have a "hobbit graph mysql" but nothing more...

In the man i  don't see GRAPHS tag but a TRENDS one anyway it doesn't
seem to be recognized...

I don't see where i made a mistake in my setting.

Regards.

▸ quoted from Etienne Roulland

Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day
(16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"
and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

Hi,

i'm trying to get graphes from mysql-status BB side client.
I followed the man page and a post from Henrik. Now i have mysql.rrd
which is updated but i cannot get graphs.
I use Hobbit 4.1.0.
I have in by bb-hosts :

x.x.x.x  box1.cvf.fr       # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And
[mysqlslow]

        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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

in hobbitgraph.cfg...
In larrd-status i can see in debug log :
2005-07-25 11:25:56 RRD update param 03:

'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-07-25 11:25:56 RRD update param 04:
'1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?
Regards,

-- 
Etienne Roulland -- CVF Bordeaux

list Etienne Roulland · Thu, 25 Aug 2005 12:38:21 +0200 ·

Hi,

i'm sorry to insist.

Is anybody could show me the right way to graphs result from mysql
test ?

My RRD files are updated, i have sql section in trends columns but no
graphes..

Rgds,

Etienne

▸ quoted from Etienne Roulland

Hi,

i have also add mysql in the GRAPHS section...

Now i have a "hobbit graph mysql" but nothing more...

In the man i  don't see GRAPHS tag but a TRENDS one anyway it doesn't
seem to be recognized...

I don't see where i made a mistake in my setting.

Regards.

Hi,

i'm back from holidays ;-).
i'm still trying to graph mysql status with the snapshot of the day

(16th august)

i've added
GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.
NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"
and mysql=ncv" in my hobbitserver.cfg.
I see mysql.rrd files but still no graphs...
I'm pretty sure that i have a mistake just in front of my eyes but...
Anybody has an idea ?
Thanks.
Etienne

Hi,

i'm trying to get graphes from mysql-status BB side client.
I followed the man page and a post from Henrik. Now i have mysql.rrd
which is updated but i cannot get graphs.
I use Hobbit 4.1.0.
I have in by bb-hosts :

x.x.x.x  box1.cvf.fr       # noping GRAPHS:*,mysql:mysqlslow,mysqlthread

And
[mysqlslow]

        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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

in hobbitgraph.cfg...
In larrd-status i can see in debug log :
2005-07-25 11:25:56 RRD update param 03:

'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-07-25 11:25:56 RRD update param 04:
'1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?
Regards,

-- 
Etienne Roulland -- CVF Bordeaux

list Etienne Grignon · Fri, 26 Aug 2005 09:40:58 +0200 ·

Hi Etienne,

Did you put the name of your trends in the different configuration files ?

You should have add information in : 

the rrd part in hobbitgraph.cfg
the rrdstatus in hobbitlaunch.cfg
the TEST2RRD and GRAPHS in hobbitserver.cfg

We have created different types of trends and it works well.
We only customize he extra-rrd.sh to an perl script extra-rrd.pl from the 
existing hobbit distribution.


2005/8/25, Etienne Roulland <user-318b6b240fb9@xymon.invalid>:

▸ quoted from Etienne Roulland

Hi,

i'm sorry to insist.

Is anybody could show me the right way to graphs result from mysql
test ?

My RRD files are updated, i have sql section in trends columns but no
graphes..

Rgds,

Etienne

Hi,

i have also add mysql in the GRAPHS section...

Now i have a "hobbit graph mysql" but nothing more...

In the man i don't see GRAPHS tag but a TRENDS one anyway it doesn't
seem to be recognized...

I don't see where i made a mistake in my setting.

Regards.

Hi,

i'm back from holidays ;-).

i'm still trying to graph mysql status with the snapshot of the day
(16th august)

i've added

GRAPHS:*,mysql:mysqlslow,mysqlthread in my bb-hosts.

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"
and mysql=ncv" in my hobbitserver.cfg.

I see mysql.rrd files but still no graphs...

I'm pretty sure that i have a mistake just in front of my eyes but...

Anybody has an idea ?

Thanks.

Etienne

Hi,

i'm trying to get graphes from mysql-status BB side client.

I followed the man page and a post from Henrik. Now i have mysql.rrd
which is updated but i cannot get graphs.

I use Hobbit 4.1.0.

I have in by bb-hosts :


x.x.x.x box1.cvf.fr <http://box1.cvf.fr>; # noping

▸ quoted from Etienne Roulland

GRAPHS:*,mysql:mysqlslow,mysqlthread

And

[mysqlslow]
DEF:slow=mysql.rrd:Slowqueries:AVERAGE
TITLE MySQL Slow Queries
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
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

in hobbitgraph.cfg...

In larrd-status i can see in debug log :

2005-07-25 11:25:56 RRD update param 03:

'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'

2005-07-25 11:25:56 RRD update param 04:
'1122283556:180:205393153:556:26208:3:512:92.123'

Where did i make a mistake ?

Regards,

--
Etienne Roulland -- CVF Bordeaux

--


Etienne GRIGNON

list Etienne Roulland · Fri, 26 Aug 2005 15:38:19 +0200 ·

Hi Etienne,

▸ quoted from Etienne Grignon

Hi Etienne ;)

Did you put the name of your trends in the different configuration
files ?

You should have add information in : 

the rrd part in hobbitgraph.cfg


[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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

the rrdstatus in hobbitlaunch.cfg

[rrdstatus]
        ENVFILE /usr2/hobbit/server/etc/hobbitserver.cfg
        NEEDS hobbitd
        CMD hobbitd_channel --channel=status --log=
$BBSERVERLOGS/rrd-status.log hobbitd_rrd --rrddir=$BBVAR/rrd --debug

My RRD files seem to be correctly updated:

2005-08-26 15:31:55 RRD update param 00: 'rrdupdate'
2005-08-26 15:31:55 RRD update param 01:
'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
2005-08-26 15:31:55 RRD update param 02: '-t'
2005-08-26 15:31:55 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-08-26 15:31:55 RRD update param 04:
'1125063115:211:359216582:801:30426:3:511:71.713'

the TEST2RRD and GRAPHS in hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv,
$PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperat....

GRAPHS="la,mysql,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,apache,bind,sendmail....

But no graphes ...

Etienne

list Olivier Beau · Fri, 26 Aug 2005 17:25:14 +0200 ·

Hi,


Are the mysql rrd file in the hobbit/data/rrd/ filesystem ?
are they updated ?


are the "mysqlslow" and "mysqlthread" present in your $GRAPHS variable ?


Regards,

Olivier


Selon Etienne Roulland <user-318b6b240fb9@xymon.invalid>:

▸ quoted from Etienne Roulland

Hi Etienne,

Hi Etienne ;)

Did you put the name of your trends in the different configuration
files ?

You should have add information in : > > the rrd part in hobbitgraph.cfg


[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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

the rrdstatus in hobbitlaunch.cfg

[rrdstatus]
        ENVFILE /usr2/hobbit/server/etc/hobbitserver.cfg
        NEEDS hobbitd
        CMD hobbitd_channel --channel=status --log=
$BBSERVERLOGS/rrd-status.log hobbitd_rrd --rrddir=$BBVAR/rrd --debug

My RRD files seem to be correctly updated:

2005-08-26 15:31:55 RRD update param 00: 'rrdupdate'
2005-08-26 15:31:55 RRD update param 01:
'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
2005-08-26 15:31:55 RRD update param 02: '-t'
2005-08-26 15:31:55 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-08-26 15:31:55 RRD update param 04:
'1125063115:211:359216582:801:30426:3:511:71.713'

the TEST2RRD and GRAPHS in hobbitserver.cfg

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv,

$PINGCOLUMN=tcp,http=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperat....

GRAPHS="la,mysql,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,apache,bind,sendmail....

But no graphes ...

Etienne

--


Olivier Beau

list Etienne Roulland · Fri, 26 Aug 2005 17:57:49 +0200 ·

▸ quoted from Olivier Beau

Hi,

Are the mysql rrd file in the hobbit/data/rrd/ filesystem ?
are they updated ?

Yep.

are the "mysqlslow" and "mysqlthread" present in your $GRAPHS variable ?

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread


and

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]


Etienne

list Olivier Beau · Fri, 26 Aug 2005 18:35:30 +0200 ·

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line


Olivier

list Etienne Roulland · Fri, 26 Aug 2005 19:46:43 +0200 ·

▸ quoted from Olivier Beau

Olivier Beau wrote:

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

TRENDS in man but doesn't seems to be regognized by hobbit, i found an 
Henrik's post which said GRAPHS. Any way i tried both without success.
When i look into the info status of hoobit i see
"Other tags:GRAPHS:*,mysql:mysqlslow,mysqlthread" with GRAPHS tag and 
nothing with TRENDS....

a,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line

Not better...

list Etienne Roulland · Fri, 26 Aug 2005 19:50:13 +0200 ·

Oupps last mail was sent a little bit  quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

▸ quoted from Etienne Roulland

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line


Olivier

list 刘正明 · Mon, 29 Aug 2005 11:52:54 +0800 ·

the /var/log/larrd-status.log :
2005-08-29 11:46:25 RRD error updating /home/monitor/data/rrd/proxy.neusoft.com/concurrent.rrd from 192.168.20.87:
illegal attempt to update using time 1125287185 when last update time is
1125287185 (minimum one second step)
what is it?
thank you

list Etienne Roulland · Mon, 29 Aug 2005 11:37:39 +0200 ·

Hi,

i've checked ont more time my setting and still see where i made a
mistake...

I use this night snapshot, my rrd files  are updated as i can see :


2005-08-29 11:11:36 RRD update param 00: 'rrdupdate'
2005-08-29 11:11:36 RRD update param 01:
'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
2005-08-29 11:11:36 RRD update param 02: '-t'
2005-08-29 11:11:36 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-08-29 11:11:36 RRD update param 04:
'1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have

▸ quoted from Olivier Beau


[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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


In my bb-hosts:

10.1.1.8  sql-test.cvf       # noping
TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&amp;service=mysqlslow&amp;graph_width=576&amp;graph_height=120&amp;first=1&amp;count=1&amp;disp=%2dtest-sql%2efr&amp;action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne

▸ quoted from Etienne Roulland



On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

Oupps last mail was sent a little bit  quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line


Olivier

--


Etienne Roulland -- CVF Bordeaux

list Etienne Roulland · Fri, 02 Sep 2005 23:15:30 +0200 ·

Hi,

sorry for boring everybody with my problem..

But i made all check that  i can and i 'm still not able to get graphs...

I can get my rrd file up to date with NCV module but _no_ graphs ..


Etienne

▸ quoted from Etienne Roulland

Hi,

i've checked ont more time my setting and still see where i made a
mistake...

I use this night snapshot, my rrd files  are updated as i can see :


2005-08-29 11:11:36 RRD update param 00: 'rrdupdate'
2005-08-29 11:11:36 RRD update param 01:
'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
2005-08-29 11:11:36 RRD update param 02: '-t'
2005-08-29 11:11:36 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-08-29 11:11:36 RRD update param 04:
'1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have 

[mysqlslow]
       DEF:slow=mysql.rrd:Slowqueries:AVERAGE
       TITLE MySQL Slow Queries
       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
       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


In my bb-hosts:

10.1.1.8  sql-test.cvf       # noping
TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&amp;service=mysqlslow&amp;graph_width=576&amp;graph_height=120&amp;first=1&amp;count=1&amp;disp=%2dtest-sql%2efr&amp;action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne


On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

Oupps last mail was sent a little bit  quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line


Olivier

list Etienne Roulland · Tue, 06 Sep 2005 11:28:08 +0200 ·

Hi ..

I'm using 2 versions of hobbit today (09/06) snapshot and 4.1.1.

Is anybody could just answer me what can be wrong in my setting ? I have
my rrd files updated, got "mysql" section on trends columns.. All seems
ok there.


hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=disk&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> show me disk trends

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> "Unknown graph requested"

(I have [mysqlslow] & [mysqlthread] in my hobbitgraph.cfg)


Please... I have checked many many many times all my config and still
not see where i could make a mistake. 

Maybe a bug ?

Heeeeelp

rgds,

Etienne

▸ quoted from Etienne Roulland

Hi,

sorry for boring everybody with my problem..

But i made all check that  i can and i 'm still not able to get graphs...

I can get my rrd file up to date with NCV module but _no_ graphs ..


Etienne

Hi,

i've checked ont more time my setting and still see where i made a
mistake...

I use this night snapshot, my rrd files  are updated as i can see :


2005-08-29 11:11:36 RRD update param 00: 'rrdupdate'
2005-08-29 11:11:36 RRD update param 01:
'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
2005-08-29 11:11:36 RRD update param 02: '-t'
2005-08-29 11:11:36 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-08-29 11:11:36 RRD update param 04:
'1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have 

[mysqlslow]
       DEF:slow=mysql.rrd:Slowqueries:AVERAGE
       TITLE MySQL Slow Queries
       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
       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


In my bb-hosts:

10.1.1.8  sql-test.cvf       # noping
TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&amp;service=mysqlslow&amp;graph_width=576&amp;graph_height=120&amp;first=1&amp;count=1&amp;disp=%2dtest-sql%2efr&amp;action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne


On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

Oupps last mail was sent a little bit  quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line


Olivier

-- 
Etienne Roulland -- CVF Bordeaux

list Etienne Roulland · Tue, 06 Sep 2005 12:07:40 +0200 ·

Re hi,

with the help of Nicolas Figaro (many thanks to him)

with the real hostname (got the stupid idea of trying to mask real
ones....) i got a segmentation fault...

QUERY_STRING="host=sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh 
Segmentation fault

Regards,

▸ quoted from Etienne Roulland



On Tue, 2005-09-06 at 11:28 +0200, Etienne Roulland wrote:

Hi ..

I'm using 2 versions of hobbit today (09/06) snapshot and 4.1.1.

Is anybody could just answer me what can be wrong in my setting ? I have
my rrd files updated, got "mysql" section on trends columns.. All seems
ok there.


hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=disk&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> show me disk trends

hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2test-sql%2ecvf&graph=hourly&action=view

==> "Unknown graph requested"

(I have [mysqlslow] & [mysqlthread] in my hobbitgraph.cfg)


Please... I have checked many many many times all my config and still
not see where i could make a mistake. 

Maybe a bug ?

Heeeeelp

rgds,

Etienne

Hi,

sorry for boring everybody with my problem..

But i made all check that  i can and i 'm still not able to get graphs...

I can get my rrd file up to date with NCV module but _no_ graphs ..


Etienne

Hi,

i've checked ont more time my setting and still see where i made a
mistake...

I use this night snapshot, my rrd files  are updated as i can see :


2005-08-29 11:11:36 RRD update param 00: 'rrdupdate'
2005-08-29 11:11:36 RRD update param 01:
'/usr2/hobbit/data/rrd/sql-test.cvf/mysql.rrd'
2005-08-29 11:11:36 RRD update param 02: '-t'
2005-08-29 11:11:36 RRD update param 03:
'Threads:Questions:Slowqueries:Opens:Flushtables:Opentables:Queriespersecondavg'
2005-08-29 11:11:36 RRD update param 04:
'1125306696:177:370689709:824:30520:3:512:70.571'

I think it's all right to this point.

As i can see in man page or on this ML i've add :

to catch result from client test:

TEST2RRD="cpu=la,disk,inode,qtree,memory,mysql=ncv...."

NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE,Slowqueries:GAUGE"

and to have graphs on the trends column :

GRAPHS="mysql,la,disk...

In hobbitgraph.cfg

i have 

[mysqlslow]
       DEF:slow=mysql.rrd:Slowqueries:AVERAGE
       TITLE MySQL Slow Queries
       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
       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


In my bb-hosts:

10.1.1.8  sql-test.cvf       # noping
TRENDS:*,mysql:mysqlslow,mysqlthread

No SQL graphs on the page ...

a "hobbit graphs mysqlslow"

HREF="/hobbit-cgi/hobbitgraph.sh?host=test-sql.cvf&amp;service=mysqlslow&amp;graph_width=576&amp;graph_height=120&amp;first=1&amp;count=1&amp;disp=%2dtest-sql%2efr&amp;action=menu"><IMG

I think i should have "service=mysql" and not "service=mysqlslow" ?

Am i so wrong ?

Rgds,

Etienne


On Fri, 2005-08-26 at 19:50 +0200, Etienne Roulland wrote:

Oupps last mail was sent a little bit  quickly.

The Henrik post on GRAPHS

http://www.hswn.dk/hobbiton/2005/06/msg00268.html

Regards,

Etienne

Options in bb-hosts for this box

# noping GRAPHS:*,mysql:mysqlslow,mysqlthread

i don't think GRPAHS works in bb-hosts, it's named TRENDS in the man

in hobbitserver.cfg

GRAPHS="la,mysql,disk,inode,qtree,memory,users,.......[...]

add mysqlslow,mysqlthread in this line


Olivier

-- 
Etienne Roulland -- CVF Bordeaux

list Henrik Størner · Wed, 21 Sep 2005 13:58:31 +0000 (UTC) ·

In <user-a65371cc52e9@xymon.invalid> Etienne Roulland <user-318b6b240fb9@xymon.invalid> writes:

QUERY_STRING="host=sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh 
Segmentation fault

When testing CGI scripts such as hobbitgraph.cgi, you must
provide all of the environment variables that the webserver
normally sets up for you.

Specifically, hobbitgraph expects the REQUEST_URI environment
variable to be set. So:

QUERY_STRING="host=...."
export QUERY_STRING
REQUEST_URI="http://localhost/cgi-bin/hobbitgraph.sh?${QUERY_STRING}";
export REQUEST_URI
./hobbitgraph.sh


Henrik

list Mario Andre · Fri, 23 Sep 2005 15:20:55 -0300 ·

Henrik,
 I'm already generating a graph for my ext clientside script in the trends
column, but I would like to show the first graph(last 48 hours) in the
service column page.
 I've put this line into the ext script
GRAP="<A HREF=/hobbit-cgi/hobbitgraph.sh
host=express&service=synclog&disp=express&action=menu><IMG BORDER=0
SRC=/hobbit-cgi/hobbitgraph.sh?host=express&service=synclog&disp=express&graph=hourly&action=view

</a>"
and

 $BB $BBDISP "status $MACHINE.$TEST $COLOR `$DATE` - $STATUS - $STATUS1 $L2
$GRAP"
 This show the graph but starts some erros of DS in the larrd-status.log
  Any hint or a easy and clean way?
 Thanks in advance my friend,
 Mario.
 On 9/21/05, Henrik Storner <user-ce4a2c883f75@xymon.invalid> wrote:

In <user-a65371cc52e9@xymon.invalid> Etienne Roulland <
user-318b6b240fb9@xymon.invalid> writes:

QUERY_STRING="host=
sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view"

▸ quoted from Henrik Størner

./hobbitgraph.sh

Segmentation fault

When testing CGI scripts such as hobbitgraph.cgi, you must
provide all of the environment variables that the webserver
normally sets up for you.

Specifically, hobbitgraph expects the REQUEST_URI environment
variable to be set. So:

QUERY_STRING="host=...."
export QUERY_STRING
REQUEST_URI="http://localhost/cgi-bin/hobbitgraph.sh?${QUERY_STRING}";
export REQUEST_URI
./hobbitgraph.sh


Henrik

list Etienne Roulland · Thu, 29 Sep 2005 17:55:55 +0200 ·

Thanks Henrik,


2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph
ncv, but no graph-definition

I've add 
[mysql]
        DEF:questions=mysql.rrd:Questions:AVERAGE
        TITLE MySQL Request
        AREA:questions#00CCCC:Questions
        COMMENT:\n
        GPRINT:questions:LAST: \: %5.1lf (cur)
        GPRINT:questions:MAX: \: %5.1lf (max)
        GPRINT:questions:MIN: \: %5.1lf (min)
        GPRINT:questions:AVERAGE: \: %5.1lf (avg)\n

after the :

▸ quoted from Etienne Roulland


[mysqlslow]
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        TITLE MySQL Slow Queries
        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
        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


Nothing changed..

▸ quoted from Mario Andre



On Wed, 2005-09-21 at 13:58 +0000, Henrik Storner wrote:

In <user-a65371cc52e9@xymon.invalid> Etienne Roulland <user-318b6b240fb9@xymon.invalid> writes:

QUERY_STRING="host=sms-sql02b.sms33.cvf&service=mysql&graph_width=576&graph_height=120&first=1&count=1&disp=sms%2dsql02b%2esms33%2ecvf&graph=hourly&action=view" ./hobbitgraph.sh 
Segmentation fault

When testing CGI scripts such as hobbitgraph.cgi, you must
provide all of the environment variables that the webserver
normally sets up for you.

Specifically, hobbitgraph expects the REQUEST_URI environment
variable to be set. So:

QUERY_STRING="host=...."
export QUERY_STRING
REQUEST_URI="http://localhost/cgi-bin/hobbitgraph.sh?${QUERY_STRING}";
export REQUEST_URI
./hobbitgraph.sh


Henrik

--


Etienne Roulland -- CVF Bordeaux

list Henrik Størner · Thu, 29 Sep 2005 20:13:31 +0000 (UTC) ·

▸ quoted from Etienne Roulland

In <user-a6146bb9413e@xymon.invalid> Etienne Roulland <user-318b6b240fb9@xymon.invalid> writes:

2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph
ncv, but no graph-definition

I've add 
[mysql]

Add ",mysql" to the GRAPHS setting in hobbitserver.cfg.


Henrik

list Etienne Roulland · Thu, 29 Sep 2005 22:20:32 +0200 ·

This is my GRAPHS line:

GRAPHS="la,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,temperature,ntpstat,appache,bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,mysql"

I already have the mysql entry..

Etienne

▸ quoted from Henrik Størner


Henrik Storner wrote:

In <user-a6146bb9413e@xymon.invalid> Etienne Roulland <user-318b6b240fb9@xymon.invalid> writes:

2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph
ncv, but no graph-definition

I've add 
[mysql]

Add ",mysql" to the GRAPHS setting in hobbitserver.cfg.


Henrik

list Etienne Roulland · Fri, 21 Oct 2005 12:18:24 +0200 ·

Hello,


i've found some strange things...

Starting program: /usr2/hobbit/server/bin/hobbitgraph.cgi
--env=/usr2/hobbit/server/etc/hobbitserver.cfg
Content-type: image/png
Expires: Fri, 21 Oct 2005 09:40:25 GMT


Program received signal SIGSEGV, Segmentation fault.
0xb7e6b410 in strncpy () from /lib/tls/i686/cmov/libc.so.6
(gdb) bt
#0  0xb7e6b410 in strncpy () from /lib/tls/i686/cmov/libc.so.6
#1  0xb7f77480 in rrd_graph_options (argc=19, argv=0x8064af0,
im=0xbf8defb8) at rrd_graph.c:3044
#2  0xb7f77ada in rrd_graph (argc=19, argv=0x8064af0, prdata=0xbf8e4184,
xsize=0xbf8e0814, ysize=0xbf8e0814, stream=0xbf8e0814, ymin=0xbf8e0814,
ymax=0xbf8e4158) at rrd_graph.c:2724
#3  0x0804b515 in main (argc=2, argv=0xbf8e4224) at hobbitgraph.c:947


==> in the graph definition  was missing the RRD -v switch aka "YAXIS".

I've add it and graphs showed up.

But if i don't add a 

[mysql]  section i get a no graph definition.

(I already have mysqlslow & mysqlthread).

Etienne

▸ quoted from Etienne Roulland



On jeu, 2005-09-29 at 20:13 +0000, Henrik Storner wrote:

In <user-a6146bb9413e@xymon.invalid> Etienne Roulland <user-318b6b240fb9@xymon.invalid> writes:

2005-09-21 16:30:57 hobbitsvc Setup error: Service mysql has a graph
ncv, but no graph-definition

I've add 
[mysql]

Add ",mysql" to the GRAPHS setting in hobbitserver.cfg.


Henrik

--


Etienne Roulland -- CVF Bordeaux

graphs with external script 🔗 link

graphs with external script