-
Notifications
You must be signed in to change notification settings - Fork 4.9k
/
fields.yml
469 lines (403 loc) · 14.4 KB
/
fields.yml
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
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
- name: status
type: group
description: >
`status` contains the metrics that were obtained by the status SQL query.
release: ga
fields:
- name: aborted
type: group
description: >
Aborted status fields.
fields:
- name: clients
type: long
description: >
The number of connections that were aborted because the client died without closing the connection properly.
- name: connects
type: long
description: >
The number of failed attempts to connect to the MySQL server.
- name: connection
type: group
description: >
fields:
- name: errors
type: group
description: >
fields:
- name: peer_address
type: long
description: The number of errors that occurred while searching for connecting client IP addresses.
- name: accept
type: long
description: The number of errors that occurred during calls to accept() on the listening port.
- name: internal
type: long
description: >
The number of connections refused due to internal errors in the server, such as failure to start a new
thread or an out-of-memory condition.
- name: max
type: long
description: The number of connections refused because the server max_connections limit was reached.
thread or an out-of-memory condition.
- name: tcpwrap
type: long
description: The number of connections refused by the libwrap library.
- name: select
type: long
description: >
The number of errors that occurred during calls to select() or poll() on the listening port.
(Failure of this operation does not necessarily means a client connection was rejected.)
- name: cache
type: group
description: >
fields:
- name: ssl
type: group
description: SSL session cache hits and misses.
fields:
- name: hits
type: long
description: The number of SSL session cache hits.
- name: misses
type: long
description: The number of SSL session cache misses.
- name: size
type: long
description: The SSL session cache size.
- name: table
type: group
description: >
fields:
- name: open_cache
type: group
description: >
fields:
- name: hits
type: long
description: The number of hits for open tables cache lookups.
- name: misses
type: long
description: The number of misses for open tables cache lookups.
- name: overflows
type: long
description: >
Number of times, after a table is opened or closed, a cache instance has an unused entry and the
size of the instance is larger than table_open_cache / table_open_cache_instances
- name: binlog
type: group
description: >
fields:
- name: cache.disk_use
type: long
description: >
- name: cache.use
type: long
description: >
- name: bytes
type: group
description: >
Bytes stats.
fields:
- name: received
format: bytes
type: long
description: >
The number of bytes received from all clients.
- name: sent
type: long
format: bytes
description: >
The number of bytes sent to all clients.
- name: threads
type: group
description: >
Threads stats.
fields:
- name: cached
type: long
description: >
The number of cached threads.
- name: created
type: long
description: >
The number of created threads.
- name: connected
type: long
description: >
The number of connected threads.
- name: running
type: long
description: >
The number of running threads.
- name: connections
type: long
description: >
- name: created
type: group
description: >
fields:
- name: tmp.disk_tables
type: long
description: >
- name: tmp.files
type: long
description: >
- name: tmp.tables
type: long
description: >
- name: delayed
type: group
description: >
fields:
- name: errors
type: long
description: >
- name: insert_threads
type: long
description: >
- name: writes
type: long
description: >
- name: flush_commands
type: long
description: >
- name: max_used_connections
type: long
description: >
- name: open
type: group
description: >
fields:
- name: files
type: long
description: >
- name: streams
type: long
description: >
- name: tables
type: long
description: >
- name: opened_tables
type: long
description: >
- name: command
type: group
description: >
fields:
- name: delete
type: long
description: >
The number of DELETE queries since startup.
- name: insert
type: long
description: >
The number of INSERT queries since startup.
- name: select
type: long
description: >
The number of SELECT queries since startup.
- name: update
type: long
description: >
The number of UPDATE queries since startup.
- name: queries
type: long
description: >
The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count COM_PING or COM_STATISTICS commands.
- name: questions
type: long
description: >
The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands.
- name: handler
type: group
description: >
fields:
- name: commit
type: long
description: >
The number of internal COMMIT statements.
- name: delete
type: long
description: >
The number of times that rows have been deleted from tables.
- name: external_lock
type: long
description: >
The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table instance.
- name: mrr_init
type: long
description: >
The number of times the server uses a storage engine's own Multi-Range Read implementation for table access.
- name: prepare
type: long
description: >
A counter for the prepare phase of two-phase commit operations.
- name: read
type: group
description: >
fields:
- name: first
type: long
description: >
The number of times the first entry in an index was read.
- name: key
type: long
description: >
The number of requests to read a row based on a key.
- name: last
type: long
description: >
The number of requests to read the last key in an index.
- name: next
type: long
description: >
The number of requests to read the next row in key order.
- name: prev
type: long
description: >
The number of requests to read the previous row in key order.
- name: rnd
type: long
description: >
The number of requests to read a row based on a fixed position.
- name: rnd_next
type: long
description: >
The number of requests to read the next row in the data file.
- name: rollback
type: long
description: >
The number of requests for a storage engine to perform a rollback operation.
- name: savepoint
type: long
description: >
The number of requests for a storage engine to place a savepoint.
- name: savepoint_rollback
type: long
description: >
The number of requests for a storage engine to roll back to a savepoint.
- name: update
type: long
description: >
The number of requests to update a row in a table.
- name: write
type: long
description: >
The number of requests to insert a row in a table.
- name: innodb
type: group
description: >
fields:
- name: rows
type: group
description: >
fields:
- name: reads
type: long
description: The number of rows reads into InnoDB tables.
- name: inserted
type: long
description: The number of rows inserted into InnoDB tables.
- name: deleted
type: long
description: The number of rows deleted into InnoDB tables.
- name: updated
type: long
description: The number of rows updated into InnoDB tables.
- name: buffer_pool
type: group
description: >
fields:
- name: dump_status
type: long
description: >
The progress of an operation to record the pages held in the InnoDB buffer pool, triggered by the setting of innodb_buffer_pool_dump_at_shutdown or innodb_buffer_pool_dump_now.
- name: load_status
type: long
description: >
The progress of an operation to warm up the InnoDB buffer pool by reading in a set of pages corresponding to an earlier point in time, triggered by the setting of innodb_buffer_pool_load_at_startup or innodb_buffer_pool_load_now.
- name: bytes
type: group
description: >
fields:
- name: data
type: long
description: >
The total number of bytes in the InnoDB buffer pool containing data.
- name: dirty
type: long
description: >
The total current number of bytes held in dirty pages in the InnoDB buffer pool.
- name: pages
type: group
description: >
fields:
- name: data
type: long
description: >
The number of pages in the InnoDB buffer pool containing data.
- name: dirty
type: long
description: >
The current number of dirty pages in the InnoDB buffer pool.
- name: flushed
type: long
description: >
The number of requests to flush pages from the InnoDB buffer pool.
- name: free
type: long
description: >
The number of free pages in the InnoDB buffer pool.
- name: latched
type: long
description: >
The number of latched pages in the InnoDB buffer pool.
- name: misc
type: long
description: >
The number of pages in the InnoDB buffer pool that are busy because they have been allocated for administrative overhead, such as row locks or the adaptive hash index.
- name: total
type: long
description: >
The total size of the InnoDB buffer pool, in pages.
- name: read
type: group
description: >
fields:
- name: ahead
type: long
description: >
The number of pages read into the InnoDB buffer pool by the read-ahead background thread.
- name: ahead_evicted
type: long
description: >
The number of pages read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries.
- name: ahead_rnd
type: long
description: >
The number of "random" read-aheads initiated by InnoDB.
- name: requests
type: long
description: >
The number of logical read requests.
- name: pool
type: group
description: >
fields:
- name: reads
type: long
description: >
The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.
- name: resize_status
type: long
description: >
The status of an operation to resize the InnoDB buffer pool dynamically, triggered by setting the innodb_buffer_pool_size parameter dynamically.
- name: wait_free
type: long
description: >
Normally, writes to the InnoDB buffer pool happen in the background. When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation to finish. This counter counts instances of these waits.
- name: write_requests
type: long
description: >
The number of writes done to the InnoDB buffer pool.