Friday, May 24th 2013, 1:15pm UTC+2

You are not logged in.

  • Login
  • Register

No matching perfdata values found

Dear visitor, welcome to Monitoring-Portal.
Although this is a german monitoring forum, please don't hesitate to post in English. Nearly everybody here understands you and will answer in English as well.
If this is your first visit here, please read the Help. It explains how this page works. You must be registered before you can use all the page's features. Please use the registration form to register here or read more information about the registration process. If you are already registered, please login here.

nagios9

Trainee

Posts: 63

Number of monitoring servers: 2

Nagios Version: 3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 50

Number of services: paar hundert

OS: Debian

Plugin Version: 1.4

1

Tuesday, April 28th 2009, 8:55pm

No matching perfdata values found

Hallo,

gerade habe ich Nagios Grapher installatiert nur wird für Mysql kein Grapher erstellt.

Quoted

2009-04-28 20:51:43 PIPE: Server1 MySQL Uptime: 1640188 Threads: 11 Questions: 14753457 Slow queries: 1 Opens: 84853 Flush tables: 1 Open tables: 64 Queries per second avg: 8.995 1240944665
2009-04-28 20:51:43 REGEX: 1 blocks for 'MySQL' found.
2009-04-28 20:51:43 REGEX: graph_value=diff
2009-04-28 20:51:43 REGEX: output=perfdata
2009-04-28 20:51:43 REGEX: regex=m/diff=(\d+)/i
2009-04-28 20:51:43 REGEX: perfdata=
2009-04-28 20:51:43 REGEX: NO MATCH.
2009-04-28 20:51:43 VALUES: [Server1][MySQL]:No matching perfdata values found..
Woran liegt dies?
Ich verwende das Standarttemplate check_mysql.ncfg vom NagiosGrapher

Gruß
nagios9 has attached the following file:
  • check_mysql.txt (4.8 kB - 218 times downloaded - Last download: May 3rd 2013, 4:07am)

This post has been edited 1 times, last edit by "nagios9" (Apr 28th 2009, 9:00pm)

ze-de

Intermediate

Posts: 287

Number of monitoring servers: 1

Nagios Version: 1

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 1

Number of services: 1

OS: -

Plugin Version: -

2

Wednesday, April 29th 2009, 8:49am

Hallo Nagios9,

bei dir gibt's keine perf data.

probier's mal damit:

Source code

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236

#---
#NagiosGrapherTemplateforcheck_mysql
#---

#Threads
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Threads:\s*(\d+)
	graph_value		used
	graph_units		Threads
	graph_legend		Threads
	rrd_plottype		AREA
	rrd_color		EACC00
	page			Threads
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_used
	graph_calc		used
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			Threads
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		used_vdef
	graph_calc		used,AVERAGE
	graph_legend		AVG Threads
	rrd_plottype		LINE1
	rrd_color		000000
	page			Threads
}

#Questions
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Questions:\s*(\d+)
	graph_value		questions
	graph_units		Questions
	graph_legend		Questions
	rrd_plottype		AREA
	rrd_color		EACC00
	page			Questions
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_questions
	graph_calc		questions
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			Questions
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		questions_vdef
	graph_calc		questions,AVERAGE
	graph_legend		AVG Questions
	rrd_plottype		LINE1
	rrd_color		000000
	page			Questions
}

#Slow queries
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Slow queries:\s*(\d+)
	graph_value		queries
	graph_units		Slowqueries
	graph_legend		Slowqueries
	rrd_plottype		AREA
	rrd_color		EACC00
	page			Queries
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_queries
	graph_calc		queries
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			Queries
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		queries_vdef
	graph_calc		queries,AVERAGE
	graph_legend		AVG Queries
	rrd_plottype		LINE1
	rrd_color		000000
	page			Queries
}

#Opens
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Opens:\s*(\d+)
	graph_value		opens
	graph_units		Opens
	graph_legend		Opens
	rrd_plottype		AREA
	rrd_color		EACC00
	page			Opens
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_opens
	graph_calc		opens
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			Opens
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		opens_vdef
	graph_calc		opens,AVERAGE
	graph_legend		AVG Opens
	rrd_plottype		LINE1
	rrd_color		000000
	page			Opens
}

#FlushTables
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Flush tables:\s*(\d+)
	graph_value		flush_tables
	graph_units		Flushtables
	graph_legend		Flushtables
	rrd_plottype		AREA
	rrd_color		EACC00
	page			Flush_Tables
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_flush_tables
	graph_calc		flush_tables
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			Flush_Tables
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		flush_tables_vdef
	graph_calc		flush_tables,AVERAGE
	graph_legend		AVG Flush Tables
	rrd_plottype		LINE1
	rrd_color		000000
	page			Flush_Tables
}

#OpenTables
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Open tables:\s*(\d+)
	graph_value		open_tables
	graph_units		Open tables
	graph_legend		Open tables
	rrd_plottype		AREA
	rrd_color		EACC00
	page			Open_Tables
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_open_tables
	graph_calc		open_tables
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			Open_Tables
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		open_tables_vdef
	graph_calc		open_tables,AVERAGE
	graph_legend		AVG Open Tables
	rrd_plottype		LINE1
	rrd_color		000000
	page			Open_Tables
}

