Mysql Graphing

Nelson Amaral amaral8011 at googlemail.com
Fri Mar 26 16:46:02 CET 2010


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


More information about the Xymon mailing list