系统表介绍
INNODB_METRICS 提供了一个广泛的innodb 性能信息
| 列名 | 含义 |
|---|---|
| NAME | 名称 |
| SUBSYSTEM | 子系统 |
| COUNT | 数量 |
| MAX_COUNT | 计数器最大值 |
| MIN_COUNT | 计数器最小值 |
| AVG_COUNT | 计数器平均值 |
| COUNT_RESET | 最后一次重置后的值 |
| MAX_COUNT_RESET | 最后一次重置后的最大值 |
| MIN_COUNT_RESET | 最后一次重置后的最小值 |
| AVG_COUNT_RESET | 最后一次重置后的平均值 |
| TIME_ENABLED | 最后启用的时间 |
| TIME_DISABLED | 最后停止的时间 |
| TIME_ELAPSED | 计数器运行时间 |
| TIME_RESET | 最后一次重置的时间 |
| STATUS | 状态 |
| TYPE | 类型 |
| COMMENT | 注释 |
实例
mysql> select * from INNODB_METRICS ;
+------------------------------------------+---------------------+------------+------------+-----------+--------------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+----------+----------------+------------------------------------------------------------------------------------------------------------------+
| NAME | SUBSYSTEM | COUNT | MAX_COUNT | MIN_COUNT | AVG_COUNT | COUNT_RESET | MAX_COUNT_RESET | MIN_COUNT_RESET | AVG_COUNT_RESET | TIME_ENABLED | TIME_DISABLED | TIME_ELAPSED | TIME_RESET | STATUS | TYPE | COMMENT |
+------------------------------------------+---------------------+------------+------------+-----------+--------------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+----------+----------------+------------------------------------------------------------------------------------------------------------------+
| metadata_table_handles_opened | metadata | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table handles opened |
| metadata_table_handles_closed | metadata | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table handles closed |
| metadata_table_reference_count | metadata | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Table reference counter |
| lock_deadlocks | lock | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | counter | Number of deadlocks |
| lock_timeouts | lock | 0 | NULL | NULL | 0 | 0 | NULL | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | counter | Number of lock timeouts |
| lock_rec_lock_waits | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times enqueued into record lock wait queue |
| lock_table_lock_waits | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times enqueued into table lock wait queue |
| lock_rec_lock_requests | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of record locks requested |
| lock_rec_lock_created | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of record locks created |
| lock_rec_lock_removed | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of record locks removed from the lock queue |
| lock_rec_locks | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Current number of record locks on tables |
| lock_table_lock_created | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table locks created |
| lock_table_lock_removed | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of table locks removed from the lock queue |
| lock_table_locks | lock | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Current number of table locks on tables |
| lock_row_lock_current_waits | lock | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of row locks currently being waited for (innodb_row_lock_current_waits) |
| lock_row_lock_time | lock | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Time spent in acquiring row locks, in milliseconds (innodb_row_lock_time) |
| lock_row_lock_time_max | lock | 0 | 0 | 0 | NULL | 0 | 0 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | The maximum time to acquire a row lock, in milliseconds (innodb_row_lock_time_max) |
| lock_row_lock_waits | lock | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of times a row lock had to be waited for (innodb_row_lock_waits) |
| lock_row_lock_time_avg | lock | 0 | 0 | 0 | NULL | 0 | 0 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | The average time to acquire a row lock, in milliseconds (innodb_row_lock_time_avg) |
| buffer_pool_size | server | 134217728 | 134217728 | 134217728 | NULL | 134217728 | 134217728 | 134217728 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Server buffer pool size (all buffer pools) in bytes |
| buffer_pool_reads | buffer | 255 | 255 | NULL | 0.000020753971435210376 | 255 | 255 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of reads directly from disk (innodb_buffer_pool_reads) |
| buffer_pool_read_requests | buffer | 26392444 | 26392444 | NULL | 2.14803148580937 | 26392444 | 26392444 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of logical read requests (innodb_buffer_pool_read_requests) |
| buffer_pool_write_requests | buffer | 9439266 | 9439266 | NULL | 0.7682441448366765 | 9439266 | 9439266 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of write requests (innodb_buffer_pool_write_requests) |
| buffer_pool_wait_free | buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of times waited for free buffer (innodb_buffer_pool_wait_free) |
| buffer_pool_read_ahead | buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pages read as read ahead (innodb_buffer_pool_read_ahead) |
| buffer_pool_read_ahead_evicted | buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Read-ahead pages evicted without being accessed (innodb_buffer_pool_read_ahead_evicted) |
| buffer_pool_pages_total | buffer | 8192 | 8192 | 8192 | NULL | 8192 | 8192 | 8192 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Total buffer pool size in pages (innodb_buffer_pool_pages_total) |
| buffer_pool_pages_misc | buffer | 3 | 3 | 3 | NULL | 3 | 3 | 3 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Buffer pages for misc use such as row locks or the adaptive hash index (innodb_buffer_pool_pages_misc) |
| buffer_pool_pages_data | buffer | 6088 | 6088 | 5990 | NULL | 6088 | 6088 | 5990 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Buffer pages containing data (innodb_buffer_pool_pages_data) |
| buffer_pool_bytes_data | buffer | 99745792 | 99745792 | 98140160 | NULL | 99745792 | 99745792 | 98140160 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Buffer bytes containing data (innodb_buffer_pool_bytes_data) |
| buffer_pool_pages_dirty | buffer | 0 | 4 | 0 | NULL | 0 | 4 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Buffer pages currently dirty (innodb_buffer_pool_pages_dirty) |
| buffer_pool_bytes_dirty | buffer | 0 | 65536 | 0 | NULL | 0 | 65536 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Buffer bytes currently dirty (innodb_buffer_pool_bytes_dirty) |
| buffer_pool_pages_free | buffer | 2101 | 2199 | 2101 | NULL | 2101 | 2199 | 2101 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Buffer pages currently free (innodb_buffer_pool_pages_free) |
| buffer_pages_created | buffer | 5834 | 5834 | NULL | 0.0004748183111883032 | 5834 | 5834 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pages created (innodb_pages_created) |
| buffer_pages_written | buffer | 21897 | 21897 | NULL | 0.001782155735360006 | 21897 | 21897 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pages written (innodb_pages_written) |
| buffer_pages_read | buffer | 254 | 254 | NULL | 0.00002067258331193504 | 254 | 254 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pages read (innodb_pages_read) |
| buffer_data_reads | buffer | 4248064 | 4248064 | NULL | 0.34574195651351186 | 4248064 | 4248064 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Amount of data read in bytes (innodb_data_reads) |
| buffer_data_written | buffer | 1000225792 | 1000225792 | NULL | 81.40650006246538 | 1000225792 | 1000225792 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Amount of data written in bytes (innodb_data_written) |
| buffer_flush_batch_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of flush batch |
| buffer_flush_batch_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times buffer flush list flush is called |
| buffer_flush_batch_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages scanned per flush batch scan |
| buffer_flush_batch_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of flush batch |
| buffer_flush_batches | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of flush batches |
| buffer_flush_batch_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a flush batch |
| buffer_flush_neighbor_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total neighbors flushed as part of neighbor flush |
| buffer_flush_neighbor | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times neighbors flushing is invoked |
| buffer_flush_neighbor_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a neighbor batch |
| buffer_flush_n_to_flush_requested | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of pages requested for flushing. |
| buffer_flush_n_to_flush_by_age | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of pages target by LSN Age for flushing. |
| buffer_flush_adaptive_avg_time_slot | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Avg time (ms) spent for adaptive flushing recently per slot. |
| buffer_LRU_batch_flush_avg_time_slot | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Avg time (ms) spent for LRU batch flushing recently per slot. |
| buffer_flush_adaptive_avg_time_thread | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Avg time (ms) spent for adaptive flushing recently per thread. |
| buffer_LRU_batch_flush_avg_time_thread | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Avg time (ms) spent for LRU batch flushing recently per thread. |
| buffer_flush_adaptive_avg_time_est | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Estimated time (ms) spent for adaptive flushing recently. |
| buffer_LRU_batch_flush_avg_time_est | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Estimated time (ms) spent for LRU batch flushing recently. |
| buffer_flush_avg_time | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Avg time (ms) spent for flushing recently. |
| buffer_flush_adaptive_avg_pass | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Numner of adaptive flushes passed during the recent Avg period. |
| buffer_LRU_batch_flush_avg_pass | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of LRU batch flushes passed during the recent Avg period. |
| buffer_flush_avg_pass | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of flushes passed during the recent Avg period. |
| buffer_LRU_get_free_loops | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Total loops in LRU get free. |
| buffer_LRU_get_free_waits | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Total sleep waits in LRU get free. |
| buffer_flush_avg_page_rate | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Average number of pages at which flushing is happening |
| buffer_flush_lsn_avg_rate | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Average redo generation rate |
| buffer_flush_pct_for_dirty | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Percent of IO capacity used to avoid max dirty page limit |
| buffer_flush_pct_for_lsn | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Percent of IO capacity used to avoid reusable redo space limit |
| buffer_flush_sync_waits | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times a wait happens due to sync flushing |
| buffer_flush_adaptive_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of adaptive flushing |
| buffer_flush_adaptive | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of adaptive batches |
| buffer_flush_adaptive_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as an adaptive batch |
| buffer_flush_sync_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of sync batches |
| buffer_flush_sync | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of sync batches |
| buffer_flush_sync_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a sync batch |
| buffer_flush_background_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of background batches |
| buffer_flush_background | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of background batches |
| buffer_flush_background_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as a background batch |
| buffer_LRU_batch_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of LRU batch |
| buffer_LRU_batch_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times LRU batch is called |
| buffer_LRU_batch_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages scanned per LRU batch call |
| buffer_LRU_batch_flush_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages flushed as part of LRU batches |
| buffer_LRU_batches_flush | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of LRU batches |
| buffer_LRU_batch_flush_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as an LRU batch |
| buffer_LRU_batch_evict_total_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages evicted as part of LRU batches |
| buffer_LRU_batches_evict | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of LRU batches |
| buffer_LRU_batch_evict_pages | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Pages queued as an LRU batch |
| buffer_LRU_single_flush_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of single page LRU flush |
| buffer_LRU_single_flush_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times single page LRU flush is called |
| buffer_LRU_single_flush_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Page scanned per single LRU flush |
| buffer_LRU_single_flush_failure_count | Buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times attempt to flush a single page from LRU failed |
| buffer_LRU_get_free_search | Buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of searches performed for a clean page |
| buffer_LRU_search_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of LRU search |
| buffer_LRU_search_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times LRU search is performed |
| buffer_LRU_search_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Page scanned per single LRU search |
| buffer_LRU_unzip_search_scanned | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_owner | Total pages scanned as part of LRU unzip search |
| buffer_LRU_unzip_search_num_scan | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Number of times LRU unzip search is performed |
| buffer_LRU_unzip_search_scanned_per_call | buffer | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | set_member | Page scanned per single LRU unzip search |
| buffer_page_read_index_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Leaf Pages read |
| buffer_page_read_index_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Non-leaf Pages read |
| buffer_page_read_index_ibuf_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Leaf Pages read |
| buffer_page_read_index_ibuf_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Non-Leaf Pages read |
| buffer_page_read_undo_log | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Undo Log Pages read |
| buffer_page_read_index_inode | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Inode Pages read |
| buffer_page_read_ibuf_free_list | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Free List Pages read |
| buffer_page_read_ibuf_bitmap | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Bitmap Pages read |
| buffer_page_read_system_page | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of System Pages read |
| buffer_page_read_trx_system | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Transaction System Pages read |
| buffer_page_read_fsp_hdr | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of File Space Header Pages read |
| buffer_page_read_xdes | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Extent Descriptor Pages read |
| buffer_page_read_blob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Uncompressed BLOB Pages read |
| buffer_page_read_zblob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of First Compressed BLOB Pages read |
| buffer_page_read_zblob2 | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Subsequent Compressed BLOB Pages read |
| buffer_page_read_other | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of other/unknown (old version of InnoDB) Pages read |
| buffer_page_written_index_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Leaf Pages written |
| buffer_page_written_index_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Non-leaf Pages written |
| buffer_page_written_index_ibuf_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Leaf Pages written |
| buffer_page_written_index_ibuf_non_leaf | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Index Non-Leaf Pages written |
| buffer_page_written_undo_log | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Undo Log Pages written |
| buffer_page_written_index_inode | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Index Inode Pages written |
| buffer_page_written_ibuf_free_list | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Free List Pages written |
| buffer_page_written_ibuf_bitmap | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Insert Buffer Bitmap Pages written |
| buffer_page_written_system_page | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of System Pages written |
| buffer_page_written_trx_system | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Transaction System Pages written |
| buffer_page_written_fsp_hdr | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of File Space Header Pages written |
| buffer_page_written_xdes | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Extent Descriptor Pages written |
| buffer_page_written_blob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Uncompressed BLOB Pages written |
| buffer_page_written_zblob | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of First Compressed BLOB Pages written |
| buffer_page_written_zblob2 | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Subsequent Compressed BLOB Pages written |
| buffer_page_written_other | buffer_page_io | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of other/unknown (old version InnoDB) Pages written |
| os_data_reads | os | 287 | 287 | NULL | 0.000023358391380021086 | 287 | 287 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of reads initiated (innodb_data_reads) |
| os_data_writes | os | 23275 | 23275 | NULL | 0.0018943085692334175 | 23275 | 23275 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of writes initiated (innodb_data_writes) |
| os_data_fsyncs | os | 1561 | 1561 | NULL | 0.00012704686043279762 | 1561 | 1561 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of fsync() calls (innodb_data_fsyncs) |
| os_pending_reads | os | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of reads pending |
| os_pending_writes | os | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of writes pending |
| os_log_bytes_written | os | 347810816 | 347810816 | NULL | 28.30766956910279 | 347810816 | 347810816 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Bytes of log written (innodb_os_log_written) |
| os_log_fsyncs | os | 628 | 628 | NULL | 0.00005111174141691025 | 628 | 628 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of fsync log writes (innodb_os_log_fsyncs) |
| os_log_pending_fsyncs | os | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pending fsync write (innodb_os_log_pending_fsyncs) |
| os_log_pending_writes | os | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pending log file writes (innodb_os_log_pending_writes) |
| trx_rw_commits | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of read-write transactions committed |
| trx_ro_commits | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of read-only transactions committed |
| trx_nl_ro_commits | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of non-locking auto-commit read-only transactions committed |
| trx_commits_insert_update | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of transactions committed with inserts and updates |
| trx_rollbacks | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of transactions rolled back |
| trx_rollbacks_savepoint | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of transactions rolled back to savepoint |
| trx_rollback_active | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of resurrected active transactions rolled back |
| trx_active_transactions | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of active transactions |
| trx_rseg_history_len | transaction | 0 | 0 | 0 | NULL | 0 | 0 | 0 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Length of the TRX_RSEG_HISTORY list |
| trx_undo_slots_used | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of undo slots used |
| trx_undo_slots_cached | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of undo slots cached |
| trx_rseg_current_size | transaction | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Current rollback segment size in pages |
| purge_del_mark_records | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of delete-marked rows purged |
| purge_upd_exist_or_extern_records | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of purges on updates of existing records and updates on delete marked record with externally stored field |
| purge_invoked | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times purge was invoked |
| purge_undo_log_pages | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of undo log pages handled by the purge |
| purge_dml_delay_usec | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Microseconds DML to be delayed due to purge lagging |
| purge_stop_count | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of times purge was stopped |
| purge_resume_count | purge | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Number of times purge was resumed |
| log_checkpoints | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of checkpoints |
| log_lsn_last_flush | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | LSN of Last flush |
| log_lsn_last_checkpoint | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | LSN at last checkpoint |
| log_lsn_current | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Current LSN value |
| log_lsn_checkpoint_age | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Current LSN value minus LSN at last checkpoint |
| log_lsn_buf_pool_oldest | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | The oldest modified block LSN in the buffer pool |
| log_max_modified_age_async | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Maximum LSN difference; when exceeded, start asynchronous preflush |
| log_max_modified_age_sync | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | value | Maximum LSN difference; when exceeded, start synchronous preflush |
| log_pending_log_flushes | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Pending log flushes |
| log_pending_checkpoint_writes | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Pending checkpoints |
| log_num_log_io | recovery | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of log I/Os |
| log_waits | recovery | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of log waits due to small log buffer (innodb_log_waits) |
| log_write_requests | recovery | 771115 | 771115 | NULL | 0.06275960267945979 | 771115 | 771115 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of log write requests (innodb_log_write_requests) |
| log_writes | recovery | 506 | 506 | NULL | 0.00004118239037731941 | 506 | 506 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of log writes (innodb_log_writes) |
| log_padded | recovery | 686080 | 686080 | NULL | 0.0558387636167417 | 686080 | 686080 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Bytes of log padded for log write ahead |
| compress_pages_compressed | compression | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of pages compressed |
| compress_pages_decompressed | compression | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of pages decompressed |
| compression_pad_increments | compression | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times padding is incremented to avoid compression failures |
| compression_pad_decrements | compression | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times padding is decremented due to good compressibility |
| index_page_splits | index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of index page splits |
| index_page_merge_attempts | index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of index page merge attempts |
| index_page_merge_successful | index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of successful index page merges |
| index_page_reorg_attempts | index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of index page reorganization attempts |
| index_page_reorg_successful | index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of successful index page reorganizations |
| index_page_discards | index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of index pages discarded |
| adaptive_hash_searches | adaptive_hash_index | 2968348 | 2968348 | NULL | 0.2415882729480935 | 2968348 | 2968348 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of successful searches using Adaptive Hash Index |
| adaptive_hash_searches_btree | adaptive_hash_index | 681931 | 681931 | NULL | 0.055501084293272336 | 681931 | 681931 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of searches using B-tree on an index search |
| adaptive_hash_pages_added | adaptive_hash_index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of index pages on which the Adaptive Hash Index is built |
| adaptive_hash_pages_removed | adaptive_hash_index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of index pages whose corresponding Adaptive Hash Index entries were removed |
| adaptive_hash_rows_added | adaptive_hash_index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Adaptive Hash Index rows added |
| adaptive_hash_rows_removed | adaptive_hash_index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Adaptive Hash Index rows removed |
| adaptive_hash_rows_deleted_no_hash_entry | adaptive_hash_index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of rows deleted that did not have corresponding Adaptive Hash Index entries |
| adaptive_hash_rows_updated | adaptive_hash_index | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of Adaptive Hash Index rows updated |
| file_num_open_files | file_system | 40 | 40 | 28 | NULL | 40 | 40 | 28 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | Number of files currently open (innodb_num_open_files) |
| ibuf_merges_insert | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of inserted records merged by change buffering |
| ibuf_merges_delete_mark | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of deleted records merged by change buffering |
| ibuf_merges_delete | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of purge records merged by change buffering |
| ibuf_merges_discard_insert | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of insert merged operations discarded |
| ibuf_merges_discard_delete_mark | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of deleted merged operations discarded |
| ibuf_merges_discard_delete | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of purge merged operations discarded |
| ibuf_merges | change_buffer | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of change buffer merges |
| ibuf_size | change_buffer | 1 | 1 | NULL | 0.0000000813881232753348 | 1 | 1 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Change buffer size in pages |
| innodb_master_thread_sleeps | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times (seconds) master thread sleeps |
| innodb_activity_count | server | 104685 | 104685 | NULL | 0.008520115685078423 | 104685 | 104685 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Current server activity count |
| innodb_master_active_loops | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times master thread performs its tasks when server is active |
| innodb_master_idle_loops | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of times master thread performs its tasks when server is idle |
| innodb_background_drop_table_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent to process drop table list |
| innodb_ibuf_merge_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent to process change buffer merge |
| innodb_log_flush_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent to flush log records |
| innodb_mem_validate_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent to do memory validation |
| innodb_master_purge_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent by master thread to purge records |
| innodb_dict_lru_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent to process DICT LRU list |
| innodb_dict_lru_count | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of tables evicted from DICT LRU list |
| innodb_checkpoint_usec | server | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Time (in microseconds) spent by master thread to do checkpoint |
| innodb_dblwr_writes | server | 250 | 250 | NULL | 0.0000203470308188337 | 250 | 250 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of doublewrite operations that have been performed (innodb_dblwr_writes) |
| innodb_dblwr_pages_written | server | 17919 | 17919 | NULL | 0.0014583937809707244 | 17919 | 17919 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of pages that have been written for doublewrite operations (innodb_dblwr_pages_written) |
| innodb_page_size | server | 16384 | 16384 | 16384 | NULL | 16384 | 16384 | 16384 | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | value | InnoDB page size in bytes (innodb_page_size) |
| innodb_rwlock_s_spin_waits | server | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rwlock spin waits due to shared latch request |
| innodb_rwlock_x_spin_waits | server | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rwlock spin waits due to exclusive latch request |
| innodb_rwlock_sx_spin_waits | server | 286 | 286 | NULL | 0.00002327700325674575 | 286 | 286 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rwlock spin waits due to sx latch request |
| innodb_rwlock_s_spin_rounds | server | 897 | 897 | NULL | 0.00007300514657797531 | 897 | 897 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rwlock spin loop rounds due to shared latch request |
| innodb_rwlock_x_spin_rounds | server | 7053 | 7053 | NULL | 0.0005740304334609363 | 7053 | 7053 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rwlock spin loop rounds due to exclusive latch request |
| innodb_rwlock_sx_spin_rounds | server | 8580 | 8580 | NULL | 0.0006983100977023726 | 8580 | 8580 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rwlock spin loop rounds due to sx latch request |
| innodb_rwlock_s_os_waits | server | 423 | 423 | NULL | 0.00003442717614546662 | 423 | 423 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of OS waits due to shared latch request |
| innodb_rwlock_x_os_waits | server | 217 | 217 | NULL | 0.000017661222750747652 | 217 | 217 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of OS waits due to exclusive latch request |
| innodb_rwlock_sx_os_waits | server | 231 | 231 | NULL | 0.00001880065647660234 | 231 | 231 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of OS waits due to sx latch request |
| dml_reads | dml | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | status_counter | Number of rows read |
| dml_inserts | dml | 2688460 | 2688460 | NULL | 0.21880871390080658 | 2688460 | 2688460 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rows inserted |
| dml_deletes | dml | 1443783 | 1443783 | NULL | 0.1175067887868327 | 1443783 | 1443783 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rows deleted |
| dml_updates | dml | 0 | 0 | NULL | 0 | 0 | 0 | NULL | NULL | 2021-03-15 05:59:45 | NULL | 12286805 | NULL | enabled | status_counter | Number of rows updated |
| ddl_background_drop_indexes | ddl | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of indexes waiting to be dropped after failed index creation |
| ddl_background_drop_tables | ddl | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of tables in background drop table list |
| ddl_online_create_index | ddl | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of indexes being created online |
| ddl_pending_alter_table | ddl | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of ALTER TABLE, CREATE INDEX, DROP INDEX in progress |
| ddl_sort_file_alter_table | ddl | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of sort files created during alter table |
| ddl_log_file_alter_table | ddl | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of log files created during alter table |
| icp_attempts | icp | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Number of attempts for index push-down condition checks |
| icp_no_match | icp | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Index push-down condition does not match |
| icp_out_of_range | icp | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Index push-down condition out of range |
| icp_match | icp | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | disabled | counter | Index push-down condition matches |
+------------------------------------------+---------------------+------------+------------+-----------+--------------------------+-------------+-----------------+-----------------+-----------------+---------------------+---------------+--------------+------------+----------+----------------+------------------------------------------------------------------------------------------------------------------+
235 rows in set (0.00 sec)