| 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 |