Re: [hobbit] graphs with external script

[Etienne Grignon <etienne.grignon (at) gmail.com>]

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