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