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.
XX Richmond St. West - 8th Floor
Toronto, Ontario, Canada
M5H 2C9
Tel: XXX-XXX-XXXX x344
Fax: XXX-XXX-XXXX
www.geosoft.com
From: Ralph Mitchell [mailto:user-00a5e44c48c0@xymon.invalid]
Sent: Wednesday, May 31, 2006 1:25 AM
To: user-ae9b8668bcde@xymon.invalid
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... :)