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

Luis Anaya papo at dcentral.net
Mon Mar 20 02:22:14 CET 2006


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





More information about the Xymon mailing list