graphs with external script

Etienne Roulland Etienne.Roulland at cvf.fr
Mon Jul 25 11:28:49 CEST 2005


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




More information about the Xymon mailing list