blob: da5020bbe080668157a59165b2b428654b0a5bd5 (
plain)
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
|
SELECT variable_name FROM information_schema.global_status
WHERE variable_name LIKE 'INNODB_%'
AND variable_name NOT IN
('INNODB_ADAPTIVE_HASH_HASH_SEARCHES','INNODB_ADAPTIVE_HASH_NON_HASH_SEARCHES',
'INNODB_MEM_ADAPTIVE_HASH',
'INNODB_BUFFERED_AIO_SUBMITTED','INNODB_BUFFER_POOL_PAGES_LATCHED');
variable_name
INNODB_BACKGROUND_LOG_SYNC
INNODB_BUFFER_POOL_DUMP_STATUS
INNODB_BUFFER_POOL_LOAD_STATUS
INNODB_BUFFER_POOL_RESIZE_STATUS
INNODB_BUFFER_POOL_LOAD_INCOMPLETE
INNODB_BUFFER_POOL_PAGES_DATA
INNODB_BUFFER_POOL_BYTES_DATA
INNODB_BUFFER_POOL_PAGES_DIRTY
INNODB_BUFFER_POOL_BYTES_DIRTY
INNODB_BUFFER_POOL_PAGES_FLUSHED
INNODB_BUFFER_POOL_PAGES_FREE
INNODB_BUFFER_POOL_PAGES_MADE_NOT_YOUNG
INNODB_BUFFER_POOL_PAGES_MADE_YOUNG
INNODB_BUFFER_POOL_PAGES_MISC
INNODB_BUFFER_POOL_PAGES_OLD
INNODB_BUFFER_POOL_PAGES_TOTAL
INNODB_BUFFER_POOL_PAGES_LRU_FLUSHED
INNODB_BUFFER_POOL_PAGES_LRU_FREED
INNODB_BUFFER_POOL_READ_AHEAD_RND
INNODB_BUFFER_POOL_READ_AHEAD
INNODB_BUFFER_POOL_READ_AHEAD_EVICTED
INNODB_BUFFER_POOL_READ_REQUESTS
INNODB_BUFFER_POOL_READS
INNODB_BUFFER_POOL_WAIT_FREE
INNODB_BUFFER_POOL_WRITE_REQUESTS
INNODB_CHECKPOINT_AGE
INNODB_CHECKPOINT_MAX_AGE
INNODB_DATA_FSYNCS
INNODB_DATA_PENDING_FSYNCS
INNODB_DATA_PENDING_READS
INNODB_DATA_PENDING_WRITES
INNODB_DATA_READ
INNODB_DATA_READS
INNODB_DATA_WRITES
INNODB_DATA_WRITTEN
INNODB_DBLWR_PAGES_WRITTEN
INNODB_DBLWR_WRITES
INNODB_DEADLOCKS
INNODB_HISTORY_LIST_LENGTH
INNODB_IBUF_DISCARDED_DELETE_MARKS
INNODB_IBUF_DISCARDED_DELETES
INNODB_IBUF_DISCARDED_INSERTS
INNODB_IBUF_FREE_LIST
INNODB_IBUF_MERGED_DELETE_MARKS
INNODB_IBUF_MERGED_DELETES
INNODB_IBUF_MERGED_INSERTS
INNODB_IBUF_MERGES
INNODB_IBUF_SEGMENT_SIZE
INNODB_IBUF_SIZE
INNODB_LOG_WAITS
INNODB_LOG_WRITE_REQUESTS
INNODB_LOG_WRITES
INNODB_LSN_CURRENT
INNODB_LSN_FLUSHED
INNODB_LSN_LAST_CHECKPOINT
INNODB_MASTER_THREAD_ACTIVE_LOOPS
INNODB_MASTER_THREAD_IDLE_LOOPS
INNODB_MAX_TRX_ID
INNODB_MEM_DICTIONARY
INNODB_OS_LOG_FSYNCS
INNODB_OS_LOG_PENDING_FSYNCS
INNODB_OS_LOG_PENDING_WRITES
INNODB_OS_LOG_WRITTEN
INNODB_PAGE_SIZE
INNODB_PAGES_CREATED
INNODB_PAGES_READ
INNODB_PAGES_WRITTEN
INNODB_ROW_LOCK_CURRENT_WAITS
INNODB_ROW_LOCK_TIME
INNODB_ROW_LOCK_TIME_AVG
INNODB_ROW_LOCK_TIME_MAX
INNODB_ROW_LOCK_WAITS
INNODB_ROWS_DELETED
INNODB_ROWS_INSERTED
INNODB_ROWS_READ
INNODB_ROWS_UPDATED
INNODB_SYSTEM_ROWS_DELETED
INNODB_SYSTEM_ROWS_INSERTED
INNODB_SYSTEM_ROWS_READ
INNODB_SYSTEM_ROWS_UPDATED
INNODB_NUM_OPEN_FILES
INNODB_TRUNCATED_STATUS_WRITES
INNODB_AVAILABLE_UNDO_LOGS
INNODB_UNDO_TRUNCATIONS
INNODB_PAGE_COMPRESSION_SAVED
INNODB_NUM_INDEX_PAGES_WRITTEN
INNODB_NUM_NON_INDEX_PAGES_WRITTEN
INNODB_NUM_PAGES_PAGE_COMPRESSED
INNODB_NUM_PAGE_COMPRESSED_TRIM_OP
INNODB_NUM_PAGES_PAGE_DECOMPRESSED
INNODB_NUM_PAGES_PAGE_COMPRESSION_ERROR
INNODB_NUM_PAGES_ENCRYPTED
INNODB_NUM_PAGES_DECRYPTED
INNODB_HAVE_LZ4
INNODB_HAVE_LZO
INNODB_HAVE_LZMA
INNODB_HAVE_BZIP2
INNODB_HAVE_SNAPPY
INNODB_HAVE_PUNCH_HOLE
INNODB_DEFRAGMENT_COMPRESSION_FAILURES
INNODB_DEFRAGMENT_FAILURES
INNODB_DEFRAGMENT_COUNT
INNODB_INSTANT_ALTER_COLUMN
INNODB_ONLINEDDL_ROWLOG_ROWS
INNODB_ONLINEDDL_ROWLOG_PCT_USED
INNODB_ONLINEDDL_PCT_PROGRESS
INNODB_SECONDARY_INDEX_TRIGGERED_CLUSTER_READS
INNODB_SECONDARY_INDEX_TRIGGERED_CLUSTER_READS_AVOIDED
INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_CACHE
INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_DISK
INNODB_ENCRYPTION_ROTATION_PAGES_MODIFIED
INNODB_ENCRYPTION_ROTATION_PAGES_FLUSHED
INNODB_ENCRYPTION_ROTATION_ESTIMATED_IOPS
INNODB_ENCRYPTION_KEY_ROTATION_LIST_LENGTH
INNODB_ENCRYPTION_N_MERGE_BLOCKS_ENCRYPTED
INNODB_ENCRYPTION_N_MERGE_BLOCKS_DECRYPTED
INNODB_ENCRYPTION_N_ROWLOG_BLOCKS_ENCRYPTED
INNODB_ENCRYPTION_N_ROWLOG_BLOCKS_DECRYPTED
INNODB_ENCRYPTION_N_TEMP_BLOCKS_ENCRYPTED
INNODB_ENCRYPTION_N_TEMP_BLOCKS_DECRYPTED
INNODB_ENCRYPTION_NUM_KEY_REQUESTS
|
