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>