NCV data collector, ok, what am I doing wrong? 🔗 link

Hi:

I'm trying to get the graph for mysql usage to work.  I've been reading through the archives and I've been trying different combinations of parameters, without too much luck.

Le's start with what it works.  It's getting the data from the client and creating the mysql.rrd file.  From there, It's not displaying data out into the website.  When I run the call to hobbitgraph.sh directly from the browser, it is returning back an error 500 for mysql but I'm getting results from other graphs.

Anyway, without further introduction, these are my parameters:

hobbitserver:
#only testing slowqueries for now

NCV_mysql="Slowqueries:GAUGE"
TEST2RRD="cpu=la,disk,inode,qtree,memory,$PINGCOLUMN=tcp,http=tcp,dns=tcp,
dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apache,bind,sendmail,mailq,
nmailq=mailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy,hobbitd,mysql=ncv"

GRAPHS="la,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,netstat,mrtg::1,
temperature,ntpstat,apache,bind,sendmail,mailq,socks,bea,iishealth,citrix,bbgen,bbtest,
bbproxy,hobbitd,mysql,ncv"


and yes, it comes out from mysql.rrd

(from rrdtools dump)

        <ds>
                <name> Slowqueries </name>
                <type> GAUGE </type>
                <minimal_heartbeat> 600 </minimal_heartbeat>
                <min> 0.0000000000e+00 </min>
                <max> NaN </max>

                <!-- PDP Status -->
                <last_ds> UNKN </last_ds>
                <value> 0.0000000000e+00 </value>
                <unknown_sec> 0 </unknown_sec>
        </ds>

And this is the definition from hobbitgraph, which is mysqlslow with a "mysql" tag. (try to put the entry on trends, and did not work either, anyway). mysqlslow and mysqlthreads are commented out.


[mysql]
        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


Other than that, I do not see anything wrong, and there are no errors coming out of anywhere.  But I just can't get the graph out on the website for mysql. (the other ones are working fine).

I know that I must be missing something really basic, I just can't pinpoint it.  Any help would be appreciated.

Luis

I just took a quick glance, but don't you need a YAXIS line for graphs?

Maybe try that, or even copying a known working one and don't do
anything besides editing the DS and file name.

On 3/19/06, Luis Anaya <user-82616d847105@xymon.invalid> wrote: