[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [hobbit] graphs with external script
- To: hobbit (at) hswn.dk
- Subject: Re: [hobbit] graphs with external script
- From: Etienne Roulland <Etienne.Roulland (at) cvf.fr>
- Date: Tue, 16 Aug 2005 16:23:14 +0200
- References: <1122283729.2488.86.camel@localhost>
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