Re: [hobbit] graphs with external script

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