[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [hobbit] graphs with external script



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