[hobbit] mysql monitor

[Ralph Mitchell]

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 <Jason.Chambers at geosoft.com> wrote:
>
>   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>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20060531/c19850de/attachment.html>