[hobbit] mysql monitor

[thomas.seglard.enata at cnp.fr]

Hi,

I've done all of that and I didn't get it to work ! Is there another thing  to do ? I'm looking at the man-page (hobbitd_rrd) but it's the same 
example ! I put the line NCV_mysql="Uptime:NONE,Queriespersecondavg:GAUGE" 
into hobbitserver.cfg but what can I do to have the corresponding graph 
appear in "trends" ?
Thanks a lot for your help !

Thomas


"Ralph Mitchell" <ralphmitchell at gmail.com> a écrit sur 31/05/2006 07:25:11 
:

> 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
> [image supprimée] 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.
> 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.
> 85 Richmond St. West - 8th Floor
> Toronto, Ontario, Canada
> M5H 2C9
> Tel: 416-369-0111 x344
> Fax: 416-369-9599
> www.geosoft.com
> 
> 
> 
> 
> 
> 
> 


Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires.
Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est
interdite, sauf autorisation expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite
au titre de ce message, s'il a ete altere, deforme ou falsifie.

*****

This message and any attachments (the "message") are confidential and intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
E-mails are susceptible to alteration.
Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.