Re: [hobbit] graphs with external script

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

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
> 
> 
-- 
Etienne Roulland -- CVF Bordeaux