RE: [hobbit] mysql monitor

["Jason Chambers" <Jason.Chambers (at) geosoft.com>]

Nuts! I've replaced and copied the data you pasted here, but I'm still
having now luck getting the rrd graph for it to appear! L I just tried
upgrading to the latest snapshot of hobbit too, to see if it would get
me lucky. Oh well,

 

Thanks for trying Ralph!

 

Jason Chambers

IT Helpdesk Support

  <http://www.geosoft.com/20> eosoft Inc.

85 Richmond St. West - 8th Floor

Toronto, Ontario, Canada

M5H 2C9

Tel: 416-369-0111 x344

Fax: 416-369-9599

www.geosoft.com

 

 

From: Ralph Mitchell [mailto:ralphmitchell (at) gmail.com] 
Sent: Wednesday, May 31, 2006 1:25 AM
To: hobbit (at) hswn.dk
Subject: Re: [hobbit] mysql monitor

 

Looks like I've got these:

in hobbitgraph.cfg:
   [mysqlslow]
        TITLE MySQL Slow Queries
        YAXIS Slow Queries
        DEF:slow=mysql.rrd:Slowqueries:AVERAGE
        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

   [mysqlthread]
        TITLE MySQL Active Threads
        YAXIS Threads
        DEF:threads=mysql.rrd:Threads:AVERAGE
        AREA:threads#00CCCC:Threads
        COMMENT:\n
        GPRINT:threads:LAST: \: %5.1lf (cur)
        GPRINT:threads:MAX: \: %5.1lf (max)
        GPRINT:threads:MIN: \: %5.1lf (min)
        GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n

in hobbitserver.cfg:
   TEST2RRD="cpu=la,disk...mysql=ncv"
   GRAPHS="la,disk...mysql:mysqlslow,mysql:mysqlthread"
   NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE"

The status line from one host reads:
   Uptime: 5421958   Threads: 1  Questions: 1051219  Slow queries: 577
Opens: 80325  Flush tables: 189  Open tables: 63

The Uptime value is discarded and the rest go into the mysql.rrd.  Only
the "Slow queries" and "Thread" graphs show on the Trends page.

It may not be optimal, but I am getting graphs... :)