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