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