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