Re: [hobbit] graphs with external script

[Etienne Roulland <eroulland (at) cvf.fr>]

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
> > >
> > > 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
> >
> >
> >