Mysql Graphing

[Nelson Amaral]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20100326/d5492217/attachment.html>