[hobbit] MySQL graphing woes

[Charles Jones]

Okay, I've almost got it all working the way I want :)
I fixed the missing graph displayed at the bottom of the "mysql" status 
column by adding a [mysql] graph to hobbitgraph.cfg. I just copied and 
pasted the entry for [mysqlthread].

So now I have working graphs at the bottom of the status page, as well 
as mysqlthread and mysqlslow graphs in the Trends column, but ONLY by 
modding my bb-hosts like so:

1.2.3.4   hostname.mydomain.com        # ssh 
TRENDS:*,mysql:mysqlslow|mysqlthread

Is there something I can put in the hobbitserver.cfg GRAPHS section so 
that these graphs are done by default, and thus not have to override 
TRENDS in bb-hosts ? I tried adding things like 
",mysql:mysqlslow|mysqlthread" but that only seemed to add the one 
default mysql graph.

-Charles

Charles Jones wrote:
> Charles,
>
> Heh, I had noticed that, but I thought to myself, "surely it isnt case 
> sensitive" :)
> I modified hobbitgraph.cfg and lowercased the DS names and that made 
> the graphs appear in trends!
>
> Now I just need to figure out why I'm not getting a graph at the 
> bottom of the page of the "mysql" status page (I still have a broken 
> graph link that says "hobbit graph ncv:mysql").
>
> Thanks,
> -Charles
>
> Charles Goyard wrote:
>> Hi,
>>
>> your shoes don't match :)
>>
>> The name in DEF:... should match the <name> section, case-sensitively.
>>
>> Charles Jones wrote :
>>   
>>> I'm setting up mysql checks and graphing using the hobbit-modified 
>>> bb-mysql.pl. I have the statuses working fine:
>>>
>>> [mysqlslow]
>>>        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
>>>
>>> [mysqlthread]
>>>        DEF:threads=mysql.rrd:Threads:AVERAGE
>>>
>>> /$ rrdtool dump mysql.rrd |egrep 'name|value' | head -20/
>>>                <name> threads </name>
>>>                <name> slowqueries </name>
>>>     
>>
>>
>>   
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20070420/70dc66a8/attachment.html>