See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.
Much of the InnoDB/XtraDB information here can also be seen with a SHOW ENGINE INNODB STATUS statement.
See also the Full list of MariaDB options, system and status variables.
Innodb_adaptive_hash_cells
numeric
Innodb_adaptive_hash_hash_searches
numeric
Innodb_adaptive_hash_heap_buffers
numeric
Innodb_adaptive_hash_non_hash_searches
numeric
Innodb_available_undo_logs
numeric
Innodb_background_log_sync
numeric
Innodb_buffer_pool_bytes_data
numeric
Innodb_buffer_pool_bytes_dirty
numeric
Innodb_buffer_pool_dump_status
string
Innodb_buffer_pool_load_incomplete
boolean
Innodb_buffer_pool_load_status
string
Innodb_buffer_pool_pages_data
numeric
Innodb_buffer_pool_pages_dirty
numeric
Innodb_buffer_pool_pages_flushed
numeric
Innodb_buffer_pool_pages_LRU_flushed
numeric
Innodb_buffer_pool_pages_free
numeric
Innodb_buffer_pool_pages_made_not_young
numeric
Innodb_buffer_pool_pages_made_young
numeric
Innodb_buffer_pool_pages_misc
numeric
Innodb_buffer_pool_pages_old
numeric
Innodb_buffer_pool_pages_total
numeric
Innodb_buffer_pool_read_ahead
numeric
Innodb_buffer_pool_read_ahead_evicted
numeric
Innodb_buffer_pool_read_ahead_rnd
numeric
Innodb_buffer_pool_read_requests
numeric
Innodb_buffer_pool_reads
numeric
Innodb_buffer_pool_resize_status
numeric
Innodb_buffer_pool_wait_free
numeric
Innodb_buffer_pool_write_requests
numeric
Innodb_checkpoint_age
numeric
Innodb_checkpoint_max_age
numeric
Innodb_checkpoint_target_age
numeric
Innodb_current_row_locks
numeric
Innodb_data_fsyncs
numeric
Innodb_data_pending_fsyncs
numeric
Innodb_data_pending_reads
numeric
Innodb_data_pending_writes
numeric
Innodb_data_read
numeric
Innodb_data_reads
numeric
Innodb_data_writes
numeric
Innodb_data_written
numeric
Innodb_dblwr_pages_written
numeric
Innodb_dblwr_writes
numeric
Innodb_deadlocks
numeric
Innodb_defragment_compression_failures
numeric
Innodb_defragment_count
numeric
Innodb_defragment_failures
numeric
Innodb_dict_tables
numeric
Innodb_encryption_n_merge_blocks_decrypted
numeric
Innodb_encryption_n_merge_blocks_encrypted
numeric
Innodb_encryption_n_rowlog_blocks_decrypted
numeric
Innodb_encryption_n_rowlog_blocks_encrypted
numeric
Innodb_encryption_num_key_requests
numeric
Innodb_encryption_rotation_estimated_iops
numeric
Innodb_encryption_rotation_pages_flushed
numeric
Innodb_encryption_rotation_pages_modified
numeric
Innodb_encryption_rotation_pages_read_from_cache
numeric
Innodb_encryption_rotation_pages_read_from_disk
numeric
Innodb_have_atomic_builtins
boolean
Innodb_have_bzip2
boolean
Innodb_have_lz4
boolean
Innodb_have_lzma
boolean
Innodb_have_lzo
boolean
Innodb_have_punch_hole
numeric
Innodb_have_snappy
boolean
Innodb_history_list_length
numeric
Innodb_ibuf_discarded_delete_marks
numeric
Innodb_ibuf_discarded_deletes
numeric
Innodb_ibuf_discarded_inserts
numeric
Innodb_ibuf_free_list
numeric
Innodb_ibuf_merged_delete_marks
numeric
Innodb_ibuf_merged_deletes
numeric
Innodb_ibuf_merged_inserts
numeric
Innodb_ibuf_merges
numeric
Innodb_ibuf_segment_size
numeric
Innodb_ibuf_size
numeric
Innodb_instant_alter_column
numeric
Innodb_log_waits
numeric
Innodb_log_write_requests
numeric
Innodb_log_writes
numeric
Innodb_lsn_current
numeric
Innodb_lsn_flushed
numeric
Innodb_lsn_last_checkpoint
numeric
Innodb_master_thread_1_second_loops
numeric
Innodb_master_thread_10_second_loops
numeric
Innodb_master_thread_active_loops
numeric
Innodb_master_thread_background_loops
numeric
Innodb_master_thread_idle_loops
numeric
Innodb_master_thread_main_flush_loops
numeric
Innodb_master_thread_sleeps
numeric
Innodb_max_trx_id
numeric
Innodb_mem_adaptive_hash
numeric
Innodb_mem_dictionary
numeric
Innodb_mem_total
numeric
Innodb_mutex_os_waits
numeric
Innodb_mutex_spin_rounds
numeric
Innodb_mutex_spin_waits
numeric
Innodb_num_index_pages_written
numeric
Innodb_num_non_index_pages_written
numeric
Innodb_num_open_files
numeric
Innodb_num_page_compressed_trim_op
numeric
Innodb_num_page_compressed_trim_op_saved
numeric
Innodb_num_pages_decrypted
Innodb_num_pages_page_decrypted
in MariaDB 10.1.3, renamed to its current name in MariaDB 10.1.4. numeric
Innodb_num_pages_encrypted
Innodb_num_pages_page_encrypted
in MariaDB 10.1.3, renamed to its current name in MariaDB 10.1.4. numeric
Innodb_num_pages_page_compressed
numeric
Innodb_num_pages_page_compression_error
numeric
Innodb_num_pages_page_decompressed
numeric
Innodb_num_pages_page_encryption_error
numeric
Innodb_oldest_view_low_limit_trx_id
numeric
Innodb_onlineddl_pct_progress
numeric
Innodb_onlineddl_rowlog_pct_used
numeric
Innodb_onlineddl_rowlog_rows
numeric
Innodb_os_log_fsyncs
numeric
Innodb_os_log_pending_fsyncs
numeric
Innodb_os_log_pending_writes
numeric
Innodb_os_log_written
numeric
Innodb_page_compression_saved
Innodb_page_compression_trim_sect512
numeric
Innodb_page_compression_trim_sect1024
numeric
Innodb_page_compression_trim_sect2048
numeric
Innodb_page_compression_trim_sect4096
numeric
Innodb_page_compression_trim_sect8192
numeric
Innodb_page_compression_trim_sect16384
numeric
Innodb_page_compression_trim_sect32768
numeric
Innodb_page_size
numeric
Innodb_pages_created
numeric
Innodb_pages_read
numeric
Innodb_pages0_read
numeric
Innodb_pages_written
numeric
Innodb_purge_trx_id
numeric
Innodb_purge_undo_no
numeric
Innodb_read_views_memory
numeric
Innodb_row_lock_current_waits
numeric
Innodb_row_lock_numbers
numeric
Innodb_row_lock_time
numeric
Innodb_row_lock_time_avg
numeric
Innodb_row_lock_time_max
numeric
Innodb_row_lock_time_waits
numeric
Innodb_rows_deleted
numeric
Innodb_rows_inserted
numeric
Innodb_rows_read
numeric
Innodb_rows_updated
numeric
Innodb_s_lock_os_waits
numeric
Innodb_s_lock_spin_rounds
numeric
Innodb_s_lock_spin_waits
numeric
Innodb_scrub_background_page_reorganizations
numeric
Innodb_scrub_background_page_split_failures_missing_index
numeric
Innodb_scrub_background_page_split_failures_out_of_filespace
numeric
Innodb_scrub_background_page_split_failures_underflow
numeric
Innodb_scrub_background_page_split_failures_unknown
numeric
MariaDB 10.2.5
, MariaDB 10.1.3
Innodb_scrub_background_page_splits
numeric
Innodb_scrub_log
numeric
Innodb_secondary_index_triggered_cluster_reads
numeric
Innodb_secondary_index_triggered_cluster_reads_avoided
numeric
Innodb_system_rows_deleted
numeric
Innodb_system_rows_inserted
numeric
Innodb_system_rows_read
numeric
Innodb_system_rows_updated
numeric
Innodb_truncated_status_writes
numeric
Innodb_undo_truncations
numeric
Innodb_x_lock_os_waits
numeric
Innodb_x_lock_spin_rounds
numeric
Innodb_x_lock_spin_waits
numeric
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/xtradbinnodb-server-status-variables/