#AVGQueries
define ngraph{
	service_name		'mysql-info'
	graph_log_regex		Queries per second avg:\s*(\d+[\.,]\d+)
	graph_value		avg
	graph_units		Oueries per second avg
	graph_legend		Oueries per second avg
	rrd_plottype		AREA
	rrd_color		EACC00
	page			AVG
}

define ngraph{
	service_name		'mysql-info'
	type			CDEF
	graph_value		cdef_avg
	graph_calc		avg
	rrd_plottype		LINE1
	rrd_color		ff0000
	page			AVG
}

define ngraph{
	service_name		'mysql-info'
	type			VDEF
	graph_value		avg_vdef
	graph_calc		avg,AVERAGE
	graph_legend		AVG Oueries per second
	rrd_plottype		LINE1
	rrd_color		000000
	page			AVG
}

#[EOF]


Grüße

Christian
www.christian-doebler.net

nagios9

Trainee

Posts: 63

Number of monitoring servers: 2

Nagios Version: 3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 50

Number of services: paar hundert

OS: Debian

Plugin Version: 1.4

3

Friday, May 1st 2009, 8:06pm

danke aber jetzt kommt:

Source code

 
1
2

2009-05-01 20:01:27 PIPE: Server1   	MySQL   Uptime: 2942062  Threads: 1  Questions: 657515  Slow queries: 0  Opens: 994  Flush tables: 1  Open tables: 64  Queries per second avg: 0.223        	1241200861
2009-05-01 20:01:27 REGEX: No blocks for 'MySQL' found.


Kann man die perf data irgendwie einschalten?

ze-de

Intermediate

Posts: 287

Number of monitoring servers: 1

Nagios Version: 1

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 1

Number of services: 1

OS: -

Plugin Version: -

4

Monday, May 4th 2009, 9:45am

Hallo nagios9,

der service_name muss bei allen Definitionen von 'mysql-info' (inklusive " ' ") in 'MySQL' (exklusive " ' ") geändert werden.

Bsp.:

Source code

 
1

service_name       MySQL

Ich wüsste leider nicht, dass check_mysql performance data ausspuckt.

Grüße

Christian
www.christian-doebler.net

nagios9

Trainee

Posts: 63

Number of monitoring servers: 2

Nagios Version: 3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 50

Number of services: paar hundert

OS: Debian

Plugin Version: 1.4

5

Wednesday, May 6th 2009, 4:56pm

schaut schon besser aus nur jetzt kommt:

Source code

 
1
2
3
4

2009-05-06 16:51:45 VALUES: [Server1][MySQL]: opens=103463 avg=9.123 used=1 quer                                                                                                                           	ies=3 open_tables=64 flush_tables=1 questions=21138884
2009-05-06 16:51:45 RRD: rrdtool update /usr/local/nagios/var/rrd/Server1/a97dc3                                                                                                                           	e8b9374e25a13fac718949907f.rrd --template=opens:avg:used:queries:open_tables:flu                                                                                                                           	sh_tables:questions 1241621462:103463:9.123:1:3:64:1:21138884
2009-05-06 16:51:45 RRD: [Server1][MySQL]:unknown DS name 'used'
2009-05-06 16:52:18 FILE: reading perf data from /usr/local/nagios/var/service-p                                                                                                                           	erfdata.1241621512

ze-de

Intermediate

Posts: 287

Number of monitoring servers: 1

Nagios Version: 1

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 1

Number of services: 1

OS: -

Plugin Version: -

6

Thursday, May 7th 2009, 11:47am

Hallo nagios9,

hast du schonmal versucht, deine bisherige RRD-Datei (/usr/local/nagios/var/rrd/Server1/a97dc3e8b9374e25a13fac718949907f.rrd) zu löschen?

Grüße

Christian
www.christian-doebler.net

nagios9

Trainee

Posts: 63

Number of monitoring servers: 2

Nagios Version: 3

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 50

Number of services: paar hundert

OS: Debian

Plugin Version: 1.4

7

Friday, May 8th 2009, 11:34pm

Ah wunderbar das löschen hat es gebracht. DANKE!
Nur woran lag es nun?
Weil Current Load (und noch paar andere) funktionieren auch nicht.


Source code

 
1
2
3
4
5
6
7

2009-05-08 23:30:25 REGEX: 3 blocks for 'Current Load' found.
2009-05-08 23:30:25 REGEX: graph_value=15min
2009-05-08 23:30:25 REGEX: output=plugin.
2009-05-08 23:30:25 REGEX: regex=m/,(\d+[\.,]\d+)($|critical|warning)/i
2009-05-08 23:30:25 REGEX: perfdata=ok - load average: 0.03, 0.03, 0.06
2009-05-08 23:30:25 REGEX: NO MATCH.
2009-05-08 23:30:25 VALUES: [Server1][Current Load]:No matching output values found...

ze-de

Intermediate

Posts: 287

Number of monitoring servers: 1

Nagios Version: 1

Distributed monitoring: Nein

Redundant monitoring: Nein

Number of hosts: 1

Number of services: 1

OS: -

Plugin Version: -

8

Monday, May 11th 2009, 9:36am

Hi nagios9,

poste mal bitte ein paar Zeilen mehr, damit man den output noch erkennen kann... und natürlich wie immer: das template. :)

Grüße

Christian
www.christian-doebler.net

Similar threads