[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Mysql Graphing
- To: hobbit (at) hswn.dk
- Subject: Re: Mysql Graphing
- From: Nelson Amaral <amaral8011 (at) googlemail.com>
- Date: Fri, 26 Mar 2010 16:04:21 +0000
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:content-type; bh=93X4f2gO1OM5XqBCO2pONFBzJ0v9dMMVkfpvSiYx7rI=; b=CiCOyJYGejDzLc772PmreVV0mIZk7uRDg1TVfmL6cspCt5tEKKffvi1k1Tiei3yFv6 tFQu8Iy/qQB8ffehl8rbTQYFetzuXSjW8NOumZyMEc7FpRQfyTHe4VgIJwIh4Ht9gbBY 4DpKxwd0b1wAz5bpwvTp38qiel7pqvAPF4tmY=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=ZHabIOyBECP8V/UYcFdGU6hR5ZkpLTUhSbIhI24WWQF6/d9KGd6vWSC0htFgt5D0// /2ZIxGAYNJMCzrr4hOpN2ICyh1NRAv3gSfB4E3LvRASThKoW919TTMGcaKj6tmZ2wFuj /GMKyHMZMk1GtnCZtxGMsrBj2fJ3mdtzmQSvw=
- References: <e8d7c4e31003260846j1585d9cfx16d7525340c54992 (at) mail.gmail.com>
H,
Apologies in advance for all the emails.
I had a problem with the server and without wanting 3 messages went out
(well 4 with this one :) )
I'm kind of new to hobbit so if you point me in the right direction i can
probably find the solution.
On 26 March 2010 15:46, Nelson Amaral <amaral8011 (at) googlemail.com> wrote:
>
>
> Hi
>
> I have used a mysql script from xymonton to collect data into xymon, i get
> the data in xymon OK but the problem is the graphs right now.
>
> The graphs come up in the page but is not plotting, the problem is some
> where between hobbitserver.cfg and hobbitgraph.cfg
>
> I am asking for help while i carry on looking for the answer (maybe i'm
> missing something in the configuration)
>
> please note that the rrd file is created in the data folder
>
> I get the data in xymon example:
>
> *Fri Mar 26 14:54:26 2010 MySQL Server OK*
>
> *threads: 1 questions: 990691 slow queries: 0 opens: 7128 flush tables: 1 open tables: 64 queries per second avg: 0.402 maxcon: 100 Server version: 5.0.77 Source distribution Uptime: 28 days 12 hours 19 min 1 sec Server reports timestamp of 2010-03-26 14:54:26 *
>
> and have added the following in hobbitserver.cfg
>
> in TEST2RRD i added mysql=ncv
>
> and then added the following line
>
> NCV_mysql="threads:GAUGE,questions:GAUGE,slow queries:GAUGE,opens:GAUGE,flush tables:GAUGE,open tables:GAUGE,queries per second avg:GAUGE"
>
> also in hobbitgraph.cfg i added the following
>
> (i only have the first 2 instances of data for testing purposes)
>
> *[mysql]*
> * TITLE mysql info*
> * YAXIS #*
> * DEF:threads=mysql.rrd:threads:AVERAGE *
> * DEF:questions=mysql.rrd:questions:AVERAGE*
> * LINE1:threads#00CCCC:threads*
> * LINE2:questions#FF0000:questions*
> * COMMENT:\n*
> * GPRINT:threads:LAST:Threads \: %5.1lf (cur)*
> * GPRINT:threads:MAX: \: %5.1lf (max)*
> * GPRINT:threads:MIN: \: %5.1lf (min)*
> * GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n*
> * GPRINT:questions:LAST:Questions\: %5.1lf%s (cur)*
> * GPRINT:questions:MAX: \: %5.1lf%s (max)*
> * GPRINT:questions:MIN: \: %5.1lf%s (min)*
> * GPRINT:questions:AVERAGE: \: %5.1lf%s (avg)\n *
>
>
>
> Regards
>
> Nelson Amaral
> --
> Kind regards
>
> Nelson Amaral
>
--
Kind regards
Nelson Amaral