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

Re: [hobbit] graphs with external script



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