Debian Codegraph @

mysql-test/suite/innodb/r/innodb_status_variables.result

raw
1 SELECT variable_name FROM information_schema.global_status
2 WHERE variable_name LIKE 'INNODB_%'
3 AND variable_name NOT IN
4 ('INNODB_ADAPTIVE_HASH_HASH_SEARCHES','INNODB_ADAPTIVE_HASH_NON_HASH_SEARCHES',
5 'INNODB_MEM_ADAPTIVE_HASH',
6 'INNODB_BUFFERED_AIO_SUBMITTED','INNODB_BUFFER_POOL_PAGES_LATCHED');
7 variable_name
8 INNODB_ASYNC_READS_PENDING
9 INNODB_ASYNC_READS_TASKS_RUNNING
10 INNODB_ASYNC_READS_TOTAL_COUNT
11 INNODB_ASYNC_READS_TOTAL_ENQUEUES
12 INNODB_ASYNC_READS_QUEUE_SIZE
13 INNODB_ASYNC_READS_WAIT_SLOT_SEC
14 INNODB_ASYNC_WRITES_PENDING
15 INNODB_ASYNC_WRITES_TASKS_RUNNING
16 INNODB_ASYNC_WRITES_TOTAL_COUNT
17 INNODB_ASYNC_WRITES_TOTAL_ENQUEUES
18 INNODB_ASYNC_WRITES_QUEUE_SIZE
19 INNODB_ASYNC_WRITES_WAIT_SLOT_SEC
20 INNODB_BACKGROUND_LOG_SYNC
21 INNODB_BUFFER_POOL_DUMP_STATUS
22 INNODB_BUFFER_POOL_LOAD_STATUS
23 INNODB_BUFFER_POOL_RESIZE_STATUS
24 INNODB_BUFFER_POOL_LOAD_INCOMPLETE
25 INNODB_BUFFER_POOL_PAGES_DATA
26 INNODB_BUFFER_POOL_BYTES_DATA
27 INNODB_BUFFER_POOL_PAGES_DIRTY
28 INNODB_BUFFER_POOL_BYTES_DIRTY
29 INNODB_BUFFER_POOL_PAGES_FLUSHED
30 INNODB_BUFFER_POOL_PAGES_FREE
31 INNODB_BUFFER_POOL_PAGES_MADE_NOT_YOUNG
32 INNODB_BUFFER_POOL_PAGES_MADE_YOUNG
33 INNODB_BUFFER_POOL_PAGES_MISC
34 INNODB_BUFFER_POOL_PAGES_OLD
35 INNODB_BUFFER_POOL_PAGES_TOTAL
36 INNODB_BUFFER_POOL_PAGES_LRU_FLUSHED
37 INNODB_BUFFER_POOL_PAGES_LRU_FREED
38 INNODB_BUFFER_POOL_PAGES_SPLIT
39 INNODB_BUFFER_POOL_READ_AHEAD_RND
40 INNODB_BUFFER_POOL_READ_AHEAD
41 INNODB_BUFFER_POOL_READ_AHEAD_EVICTED
42 INNODB_BUFFER_POOL_READ_REQUESTS
43 INNODB_BUFFER_POOL_READS
44 INNODB_BUFFER_POOL_WAIT_FREE
45 INNODB_BUFFER_POOL_WRITE_REQUESTS
46 INNODB_CHECKPOINT_AGE
47 INNODB_CHECKPOINT_MAX_AGE
48 INNODB_DATA_FSYNCS
49 INNODB_DATA_PENDING_FSYNCS
50 INNODB_DATA_PENDING_READS
51 INNODB_DATA_PENDING_WRITES
52 INNODB_DATA_READ
53 INNODB_DATA_READS
54 INNODB_DATA_WRITES
55 INNODB_DATA_WRITTEN
56 INNODB_DBLWR_PAGES_WRITTEN
57 INNODB_DBLWR_WRITES
58 INNODB_DEADLOCKS
59 INNODB_HISTORY_LIST_LENGTH
60 INNODB_LOG_WAITS
61 INNODB_LOG_WRITE_REQUESTS
62 INNODB_LOG_WRITES
63 INNODB_LSN_CURRENT
64 INNODB_LSN_FLUSHED
65 INNODB_LSN_LAST_CHECKPOINT
66 INNODB_MASTER_THREAD_ACTIVE_LOOPS
67 INNODB_MASTER_THREAD_IDLE_LOOPS
68 INNODB_MAX_TRX_ID
69 INNODB_MEM_DICTIONARY
70 INNODB_OS_LOG_WRITTEN
71 INNODB_PAGE_SIZE
72 INNODB_PAGES_CREATED
73 INNODB_PAGES_READ
74 INNODB_PAGES_WRITTEN
75 INNODB_ROW_LOCK_CURRENT_WAITS
76 INNODB_ROW_LOCK_TIME
77 INNODB_ROW_LOCK_TIME_AVG
78 INNODB_ROW_LOCK_TIME_MAX
79 INNODB_ROW_LOCK_WAITS
80 INNODB_NUM_OPEN_FILES
81 INNODB_TRUNCATED_STATUS_WRITES
82 INNODB_AVAILABLE_UNDO_LOGS
83 INNODB_UNDO_TRUNCATIONS
84 INNODB_PAGE_COMPRESSION_SAVED
85 INNODB_NUM_PAGES_PAGE_COMPRESSED
86 INNODB_NUM_PAGE_COMPRESSED_TRIM_OP
87 INNODB_NUM_PAGES_PAGE_DECOMPRESSED
88 INNODB_NUM_PAGES_PAGE_COMPRESSION_ERROR
89 INNODB_NUM_PAGES_ENCRYPTED
90 INNODB_NUM_PAGES_DECRYPTED
91 INNODB_HAVE_LZ4
92 INNODB_HAVE_LZO
93 INNODB_HAVE_LZMA
94 INNODB_HAVE_BZIP2
95 INNODB_HAVE_SNAPPY
96 INNODB_HAVE_PUNCH_HOLE
97 INNODB_INSTANT_ALTER_COLUMN
98 INNODB_ONLINEDDL_ROWLOG_ROWS
99 INNODB_ONLINEDDL_ROWLOG_PCT_USED
100 INNODB_ONLINEDDL_PCT_PROGRESS
101 INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_CACHE
102 INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_DISK
103 INNODB_ENCRYPTION_ROTATION_PAGES_MODIFIED
104 INNODB_ENCRYPTION_ROTATION_PAGES_FLUSHED
105 INNODB_ENCRYPTION_ROTATION_ESTIMATED_IOPS
106 INNODB_ENCRYPTION_N_MERGE_BLOCKS_ENCRYPTED
107 INNODB_ENCRYPTION_N_MERGE_BLOCKS_DECRYPTED
108 INNODB_ENCRYPTION_N_ROWLOG_BLOCKS_ENCRYPTED
109 INNODB_ENCRYPTION_N_ROWLOG_BLOCKS_DECRYPTED
110 INNODB_ENCRYPTION_N_TEMP_BLOCKS_ENCRYPTED
111 INNODB_ENCRYPTION_N_TEMP_BLOCKS_DECRYPTED
112 INNODB_ENCRYPTION_NUM_KEY_REQUESTS
113 INNODB_BULK_OPERATIONS