[hobbit] Re: Mysql Graphing

[Martin Flemming]

Hi !

Try in hobbitserver.cfg

NCV_mysql="*:GAUGE"

and in hobbitgraph.cfg

[mysqlslow]
         DEF:slow=mysql.rrd:slowqueries:AVERAGE
         TITLE MySQL Slow Queries
         YAXIS #
         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

[mysqlthreads]
         DEF:threads=mysql.rrd:threads:AVERAGE
         TITLE MySQL Active Threads
         YAXIS #
         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

[mysqlquestions]
         DEF:slow=mysql.rrd:questions:AVERAGE
         TITLE MySQL Questions
         YAXIS #
         LINE2:slow#00CCCC:Questions
         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

[mysqlopens]
         DEF:slow=mysql.rrd:opens:AVERAGE
         TITLE MySQL Opens
         YAXIS #
         LINE2:slow#00CCCC:Opens
         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

[mysqlopentables]
         DEF:slow=mysql.rrd:opentables:AVERAGE
         TITLE MySQL Open Tables
         YAXIS #
         LINE2:slow#00CCCC:Open Tables
         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


[mysqlqueries]
         DEF:slow=mysql.rrd:queriespersecondavg:AVERAGE
         TITLE MySQL Queries per Second
         YAXIS #
         LINE2:slow#00CCCC:Queries per Seconds
         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

You've got now no graph in mysql-test-pager but into the trendpage ....

... and look into your mysql.rrd-file if there is everything alright ..

rrdtool dump mysql.rrd |les

cheers,
 	martin



On Fri, 26 Mar 2010, Nelson Amaral wrote:

> 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
>