mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
113 lines
3.3 KiB
Text
113 lines
3.3 KiB
Text
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_ASYNC_READS_PENDING
|
|
INNODB_ASYNC_READS_TASKS_RUNNING
|
|
INNODB_ASYNC_READS_TOTAL_COUNT
|
|
INNODB_ASYNC_READS_TOTAL_ENQUEUES
|
|
INNODB_ASYNC_READS_QUEUE_SIZE
|
|
INNODB_ASYNC_READS_WAIT_SLOT_SEC
|
|
INNODB_ASYNC_WRITES_PENDING
|
|
INNODB_ASYNC_WRITES_TASKS_RUNNING
|
|
INNODB_ASYNC_WRITES_TOTAL_COUNT
|
|
INNODB_ASYNC_WRITES_TOTAL_ENQUEUES
|
|
INNODB_ASYNC_WRITES_QUEUE_SIZE
|
|
INNODB_ASYNC_WRITES_WAIT_SLOT_SEC
|
|
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_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_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
|
|
INNODB_BULK_OPERATIONS
|