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>