summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/r/innodb_status_variables.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_status_variables.result')
-rw-r--r--mysql-test/suite/innodb/r/innodb_status_variables.result113
1 files changed, 113 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_status_variables.result b/mysql-test/suite/innodb/r/innodb_status_variables.result
new file mode 100644
index 00000000..3a86271c
--- /dev/null
+++ b/mysql-test/suite/innodb/r/innodb_status_variables.result
@@ -0,0 +1,113 @@
+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_PAGES_SPLIT
+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_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_NUM_OPEN_FILES
+INNODB_TRUNCATED_STATUS_WRITES
+INNODB_AVAILABLE_UNDO_LOGS
+INNODB_UNDO_TRUNCATIONS
+INNODB_PAGE_COMPRESSION_SAVED
+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_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_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