Mysql Graphing

[Nelson Amaral <namaral (at) fnot.org.uk>]

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 

----- Original Message ----- 
From: "thorsten erdmann" <thorsten.erdmann (at) daimler.com> 
To: hobbit (at) hswn.dk 
Sent: Friday, 26 March, 2010 11:27:32 AM 
Subject: [hobbit] message filter and the DEFAULT section 


Hi 

I want to filter some messages from a specific server's message log. So I built a special rule in hobbit-clients.cfg to filter that message, but it is ignored. It seems Hobbit preferres the DEFAULT section. If I uncomment the DEFAULT LOG rule my special rule is used and the message is filtered. 

So how can I have a default rule including some IGNORE clauses which is used for all my servers and an additional set of rule specific to one or more servers. 

Here is my hobbit-client.cfg. The rule I currently playing with is marked with (***), it's the host s068c326. If I comment out the last two lines it works, if not the message "ntpd error" is detected as error. 

HOST=s068310i 
DISK %^/platform.* IGNORE 

HOST=s068310b 
DISK %^/platform.* IGNORE 

HOST=s068a300 
LOG %.* %(fatal|error) COLOR=red IGNORE=%(smb_proc_readdir_long|peer) 
LOG %.* warning COLOR=yellow 
# DISK * 10 15 

HOST=s068c327 
DISK /mnt IGNORE 

#HOST=%s068c32.* 
HOST=s068c326 
#HOST=s068c320,s068c321,s068c322,s068c323,s068c324,s068c325,s068c326,s068c327 
LOG %.* %(fatal|error) IGNORE=%ntpd COLOR=red #(***) 

HOST=s068c320,s068c321,s068c322 
PROC "lmgrd -c" 1 1 
PROC "pam_lmd" 1 1 

DEFAULT 
# These are the built-in defaults. 
UP 1h 
LOAD 5.0 10.0 
DISK * 90 95 
DISK /media/cdrom 101 101 
MEMPHYS 100 101 
MEMSWAP 50 80 
MEMACT 90 97 

LOG %.* %(fatal|error) COLOR=red IGNORE=%(read_socket_data|peer) 
LOG %.* warning COLOR=yellow IGNORE=40960 


Thank you for help 

Thorsten Erdmann 

If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation.