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
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
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 # 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
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 <Etienne.Roulland at cvf.fr>:
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 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- Etienne GRIGNON
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
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 <Etienne.Roulland at cvf.fr>:
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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- 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
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...
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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
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
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&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&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
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
-- Etienne Roulland -- CVF Bordeaux
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&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&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
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
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&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&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
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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- Etienne Roulland -- CVF Bordeaux
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,
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&service=mysqlslow&graph_width=576&graph_height=120&first=1&count=1&disp=%2dtest-sql%2efr&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
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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- Etienne Roulland -- CVF Bordeaux
In <1126001260.31317.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> 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
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 <henrik at hswn.dk> wrote:In <1126001260.31317.57.camel at localhost.localdomain> Etienne Roulland < Etienne.Roulland at cvf.fr> 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
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 :
[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..
On Wed, 2005-09-21 at 13:58 +0000, Henrik Storner wrote:
In <1126001260.31317.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
-- Etienne Roulland -- CVF Bordeaux
In <1128009355.7465.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> 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
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
Henrik Storner wrote:
In <1128009355.7465.57.camel at localhost.localdomain> Etienne Roulland <Etienne.Roulland at cvf.fr> 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
participants (7)
-
eroulland@cvf.fr
-
etienne.grignon@gmail.com
-
Etienne.Roulland@cvf.fr
-
henrik@hswn.dk
-
liu-zm@neusoft.com
-
olivier@qalpit.com
-
rower.master@gmail.com