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... :)
Ralph Mitchell
On 5/30/06, Jason Chambers <user-3fa671c0a30d@xymon.invalid> wrote:
No Rush! :D
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:* Monday, May 29, 2006 8:47 PM
*To:* user-ae9b8668bcde@xymon.invalid
*Subject:* Re: [hobbit] mysql monitor
I don't have immediate access to the hobbit server - it's at work, I'/m at
home... Tomorrow night, OK?
Ralph Mitchell
On 5/29/06, *Jason Chambers* <user-3fa671c0a30d@xymon.invalid> wrote:
I finally figured out that I made a typo for my hobbitlaunch.cfg file. Can
you help me get the graphing working too? I never done it before, and mostly
relied on the server being able to do that.
Jason Chambers
*IT Helpdesk Support*
eosoft Inc. <http://www.geosoft.com/20>;
XX Richmond St. West - 8th Floor <http://www.geosoft.com/20>;
Toronto, Ontario, Canada <http://www.geosoft.com/20>;
M5H 2C9 <http://www.geosoft.com/20>;
Tel: XXX-XXX-XXXX x344 <http://www.geosoft.com/20>;
Fax: XXX-XXX-XXXX <http://www.geosoft.com/20>;
*www.geosoft.com * <http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
* From: Ralph Mitchell [mailto:user-00a5e44c48c0@xymon.invalid]
Sent: Saturday, May 27, 2006 1:12 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] mysql monitor <http://www.geosoft.com/20>*
<http://www.geosoft.com/20>;
Hmm... I just downloaded the current bb-mysqlstatus.tar.gz from *
deadcat.net*, diffed bb-mysqlstat.sh against the one I have running on a
hobbit server, and the only change I made was to replace VALIDMYSQLUSER &
VALIDMYSQLPASSWORD.
The status page shows: <http://www.geosoft.com/20>;
Sat May 27 00:05:21 CDT 2006 - Mysql OK <http://www.geosoft.com/20>;
Uptime: 286 Threads: 1 Questions: 2916 Slow queries: 0 Opens: 37 Flush tables: 1 Open tables: 31 Queries per second avg: 10.196
<http://www.geosoft.com/20>;
This is on a Sun E450 running Gentoo, linux kernel 2.6.16, MySQL-4.1.19.
Ralph Mitchell <http://www.geosoft.com/20>;
On 5/26/06, *Jason Chambers * <*user-3fa671c0a30d@xymon.invalid*> wrote:<http://www.geosoft.com/20>;
Hi, <http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
Does anyone have a mysql monitor working for hobbit client? I suck at
reprogramming the one on *deadcat.net* <http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
Jason Chambers <http://www.geosoft.com/20>;
*IT Helpdesk Support <http://www.geosoft.com/20>*
eosoft Inc. <http://www.geosoft.com/20>;
XX Richmond St. West - 8th Floor <http://www.geosoft.com/20>;
Toronto, Ontario, Canada <http://www.geosoft.com/20>;
M5H 2C9 <http://www.geosoft.com/20>;
Tel: XXX-XXX-XXXX x344 <http://www.geosoft.com/20>;
Fax: XXX-XXX-XXXX <http://www.geosoft.com/20>;
*www.geosoft.com* <http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;
<http://www.geosoft.com/20>;