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

Re: [hobbit] NCV data collector, ok, what am I doing wrong?



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 <papo (at) dcentral.net> wrote:
> 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
>
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe (at) hswn.dk
>
>
>