[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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