Mysql Graphing
list Nelson Amaral
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" <user-9219fb9415b1@xymon.invalid> To: user-ae9b8668bcde@xymon.invalid 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.
list Nelson Amaral
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" <user-9219fb9415b1@xymon.invalid> To: user-ae9b8668bcde@xymon.invalid 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.
list Nelson Amaral
▸
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
list Nelson Amaral
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 <user-eec7fbb2775a@xymon.invalid> 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
list Jerald Sheets
Methinks Nelson's mail server is burping... --j
▸
On Mar 26, 2010, at 8:59 AM, Nelson Amaral 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
----- Original Message -----
From: "thorsten erdmann" <user-9219fb9415b1@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
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. list Martin Flemming
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 <user-eec7fbb2775a@xymon.invalid> 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
list Nelson Amaral
Ehehe Once again sorry for the spaming. I got the graphs working for mysql, I will be posting all the steps in this thread later for everyone that has the same problem in the future. Regards Nelson Sent from my BlackBerry® wireless device
▸
-----Original Message-----
From: Jerald Sheets <user-96a6f34c5806@xymon.invalid>
Date: Fri, 26 Mar 2010 12:05:23 To: <user-ae9b8668bcde@xymon.invalid>
Subject: Re: [hobbit] Mysql Graphing
Methinks Nelson's mail server is burping...
--j
On Mar 26, 2010, at 8:59 AM, Nelson Amaral 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
----- Original Message -----
From: "thorsten erdmann" <user-9219fb9415b1@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
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. list Jerald Sheets
This is something that would be outstanding for the wiki. The MySQL stuff is actually already in my hobbtgraph file which initially puzzled me. After working through it a number of times, I was able to finally get it to work, but not without some difficulty. Excellent work, Nelson. --j
▸
On Mar 27, 2010, at 5:44 AM, user-eec7fbb2775a@xymon.invalid wrote:
Ehehe Once again sorry for the spaming. I got the graphs working for mysql, I will be posting all the steps in this thread later for everyone that has the same problem in the future. Regards Nelson Sent from my BlackBerry® wireless device From: Jerald Sheets <user-96a6f34c5806@xymon.invalid> Date: Fri, 26 Mar 2010 12:05:23 -0400 To: <user-ae9b8668bcde@xymon.invalid> Subject: Re: [hobbit] Mysql Graphing Methinks Nelson's mail server is burping... --j On Mar 26, 2010, at 8:59 AM, Nelson Amaral 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 ----- Original Message ----- From: "thorsten erdmann" <user-9219fb9415b1@xymon.invalid> To: user-ae9b8668bcde@xymon.invalid 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.
list Nelson Amaral
Yes, i do think it should be integrated with the default release (like dns,smtp,etc) I can write something for the wiki, not a problem, just let me know where it should be posted It is already in the hobbitgraph file but it could do with a bit of an upgrade. Before I go ahead and write the wiki I would like to ask the sql "maestros" to point out what show be monitored in Mysql (ie, what information can we get in hobbit that will give us a very good an detailed picture of the mysql database). waiting for sugestions, also with your sugestions could you please send the commands to find that information? Nelson
▸
On 27 March 2010 13:50, Jerald Sheets <user-96a6f34c5806@xymon.invalid> wrote:
This is something that would be outstanding for the wiki.
The MySQL stuff is actually already in my hobbtgraph file which initially
puzzled me. After working through it a number of times, I was able to
finally get it to work, but not without some difficulty.
Excellent work, Nelson.
--j
On Mar 27, 2010, at 5:44 AM, user-eec7fbb2775a@xymon.invalid wrote:
Ehehe
Once again sorry for the spaming.
I got the graphs working for mysql, I will be posting all the steps in this
thread later for everyone that has the same problem in the future.
Regards
Nelson
Sent from my BlackBerry® wireless device
*From: * Jerald Sheets <user-96a6f34c5806@xymon.invalid>
*Date: *Fri, 26 Mar 2010 12:05:23 -0400
*To: *<user-ae9b8668bcde@xymon.invalid>
*Subject: *Re: [hobbit] Mysql Graphing
Methinks Nelson's mail server is burping...
--j
On Mar 26, 2010, at 8:59 AM, Nelson Amaral 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
----- Original Message -----
From: "thorsten erdmann" <user-9219fb9415b1@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
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.
--
Kind regards
Nelson Amaral
list TJ Yang
▸
I can write something for the wiki, not a problem, just let me know where it should be posted
How about here http://en.wikibooks.org/wiki/System_Monitoring_with_Xymon/Other_Docs/HOWTO ? tj