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

<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: Saturday, May 27, 2006 1:12 AM To: hobbit at hswn.dk Subject: Re: [hobbit] mysql monitor

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:

Sat May 27 00:05:21 CDT 2006 - Mysql OK

Uptime: 286 Threads: 1 Questions: 2916 Slow queries: 0 Opens: 37 Flush tables: 1 Open tables: 31 Queries per second avg: 10.196

This is on a Sun E450 running Gentoo, linux kernel 2.6.16, MySQL-4.1.19.

Ralph Mitchell

On 5/26/06, Jason Chambers <Jason.Chambers at geosoft.com> wrote:

Hi,

Does anyone have a mysql monitor working for hobbit client? I suck at reprogramming the one on deadcat.net

Jason Chambers

IT Helpdesk Support

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

85 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: 416-369-0111 x344 <http://www.geosoft.com/20>

Fax: 416-369-9599 <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>

No Rush! :D

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: Monday, May 29, 2006 8:47 PM To: hobbit at hswn.dk 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 <Jason.Chambers at geosoft.com> 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>

85 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: 416-369-0111 x344 <http://www.geosoft.com/20>

Fax: 416-369-9599 <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:ralphmitchell at gmail.com] Sent: Saturday, May 27, 2006 1:12 AM To: hobbit at hswn.dk 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 <Jason.Chambers at geosoft.com> 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>

85 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: 416-369-0111 x344 <http://www.geosoft.com/20>

Fax: 416-369-9599 <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>

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... :)