<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Okay, I've almost got it all working the way I want :)<br>
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].<br>
<br>
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:<br>
<br>
<tt>1.2.3.4 hostname.mydomain.com # ssh
TRENDS:*,mysql:mysqlslow|mysqlthread</tt><br>
<br>
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.<br>
<br>
-Charles<br>
<br>
Charles Jones wrote:
<blockquote cite="mid461FF736.6020202@cisco.com" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Charles,<br>
<br>
Heh, I had noticed that, but I thought to myself, "surely it isnt case
sensitive" :)<br>
I modified hobbitgraph.cfg and lowercased the DS names and that made
the graphs appear in trends!<br>
<br>
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").<br>
<br>
Thanks,<br>
-Charles<br>
<br>
Charles Goyard wrote:
<blockquote cite="mid20070413101431.GV3914@cgoyard1.exp75.cvf"
type="cite">
<pre wrap="">Hi,
your shoes don't match :)
The name in DEF:... should match the <name> section, case-sensitively.
Charles Jones wrote :
</pre>
<blockquote type="cite">
<pre wrap="">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>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>