graphs with external script

Hi Etienne,

Did you put the name of your trends in the different configuration files ?

You should have add information in : 

the rrd part in hobbitgraph.cfg
the rrdstatus in hobbitlaunch.cfg
the TEST2RRD and GRAPHS in hobbitserver.cfg

We have created different types of trends and it works well.
We only customize he extra-rrd.sh to an perl script extra-rrd.pl from the 
existing hobbit distribution.


2005/8/25, Etienne Roulland <user-318b6b240fb9@xymon.invalid>:

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 <http://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

-- 
Etienne GRIGNON