Server Status Variables
Contents
- List of Server Status Variables
- Aborted_clients
- Aborted_connects
- Aborted_connects_preauth
- Access_denied_errors
- Acl_column_grants
- Acl_database_grants
- Acl_function_grants
- Acl_package_body_grants
- Acl_package_spec_grants
- Acl_procedure_grants
- Acl_proxy_users
- Acl_role_grants
- Acl_roles
- Acl_table_grants
- Acl_users
- Aria_pagecache_blocks_not_flushed
- Aria_pagecache_blocks_unused
- Aria_pagecache_blocks_used
- Aria_pagecache_read_requests
- Aria_pagecache_reads
- Aria_pagecache_write_requests
- Aria_pagecache_writes
- Aria_transaction_log_syncs
- Binlog_bytes_written
- Binlog_cache_disk_use
- Binlog_commits
- Binlog_group_commit_trigger_count
- Binlog_group_commit_trigger_lock_wait
- Binlog_group_commit_trigger_timeout
- Binlog_group_commits
- Binlog_snapshot_file
- Binlog_snapshot_position
- Binlog_stmt_cache_disk_use
- Binlog_stmt_cache_use
- Busy_time
- Bytes_received
- Bytes_sent
- Cassandra_multiget_keys_scanned
- Cassandra_multiget_reads
- Cassandra_multiget_rows_read
- Cassandra_row_inserts
- Cassandra_row_insert_batches
- Cassandra_timeout_exceptions
- Cassandra_unavailable_exceptions
- Column_compressions
- Column_decompressions
- Com_admin_commands
- Com_alter_db
- Com_alter_db_upgrade
- Com_alter_event
- Com_alter_function
- Com_alter_procedure
- Com_alter_sequence
- Com_alter_server
- Com_alter_table
- Com_alter_tablespace
- Com_alter_user
- Com_analyze
- Com_assign_to_keycache
- Com_backup
- Com_backup_lock
- Com_backup_table
- Com_begin
- Com_binlog
- Com_call_procedure
- Com_change_db
- Com_change_master
- Com_check
- Com_checksum
- Com_commit
- Com_compound_sql
- Com_create_db
- Com_create_event
- Com_create_function
- Com_create_index
- Com_create_package
- Com_create_package_body
- Com_create_procedure
- Com_create_role
- Com_create_sequence
- Com_create_server
- Com_create_table
- Com_create_temporary_table
- Com_create_trigger
- Com_create_udf
- Com_create_user
- Com_create_view
- Com_dealloc_sql
- Com_delete
- Com_delete_multi
- Com_do
- Com_drop_db
- Com_drop_event
- Com_drop_function
- Com_drop_index
- Com_drop_package
- Com_drop_package_body
- Com_drop_procedure
- Com_drop_role
- Com_drop_sequence
- Com_drop_server
- Com_drop_table
- Com_drop_temporary_table
- Com_drop_trigger
- Com_drop_user
- Com_drop_view
- Com_empty_query
- Com_execute_immediate
- Com_execute_sql
- Com_flush
- Com_get_diagnostics
- Com_grant
- Com_grant_role
- Com_ha_close
- Com_ha_open
- Com_ha_read
- Com_help
- Com_insert
- Com_insert_select
- Com_install_plugin
- Com_kill
- Com_load
- Com_load_master_data
- Com_load_master_table
- Com_multi
- Com_lock_tables
- Com_optimize
- Com_preload_keys
- Com_prepare_sql
- Com_purge
- Com_purge_before_date
- Com_release_savepoint
- Com_rename_table
- Com_rename_user
- Com_repair
- Com_replace
- Com_replace_select
- Com_reset
- Com_resignal
- Com_restore_table
- Com_revoke
- Com_revoke_all
- Com_revoke_grant
- Com_rollback
- Com_rollback_to_savepoint
- Com_savepoint
- Com_select
- Com_set_option
- Com_signal
- Com_show_authors
- Com_show_binlog_events
- Com_show_binlogs
- Com_show_charsets
- Com_show_client_statistics
- Com_show_collations
- Com_show_column_types
- Com_show_contributors
- Com_show_create_db
- Com_show_create_event
- Com_show_create_func
- Com_show_create_package
- Com_show_create_package_body
- Com_show_create_proc
- Com_show_create_table
- Com_show_create_trigger
- Com_show_create_user
- Com_show_databases
- Com_show_engine_logs
- Com_show_engine_mutex
- Com_show_engine_status
- Com_show_events
- Com_show_errors
- Com_show_explain
- Com_show_fields
- Com_show_function_status
- Com_show_generic
- Com_show_grants
- Com_show_keys
- Com_show_index_statistics
- com_show_master_status
- com_show_new_master
- Com_show_open_tables
- Com_show_package_status
- Com_show_package_body_status
- Com_show_plugins
- Com_show_privileges
- Com_show_procedure_status
- Com_show_processlist
- Com_show_profile
- Com_show_profiles
- Com_show_relaylog_events
- com_show_slave_hosts
- com_show_slave_status
- Com_show_status
- Com_show_storage_engines
- Com_show_table_statistics
- Com_show_table_status
- Com_show_tables
- Com_show_triggers
- Com_show_user_statistics
- Com_show_variable
- Com_show_warnings
- Com_shutdown
- Com_slave_start
- Com_slave_stop
- Com_start_all_slaves
- Com_start_slave
- Com_stmt_close
- Com_stmt_execute
- Com_stmt_fetch
- Com_stmt_prepare
- Com_stmt_reprepare
- Com_stmt_reset
- Com_stmt_send_long_data
- Com_stop_all_slaves
- Com_stop_slave
- Com_truncate
- Com_uninstall_plugin
- Com_unlock_tables
- Com_update
- Com_update_multi
- Com_xa_commit
- Com_xa_end
- Com_xa_prepare
- Com_xa_recover
- Com_xa_rollback
- Com_xa_start
- Compression
- Connection_errors_accept
- Connection_errors_internal
- Connection_errors_max_connections
- Connection_errors_peer_address
- Connection_errors_select
- Connection_errors_tcpwrap
- Connections
- Cpu_time
- Created_tmp_disk_tables
- Created_tmp_files
- Created_tmp_tables
- Delayed_errors
- Delayed_insert_threads
- Delayed_writes
- Delete_scan
- Empty_queries
- Executed_events
- Executed_triggers
- Feature_application_time_periods
- Feature_check_constraint
- Feature_custom_aggregate_functions
- Feature_delay_key_write
- Feature_dynamic_columns
- Feature_fulltext
- Feature_gis
- Feature_insert_returning
- Feature_invisible_columns
- Feature_json
- Feature_locale
- Feature_subquery
- Feature_system_versioning
- Feature_timezone
- Feature_trigger
- Feature_window_functions
- Feature_xml
- Flush_commands
- Handler_commit
- Handler_delete
- Handler_discover
- Handler_external_lock
- Handler_icp_attempts
- Handler_icp_match
- Handler_mrr_init
- Handler_mrr_key_refills
- Handler_mrr_rowid_refills
- Handler_prepare
- Handler_read_first
- Handler_read_key
- Handler_read_last
- Handler_read_next
- Handler_read_prev
- Handler_read_retry
- Handler_read_rnd
- Handler_read_rnd_deleted
- Handler_read_rnd_next
- Handler_rollback
- Handler_savepoint
- Handler_savepoint_rollback
- Handler_tmp_delete
- Handler_tmp_update
- Handler_tmp_write
- Handler_update
- Handler_write
- Innodb_adaptive_hash_cells
- Innodb_adaptive_hash_hash_searches
- Innodb_adaptive_hash_heap_buffers
- Innodb_adaptive_hash_non_hash_searches
- Innodb_available_undo_logs
- Innodb_background_log_sync
- Innodb_buffer_pool_bytes_data
- Innodb_buffer_pool_bytes_dirty
- Innodb_buffer_pool_dump_status
- innodb_buffer_pool_load_incomplete
- innodb_buffer_pool_load_status
- Innodb_buffer_pool_pages_data
- Innodb_buffer_pool_pages_dirty
- Innodb_buffer_pool_pages_flushed
- Innodb_buffer_pool_pages_LRU_flushed
- Innodb_buffer_pool_pages_LRU_freed
- 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_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_resize_status
- Innodb_buffer_pool_wait_free
- Innodb_buffer_pool_write_requests
- Innodb_buffered_aio_submitted
- Innodb_checkpoint_age
- Innodb_checkpoint_max_age
- Innodb_checkpoint_target_age
- Innodb_current_row_locks
- 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_defragment_compression_failures
- Innodb_defragment_count
- Innodb_defragment_failures
- Innodb_dict_tables
- Innodb_encryption_n_merge_blocks_decrypted
- Innodb_encryption_n_merge_blocks_encrypted
- Innodb_encryption_n_rowlog_blocks_decrypted
- Innodb_encryption_n_rowlog_blocks_encrypted
- Innodb_encryption_n_temp_blocks_decrypted
- Innodb_encryption_n_temp_blocks_encrypted
- Innodb_encryption_num_key_requests
- Innodb_encryption_rotation_estimated_iops
- Innodb_encryption_rotation_pages_flushed
- Innodb_encryption_rotation_pages_modified
- Innodb_encryption_rotation_pages_read_from_cache
- Innodb_encryption_rotation_pages_read_from_disk
- Innodb_have_atomic_builtins
- Innodb_have_bzip2
- Innodb_have_lz4
- Innodb_have_lzma
- Innodb_have_lzo
- Innodb_have_snappy
- 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_instant_alter_column
- Innodb_log_waits
- Innodb_log_write_requests
- Innodb_log_writes
- Innodb_lsn_current
- Innodb_lsn_flushed
- Innodb_lsn_last_checkpoint
- Innodb_master_thread_1_second_loops
- Innodb_master_thread_10_second_loops
- Innodb_master_thread_background_loops
- Innodb_master_thread_main_flush_loops
- Innodb_master_thread_sleeps
- Innodb_max_trx_id
- Innodb_mem_adaptive_hash
- Innodb_mem_dictionary
- Innodb_mem_total
- Innodb_mutex_os_waits
- Innodb_mutex_spin_rounds
- Innodb_mutex_spin_waits
- Innodb_num_index_pages_written
- Innodb_num_non_index_pages_written
- Innodb_num_open_files
- Innodb_num_page_compressed_trim_op
- Innodb_num_page_compressed_trim_op_saved
- Innodb_num_pages_encrypted
- Innodb_num_pages_page_compressed
- Innodb_num_pages_page_compression_error
- Innodb_num_pages_page_decompressed
- Innodb_num_pages_page_decrypted
- Innodb_num_pages_page_encryption_error
- Innodb_oldest_view_low_limit_trx_id
- Innodb_onlineddl_pct_progress
- Innodb_onlineddl_rowlog_pct_used
- Innodb_onlineddl_rowlog_rows
- Innodb_os_log_fsyncs
- Innodb_os_log_pending_fsyncs
- Innodb_os_log_pending_writes
- Innodb_os_log_written
- Innodb_page_compression_saved
- Innodb_page_compression_trim_sect512
- Innodb_page_compression_trim_sect1024
- Innodb_page_compression_trim_sect2048
- Innodb_page_compression_trim_sect4096
- Innodb_page_compression_trim_sect8192
- Innodb_page_compression_trim_sect16384
- Innodb_page_compression_trim_sect32768
- Innodb_page_size
- Innodb_pages_created
- Innodb_pages_read
- Innodb_pages_written
- Innodb_purge_trx_id
- Innodb_purge_undo_no
- Innodb_row_lock_current_waits
- Innodb_row_lock_numbers
- Innodb_row_lock_time
- Innodb_row_lock_time_avg
- Innodb_row_lock_time_max
- Innodb_row_lock_waits
- Innodb_rows_deleted
- Innodb_rows_inserted
- Innodb_rows_read
- Innodb_rows_updated
- Innodb_s_lock_os_waits
- Innodb_s_lock_spin_rounds
- Innodb_s_lock_spin_waits
- Innodb_scrub_background_page_reorganizations
- Innodb_scrub_background_page_split_failures_missing_index
- Innodb_scrub_background_page_split_failures_out_of_filespace
- Innodb_scrub_background_page_split_failures_underflow
- Innodb_scrub_background_page_split_failures_unknown
- Innodb_scrub_background_page_splits
- Innodb_secondary_index_triggered_cluster_reads
- Innodb_secondary_index_triggered_cluster_reads_avoided
- Innodb_system_rows_deleted
- Innodb_system_rows_inserted
- Innodb_system_rows_read
- Innodb_system_rows_updated
- Innodb_truncated_status_writes
- Innodb_undo_truncations
- Innodb_x_lock_os_waits
- Innodb_x_lock_spin_rounds
- Innodb_x_lock_spin_waits
- Key_blocks_not_flushed
- Key_blocks_unused
- Key_blocks_used
- Key_blocks_warm
- Key_read_requests
- Key_reads
- Key_write_requests
- Key_writes
- Last_query_cost
- Maria_*
- Master_gtid_wait_count
- Master_gtid_wait_time
- Master_gtid_wait_timeouts
- Max_statement_time_exceeded
- Max_tmp_space_used
- Max_used_connections
- Max_used_connections_time
- Memory_used
- Memory_used_initial
- Mroonga_count_skip
- Mroonga_fast_order_limit
- Not_flushed_delayed_rows
- Open_files
- Open_streams
- Open_table_definitions
- Open_tables
- Opened_files
- Opened_plugin_libraries
- Opened_table_definitions
- Opened_tables
- Opened_views
- Oqgraph_boost_version
- Oqgraph_compat_mode
- Oqgraph_verbose_debug
- Performance_schema_accounts_lost
- Performance_cond_classes_accounts_lost
- Performance_schema_cond_instances_lost
- Performance_schema_digest_lost
- Performance_schema_file_classes_lost
- Performance_schema_file_handles_lost
- Performance_schema_file_instances_lost
- Performance_schema_hosts_lost
- Performance_schema_index_stat_lost
- Performance_schema_locker_lost
- Performance_schema_memory_classes_lost
- Performance_metadata_lock_classes_lost
- Performance_schema_mutex_classes_lost
- Performance_schema_mutex_instances_lost
- Performance_schema_nested_statement_lost
- Performance_schema_prepared_statements_lost
- Performance_schema_program_lost
- Performance_schema_rwlock_classes_lost
- Performance_schema_rwlock_instances_lost
- Performance_schema_session_connect_attrs_lost
- Performance_schema_socket_classes_lost
- Performance_schema_socket_instances_lost
- Performance_schema_stage_classes_lost
- Performance_schema_statement_classes_lost
- Performance_schema_table_handles_lost
- Performance_schema_table_instances_lost
- Performance_schema_table_lock_stat_lost
- Performance_schema_thread_classes_lost
- Performance_schema_thread_instances_lost
- Performance_schema_users_lost
- Prepared_stmt_count
- Qcache_free_blocks
- Qcache_free_memory
- Qcache_hits
- Qcache_inserts
- Qcache_lowmem_prunes
- Qcache_not_cached
- Qcache_queries_in_cache
- Qcache_total_blocks
- Queries
- Questions
- Resultset_metadata_skipped
- Rocksdb_block_cache_add
- Rocksdb_block_cache_add_failures
- Rocksdb_block_cache_bytes_read
- Rocksdb_block_cache_bytes_write
- Rocksdb_block_cache_data_add
- Rocksdb_block_cache_data_bytes_insert
- Rocksdb_block_cache_data_hit
- Rocksdb_block_cache_data_miss
- Rocksdb_block_cache_filter_add
- Rocksdb_block_cache_filter_bytes_evict
- Rocksdb_block_cache_filter_bytes_insert
- Rocksdb_block_cache_filter_hit
- Rocksdb_block_cache_filter_miss
- Rocksdb_block_cache_hit
- Rocksdb_block_cache_index_add
- Rocksdb_block_cache_index_bytes_evict
- Rocksdb_block_cache_index_bytes_insert
- Rocksdb_block_cache_index_hit
- Rocksdb_block_cache_index_miss
- Rocksdb_block_cache_miss
- Rocksdb_block_cachecompressed_hit
- Rocksdb_block_cachecompressed_miss
- Rocksdb_bloom_filter_full_positive
- Rocksdb_bloom_filter_full_true_positive
- Rocksdb_bloom_filter_prefix_checked
- Rocksdb_bloom_filter_prefix_useful
- Rocksdb_bloom_filter_useful
- Rocksdb_bytes_read
- Rocksdb_bytes_written
- Rocksdb_compact_read_bytes
- Rocksdb_compact_write_bytes
- Rocksdb_compaction_key_drop_new
- Rocksdb_compaction_key_drop_obsolete
- Rocksdb_compaction_key_drop_user
- Rocksdb_covered_secondary_key_lookups
- Rocksdb_flush_write_bytes
- Rocksdb_get_hit_l0
- Rocksdb_get_hit_l1
- Rocksdb_get_hit_l2_and_up
- Rocksdb_getupdatessince_calls
- Rocksdb_iter_bytes_read
- Rocksdb_l0_num_files_stall_micros
- Rocksdb_l0_slowdown_micros
- Rocksdb_manual_compactions_processed
- Rocksdb_manual_compactions_running
- Rocksdb_memtable_compaction_micros
- Rocksdb_memtable_hit
- Rocksdb_memtable_miss
- Rocksdb_memtable_total
- Rocksdb_memtable_unflushed
- Rocksdb_no_file_closes
- Rocksdb_no_file_errors
- Rocksdb_no_file_opens
- Rocksdb_num_iterators
- Rocksdb_number_block_not_compressed
- Rocksdb_number_db_next
- Rocksdb_number_db_next_found
- Rocksdb_number_db_prev
- Rocksdb_number_db_prev_found
- Rocksdb_number_db_seek
- Rocksdb_number_db_seek_found
- Rocksdb_number_deletes_filtered
- Rocksdb_number_keys_read
- Rocksdb_number_keys_updated
- Rocksdb_number_keys_written
- Rocksdb_number_merge_failures
- Rocksdb_number_multiget_bytes_read
- Rocksdb_number_multiget_get
- Rocksdb_number_multiget_keys_read
- Rocksdb_number_reseeks_iteration
- Rocksdb_number_sst_entry_delete
- Rocksdb_number_sst_entry_merge
- Rocksdb_number_sst_entry_other
- Rocksdb_number_sst_entry_put
- Rocksdb_number_sst_entry_singledelete
- Rocksdb_number_superversion_acquires
- Rocksdb_number_superversion_cleanups
- Rocksdb_number_superversion_releases
- Rocksdb_queries_point
- Rocksdb_queries_range
- Rocksdb_row_lock_deadlocks
- Rocksdb_row_lock_wait_timeouts
- Rocksdb_rows_deleted
- Rocksdb_rows_deleted_blind
- Rocksdb_rows_expired
- Rocksdb_rows_filtered
- Rocksdb_rows_inserted
- Rocksdb_rows_read
- Rocksdb_rows_updated
- Rocksdb_snapshot_conflict_errors
- Rocksdb_stall_l0_file_count_limit_slowdowns
- Rocksdb_stall_l0_file_count_limit_stops
- Rocksdb_stall_locked_l0_file_count_limit_slowdowns
- Rocksdb_stall_locked_l0_file_count_limit_stops
- Rocksdb_stall_memtable_limit_slowdowns
- Rocksdb_stall_memtable_limit_stops
- Rocksdb_stall_micros
- Rocksdb_stall_pending_compaction_limit_slowdowns
- Rocksdb_stall_pending_compaction_limit_stops
- Rocksdb_stall_total_slowdowns
- Rocksdb_stall_total_stops
- Rocksdb_system_rows_deleted
- Rocksdb_system_rows_inserted
- Rocksdb_system_rows_read
- Rocksdb_system_rows_updated
- Rocksdb_wal_bytes
- Rocksdb_wal_group_syncs
- Rocksdb_wal_synced
- Rocksdb_write_other
- Rocksdb_write_self
- Rocksdb_write_timedout
- Rocksdb_write_wal
- Rows_read
- Rows_sent
- Rows_tmp_read
- Rpl_semi_sync_master_clients
- Rpl_semi_sync_master_net_avg_wait_time
- Rpl_semi_sync_master_net_wait_time
- Rpl_semi_sync_master_net_waits
- Rpl_semi_sync_master_no_times
- Rpl_semi_sync_master_no_tx
- Rpl_semi_sync_master_status
- Rpl_semi_sync_master_timefunc_failures
- Rpl_semi_sync_master_tx_avg_wait_time
- Rpl_semi_sync_master_tx_wait_time
- Rpl_semi_sync_master_tx_waits
- Rpl_semi_sync_master_wait_pos_backtraverse
- Rpl_semi_sync_master_wait_sessions
- Rpl_semi_sync_master_yes_tx
- Rpl_semi_sync_slave_status
- Rpl_status
- Rpl_transactions_multi_engine
- S3_pagecache_blocks_not_flushed
- S3_pagecache_blocks_unused
- S3_pagecache_blocks_used
- S3_pagecache_read_requests
- S3_pagecache_reads
- Select_full_join
- Select_full_range_join
- Select_range
- Select_range_check
- Select_scan
- Server_audit_active
- Server_audit_current_log
- Server_audit_last_error
- Server_audit_writes_failed
- Slave_connections
- Slave_heartbeat_period
- Slave_open_temp_tables
- Slave_received_heartbeats
- Slave_retried_transactions
- Slave_running
- Slave_skipped_errors
- Slaves_connected
- Slaves_running
- Slow_launch_threads
- Slow_queries
- Sort_merge_passes
- Sort_priority_queue_sorts
- Sort_range
- Sort_rows
- Sort_scan
- Sphinx_error
- Sphinx_time
- Sphinx_total
- Sphinx_total_found
- Sphinx_word_count
- Sphinx_words
- Spider_direct_aggregate
- Spider_direct_delete
- Spider_direct_order_limit
- Spider_direct_update
- Spider_direct_mon_table_cache_version
- Spider_direct_mon_table_cache_version_req
- Spider_parallel_search
- Ssl_accept_renegotiates
- Ssl_accepts
- Ssl_callback_cache_hits
- Ssl_cipher
- Ssl_cipher_list
- Ssl_client_connects
- Ssl_connect_renegotiates
- Ssl_ctx_verify_depth
- Ssl_ctx_verify_mode
- Ssl_default_timeout
- Ssl_finished_accepts
- Ssl_finished_connects
- Ssl_server_not_after
- Ssl_server_not_before
- Ssl_session_cache_hits
- Ssl_session_cache_misses
- Ssl_session_cache_mode
- Ssl_session_cache_overflows
- Ssl_session_cache_size
- Ssl_session_cache_timeouts
- Ssl_sessions_reused
- Ssl_used_session_cache_entries
- Ssl_verify_depth
- Ssl_verify_mode
- Ssl_version
- Subquery_cache_hit
- Subquery_cache_miss
- Syncs
- Table_locks_immediate
- Table_locks_waited
- Table_open_cache_active_instances
- Table_open_cache_hits
- Table_open_cache_misses
- Table_open_cache_overflows
- Tc_log_max_pages_used
- Tc_log_page_size
- Tc_log_page_waits
- Threadpool_idle_threads
- Threadpool_threads
- Threads_cached
- Threads_connected
- Threads_created
- Threads_running
- Tmp_space_used
- Tokudb_basement_deserialization_fixed_key
- Tokudb_basement_deserialization_variable_key
- Tokudb_basements_decompressed_for_write
- Tokudb_basements_decompressed_prefetch
- Tokudb_basements_decompressed_prelocked_range
- Tokudb_basements_decompressed_target_query
- Tokudb_basements_fetched_prefetch
- Tokudb_basements_fetched_for_write
- Tokudb_basements_fetched_for_write_bytes
- Tokudb_basements_fetched_for_write_seconds
- Tokudb_basements_fetched_prefetch_bytes
- Tokudb_basements_fetched_prefetch_seconds
- Tokudb_basements_fetched_prelocked_range
- Tokudb_basements_fetched_prelocked_range_bytes
- Tokudb_basements_fetched_prelocked_range_seconds
- Tokudb_basements_fetched_target_query
- Tokudb_basements_fetched_target_query_bytes
- Tokudb_basements_fetched_target_query_seconds
- Tokudb_broadcase_messages_injected_at_root
- Tokudb_buffers_decompressed_for_write
- Tokudb_buffers_decompressed_prefetch
- Tokudb_buffers_decompressed_prelocked_range
- Tokudb_buffers_decompressed_target_query
- Tokudb_buffers_fetched_for_write
- Tokudb_buffers_fetched_for_write_bytes
- Tokudb_buffers_fetched_for_write_seconds
- Tokudb_buffers_fetched_prefetch
- Tokudb_buffers_fetched_prefetch_bytes
- Tokudb_buffers_fetched_prefetch_seconds
- Tokudb_buffers_fetched_prelocked_range
- Tokudb_buffers_fetched_prelocked_range_bytes
- Tokudb_buffers_fetched_prelocked_range_seconds
- Tokudb_buffers_fetched_target_query
- Tokudb_buffers_fetched_target_query_bytes
- Tokudb_buffers_fetched_target_query_seconds
- Tokudb_cachetable_cleaner_executions
- Tokudb_cachetable_cleaner_iterations
- Tokudb_cachetable_cleaner_period
- Tokudb_cachetable_evictions
- Tokudb_cachetable_long_wait_pressure_count
- Tokudb_cachetable_long_wait_pressure_time
- Tokudb_cachetable_miss
- Tokudb_cachetable_miss_time
- Tokudb_cachetable_prefetches
- Tokudb_cachetable_size_cachepressure
- Tokudb_cachetable_size_cloned
- Tokudb_cachetable_size_current
- Tokudb_cachetable_size_leaf
- Tokudb_cachetable_size_limit
- Tokudb_cachetable_size_nonleaf
- Tokudb_cachetable_size_rollback
- Tokudb_cachetable_size_writing
- Tokudb_cachetable_wait_pressure_count
- Tokudb_cachetable_wait_pressure_time
- Tokudb_checkpoint_begin_time
- Tokudb_checkpoint_duration
- Tokudb_checkpoint_duration_last
- Tokudb_checkpoint_failed
- Tokudb_checkpoint_last_began
- Tokudb_checkpoint_last_complete_began
- Tokudb_checkpoint_last_complete_ended
- Tokudb_checkpoint_long_begin_count
- Tokudb_checkpoint_long_begin_time
- Tokudb_checkpoint_period
- Tokudb_checkpoint_taken
- Tokudb_cursor_skip_deleted_leaf_entry
- Tokudb_db_closes
- Tokudb_db_open_current
- Tokudb_db_open_max
- Tokudb_db_opens
- Tokudb_descriptor_set
- Tokudb_dictionary_broadcast_updates
- Tokudb_dictionary_updates
- Tokudb_filesystem_fsync_num
- Tokudb_filesystem_fsync_time
- Tokudb_filesystem_long_fsync_num
- Tokudb_filesystem_long_fsync_time
- Tokudb_filesystem_threads_blocked_by_full_disk
- Tokudb_leaf_compression_to_memory_seconds
- Tokudb_leaf_decompression_to_memory_seconds
- Tokudb_leaf_deserialization_to_memory_seconds
- Tokudb_leaf_node_compression_ratio
- Tokudb_leaf_node_full_evictions
- Tokudb_leaf_node_full_evictions_bytes
- Tokudb_leaf_node_partial_evictions
- Tokudb_leaf_node_partial_evictions_bytes
- Tokudb_leaf_nodes_created
- Tokudb_leaf_nodes_destroyed
- Tokudb_leaf_nodes_flushed_to_disk_checkpoint
- Tokudb_leaf_nodes_flushed_to_disk_checkpoint_bytes
- Tokudb_leaf_nodes_flushed_to_disk_checkpoint_seconds
- Tokudb_leaf_nodes_flushed_to_disk_checkpoint_uncompressed_bytes
- Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint
- Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_bytes
- Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_seconds
- Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_uncompressed_bytes
- Tokudb_leaf_serialization_to_memory_seconds
- Tokudb_loader_num_created
- Tokudb_loader_num_current
- Tokudb_loader_num_max
- Tokudb_locktree_escalation_num
- Tokudb_locktree_escalation_seconds
- Tokudb_locktree_latest_post_escalation_memory_size
- Tokudb_locktree_long_wait_count
- Tokudb_locktree_long_wait_escalation_count
- Tokudb_locktree_long_wait_escalation_time
- Tokudb_locktree_long_wait_time
- Tokudb_locktree_memory_size
- Tokudb_locktree_memory_size_limit
- Tokudb_locktree_open_current
- Tokudb_locktree_pending_lock_requests
- Tokudb_locktree_sto_eligible_num
- Tokudb_locktree_sto_ended_num
- Tokudb_locktree_sto_ended_seconds
- Tokudb_locktree_timeout_count
- Tokudb_locktree_wait_count
- Tokudb_locktree_wait_escalation_count
- Tokudb_locktree_wait_escalation_time
- Tokudb_locktree_wait_time
- Tokudb_logger_wait_long
- Tokudb_logger_writes
- Tokudb_logger_writes_bytes
- Tokudb_logger_writes_seconds
- Tokudb_logger_writes_uncompressed_bytes
- Tokudb_mem_estimated_maximum_memory_footprint
- Tokudb_messages_flushed_from_h1_to_leaves_bytes
- Tokudb_messages_ignored_by_leaf_due_to_msn
- Tokudb_messages_in_trees_estimate_bytes
- Tokudb_messages_injected_at_root
- Tokudb_messages_injected_at_root_bytes
- Tokudb_nonleaf_compression_to_memory_seconds
- Tokudb_nonleaf_decompression_to_memory_seconds
- Tokudb_nonleaf_deserialization_to_memory_seconds
- Tokudb_nonleaf_node_compression_ratio
- Tokudb_nonleaf_node_full_evictions
- Tokudb_nonleaf_node_full_evictions_bytes
- Tokudb_nonleaf_node_partial_evictions
- Tokudb_nonleaf_node_partial_evictions_bytes
- Tokudb_nonleaf_nodes_created
- Tokudb_nonleaf_nodes_destroyed
- Tokudb_nonleaf_nodes_flushed_checkpoint
- Tokudb_nonleaf_nodes_flushed_checkpoint_bytes
- Tokudb_nonleaf_nodes_flushed_checkpoint_seconds
- Tokudb_nonleaf_nodes_flushed_checkpoint_uncompressed_bytes
- Tokudb_nonleaf_nodes_flushed_not_checkpoint
- Tokudb_nonleaf_nodes_flushed_not_checkpoint_bytes
- Tokudb_nonleaf_nodes_flushed_not_checkpoint_seconds
- Tokudb_nonleaf_nodes_flushed_not_checkpoint_uncompressed_bytes
- Tokudb_nonleaf_serialization_to_memory_seconds
- Tokudb_overall_node_compression_ratio
- Tokudb_pivots_fetched_for_query
- Tokudb_pivots_fetched_for_query_bytes
- Tokudb_pivots_fetched_for_query_seconds
- Tokudb_pivots_fetched_for_prefetch
- Tokudb_pivots_fetched_for_prefetch_bytes
- Tokudb_pivots_fetched_for_prefetch_seconds
- Tokudb_pivots_fetched_for_write
- Tokudb_pivots_fetched_for_write_bytes
- Tokudb_pivots_fetched_for_write_seconds
- Tokudb_promotion_h1_roots_injected_into
- Tokudb_promotion_injections_at_depth_0
- Tokudb_promotion_injections_at_depth_1
- Tokudb_promotion_injections_at_depth_2
- Tokudb_promotion_injections_at_depth_3
- Tokudb_promotion_injections_lower_than_depth_3
- Tokudb_promotion_leaf_roots_injected_into
- Tokudb_promotion_roots_split
- Tokudb_promotion_stopped_after_locking_child
- Tokudb_promotion_stopped_at_height_1
- Tokudb_promotion_stopped_child_not_fully_in_memory
- Tokudb_promotion_stopped_child_locked_or_not_in_memory
- Tokudb_promotion_stopped_nonempty_buffer
- Tokudb_txn_aborts
- Tokudb_txn_begin
- Tokudb_txn_begin_read_only
- Tokudb_txn_commits
- Transactions_gtid_foreign_engine
- Transactions_multi_engine
- Update_scan
- Uptime
- Uptime_since_flush_status
- wsrep
- wsrep_applier_thread_count
- wsrep_apply_oooe
- wsrep_apply_oool
- wsrep_cert_deps_distance
- wsrep_cluster_capabilities
- wsrep_cluster_conf_id
- wsrep_cluster_size
- wsrep_cluster_state_uuid
- wsrep_cluster_status
- wsrep_connected
- wsrep_flow_control_paused
- wsrep_flow_control_recv
- wsrep_flow_control_sent
- wsrep_last_committed
- wsrep_local_bf_aborts
- wsrep_local_cert_failures
- wsrep_local_commits
- wsrep_local_index
- wsrep_local_recv_queue
- wsrep_local_recv_queue_avg
- wsrep_local_replays
- wsrep_local_send_queue
- wsrep_local_send_queue_avg
- wsrep_local_state
- wsrep_local_state_comment
- wsrep_local_state_uuid
- wsrep_protocol_version
- wsrep_provider_name
- wsrep_provider_vendor
- wsrep_provider_version
- wsrep_ready
- wsrep_received
- wsrep_received_bytes
- wsrep_replicated
- wsrep_replicated_bytes
- wsrep_rollbacker_thread_count
- wsrep_thread_count
The full list of status variables are listed in the contents on this page; most are described on this page, but some are described elsewhere:
- Aria Status Variables
- Galera Status Variables
- InnoDB Status Variables
- Mroonga Status Variables
- MyRocks Status Variables
- Performance Scheme Status Variables
- Replication and Binary Log Status Variables
- S3 Storage Engine Status Variables
- Server_Audit Status Variables
- Sphinx Status Variables
- Spider Status Variables
- TokuDB Status Variables
See also the Full list of MariaDB options, system and status variables.
Use the SHOW STATUS statement to view status variables. This information also can be obtained using the mariadb-admin extended-status command, or by querying the Information Schema GLOBAL_STATUS and SESSION_STATUS tables.
Issuing a FLUSH STATUS will reset many status variables to zero.
List of Server Status Variables
Aborted_clients
- Description: Number of aborted client connections. This can be due to the client not calling mysql_close() before exiting, the client sleeping without issuing a request to the server for more seconds than specified by wait_timeout or interactive_timeout, or by the client program ending in the midst of transferring data. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Aborted_connects
- Description: Number of failed server connection attempts. This can be due to a client using an incorrect password, a client not having privileges to connect to a database, a connection packet not containing the correct information, or if it takes more than connect_timeout seconds to get a connect packet. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Aborted_connects_preauth
- Description: Number of connection attempts that were aborted prior to authentication (regardless of whether or not an error occured).
- Scope: Global
- Data Type:
numeric
Access_denied_errors
- Description: Number of access denied errors.
- Scope: Global
- Data Type:
numeric
Acl_column_grants
- Description: Number of column permissions granted (rows in the mysql.columns_priv table).
- Scope: Global
- Data Type:
numeric
Acl_database_grants
- Description: Number of database permissions granted (rows in the mysql.db table).
- Scope: Global
- Data Type:
numeric
Acl_function_grants
- Description: Number of function permissions granted (rows in the mysql.procs_priv table with a routine type of
FUNCTION
). - Scope: Global
- Data Type:
numeric
Acl_package_body_grants
- Description:
- Scope: Global
- Data Type:
numeric
Acl_package_spec_grants
- Description:
- Scope: Global
- Data Type:
numeric
Acl_procedure_grants
- Description: Number of procedure permissions granted (rows in the mysql.procs_priv table with a routine type of
PROCEDURE
). - Scope: Global
- Data Type:
numeric
Acl_proxy_users
- Description: Number of proxy permissions granted (rows in the mysql.proxies_priv table).
- Scope: Global
- Data Type:
numeric
Acl_role_grants
- Description: Number of role permissions granted (rows in the mysql.roles_mapping table).
- Scope: Global
- Data Type:
numeric
Acl_roles
- Description: Number of roles (rows in the mysql.user table where
is_role='Y'
). - Scope: Global
- Data Type:
numeric
Acl_table_grants
- Description: Number of table permissions granted (rows in the mysql.tables_priv table).
- Scope: Global
- Data Type:
numeric
Acl_users
- Description: Number of users (rows in the mysql.user table where
is_role='N'
). - Scope: Global
- Data Type:
numeric
Busy_time
- Description: Cumulative time in seconds of activity on connections. Part of User Statistics. Requires the userstat system variable to be set in order to be recorded.
- Scope: Global
- Data Type:
numeric
Bytes_received
- Description: Total bytes received from all clients.
- Scope: Global
- Data Type:
numeric
Bytes_sent
- Description: Total bytes sent to all clients.
- Scope: Global, Session
- Data Type:
numeric
Com_admin_commands
- Description: Number of admin commands executed. These include table dumps, change users, binary log dumps, shutdowns, pings and debugs.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_db
- Description: Number of ALTER DATABASE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_db_upgrade
- Description: Number of ALTER DATABASE ... UPGRADE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_event
- Description: Number of ALTER EVENT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_function
- Description: Number of ALTER FUNCTION commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_procedure
- Description: Number of ALTER PROCEDURE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_sequence
- Description: Number of ALTER SEQUENCE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_server
- Description: Number of ALTER SERVER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_table
- Description: Number of ALTER TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_alter_tablespace
- Description: Number of ALTER TABLESPACE commands executed (unsupported by MariaDB).
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.7.0
Com_alter_user
- Description: Number of ALTER USER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_analyze
- Description: Number of ANALYZE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_assign_to_keycache
- Description: Number of assign to keycache commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_backup
- Description:
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.4.1
Com_backup_lock
- Description:
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.4.2
Com_backup_table
- Description: Removed in MariaDB 5.5. In older versions, Com_backup_table contains the number of BACKUP TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 5.5
Com_begin
- Description: Number of BEGIN or START TRANSACTION statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_binlog
- Description: Number of BINLOG commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_call_procedure
- Description: Number of CALL procedure_name statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_change_db
- Description: Number of USE database_name commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_check
- Description: Number of CHECK TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_checksum
- Description: Number of CHECKSUM TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_commit
- Description: Number of COMMIT commands executed. Differs from Handler_commit, which counts internal commit statements.
- Scope: Global, Session
- Data Type:
numeric
Com_compound_sql
- Description: Number of compund sql statements.
- Scope: Global, Session
- Data Type:
numeric
Com_create_db
- Description: Number of CREATE DATABASE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_event
- Description: Number of CREATE EVENT commands executed. Differs from Executed_events in that it is incremented when the CREATE EVENT is run, and not when the event executes.
- Scope: Global, Session
- Data Type:
numeric
Com_create_function
- Description: Number of CREATE FUNCTION commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_index
- Description: Number of CREATE INDEX commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_package
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_create_package_body
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_create_procedure
- Description: Number of CREATE PROCEDURE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_role
- Description: Number of CREATE ROLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_sequence
- Description: Number of CREATE SEQUENCE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_server
- Description: Number of CREATE SERVER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_table
- Description: Number of CREATE TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_temporary_table
- Description: Number of CREATE TEMPORARY TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_trigger
- Description: Number of CREATE TRIGGER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_udf
- Description: Number of CREATE UDF commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_user
- Description: Number of CREATE USER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_create_view
- Description: Number of CREATE VIEW commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_dealloc_sql
- Description: Number of DEALLOCATE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_delete
- Description: Number of DELETE commands executed. Differs from Handler_delete, which counts the number of times rows have been deleted from tables.
- Scope: Global, Session
- Data Type:
numeric
Com_delete_multi
- Description: Number of multi-table DELETE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_do
- Description: Number of DO commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_db
- Description: Number of DROP DATABASE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_event
- Description: Number of DROP EVENT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_function
- Description: Number of DROP FUNCTION commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_index
- Description: Number of DROP INDEX commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_package
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_drop_package_body
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_drop_procedure
- Description: Number of DROP PROCEDURE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_role
- Description: Number of DROP ROLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_sequence
- Description: Number of DROP SEQUENCE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_server
- Description: Number of DROP SERVER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_table
- Description: Number of DROP TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_temporary_table
- Description: Number of DROP TEMPORARY TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_trigger
- Description: Number of DROP TRIGGER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_user
- Description: Number of DROP USER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_drop_view
- Description: Number of DROP VIEW commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_empty_query
- Description: Number of queries to the server that do not produce SQL queries. An SQL query simply returning no results does not increment
Com_empty_query
- see Empty_queries instead. An example of an empty query sent to the server ismariadb --comments -e '-- sql comment'
- Scope: Global, Session
- Data Type:
numeric
Com_execute_immediate
- Description: Number of EXECUTE IMMEDIATE statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_execute_sql
- Description: Number of EXECUTE statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_flush
- Description: Number of FLUSH commands executed. This differs from Flush_commands, which also counts internal server flush requests.
- Scope: Global, Session
- Data Type:
numeric
Com_get_diagnostics
- Description: Number of GET DIAGNOSTICS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_grant
- Description: Number of GRANT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_grant_role
- Description: Number of GRANT role commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_ha_close
- Description: Number of HANDLER table_name CLOSE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_ha_open
- Description: Number of HANDLER table_name OPEN commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_ha_read
- Description: Number of HANDLER table_name READ commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_help
- Description: Number of HELP commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_insert
- Description: Number of INSERT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_insert_select
- Description: Number of INSERT ... SELECT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_install_plugin
- Description: Number of INSTALL PLUGIN commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_kill
- Description: Number of KILL commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_load
- Description: Number of LOAD commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_load_master_data
- Description:
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 5.5
Com_load_master_table
- Description:
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 5.5
Com_multi
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_lock_tables
- Description: Number of [lock-tables|LOCK TABLES]] commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_optimize
- Description: Number of OPTIMIZE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_preload_keys
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_prepare_sql
- Description: Number of PREPARE statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_purge
- Description: Number of PURGE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_purge_before_date
- Description: Number of PURGE BEFORE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_release_savepoint
- Description: Number of RELEASE SAVEPOINT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_rename_table
- Description: Number of RENAME TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_rename_user
- Description: Number of RENAME USER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_repair
- Description: Number of REPAIR TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_replace
- Description: Number of REPLACE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_replace_select
- Description: Number of REPLACE ... SELECT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_reset
- Description: Number of RESET commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_resignal
- Description: Number of RESIGNAL commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_restore_table
- Description: Removed in MariaDB 5.5. In older versions, Com_restore_table contains the number of RESTORE TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 5.5
Com_revoke
- Description: Number of REVOKE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_revoke_all
- Description: Number of REVOKE ALL commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_revoke_grant
- Description: Number of REVOKE role commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_rollback
- Description: Number of ROLLBACK commands executed. Differs from Handler_rollback, which is the number of transaction rollback requests given to a storage engine.
- Scope: Global, Session
- Data Type:
numeric
Com_rollback_to_savepoint
- Description: Number of ROLLBACK ... TO SAVEPOINT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_savepoint
- Description: Number of SAVEPOINT commands executed. Differs from Handler_savepoint, which is the number of transaction savepoint creation requests.
- Scope: Global, Session
- Data Type:
numeric
Com_select
- Description: Number of SELECT commands executed. Also includes queries that make use of the query cache.
- Scope: Global, Session
- Data Type:
numeric
Com_set_option
- Description: Number of SET OPTION commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_signal
- Description: Number of SIGNAL statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_authors
- Description: Number of SHOW AUTHORS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_binlog_events
- Description: Number of SHOW BINLOG EVENTS statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_binlogs
- Description: Number of SHOW BINARY LOGS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_charsets
- Description: Number of SHOW CHARACTER SET commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_client_statistics
- Description: Number of SHOW CLIENT STATISTICS commands executed. Removed in MariaDB 10.1.1 when that statement was replaced by the generic SHOW information_schema_table.
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.1.1
Com_show_collations
- Description: Number of SHOW COLLATION commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_column_types
- Description:
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 5.5
Com_show_contributors
- Description: Number of SHOW CONTRIBUTORS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_db
- Description: Number of SHOW CREATE DATABASE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_event
- Description: Number of SHOW CREATE EVENT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_func
- Description: Number of SHOW CREATE FUNCTION commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_package
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_package_body
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_proc
- Description: Number of SHOW CREATE PROCEDURE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_table
- Description: Number of SHOW CREATE TABLE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_trigger
- Description: Number of SHOW CREATE TRIGGER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_create_user
- Description: Number of SHOW CREATE USER commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_databases
- Description: Number of SHOW DATABASES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_engine_logs
- Description: Number of SHOW ENGINE LOGS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_engine_mutex
- Description: Number of SHOW ENGINE MUTEX commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_engine_status
- Description: Number of SHOW ENGINE STATUS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_events
- Description: Number of SHOW EVENTS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_errors
- Description: Number of SHOW ERRORS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_explain
- Description: Number of SHOW EXPLAIN commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_fields
- Description: Number of SHOW COLUMNS or SHOW FIELDS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_function_status
- Description: Number of SHOW FUNCTION STATUS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_generic
- Description: Number of generic SHOW commands executed, such as SHOW INDEX_STATISTICS and SHOW TABLE_STATISTICS
- Scope: Global, Session
- Data Type:
numeric
Com_show_grants
- Description: Number of SHOW GRANTS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_keys
- Description: Number of SHOW INDEX or SHOW KEYS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_index_statistics
- Description: Number of SHOW INDEX_STATISTICS commands executed. Removed in MariaDB 10.1.1 when that statement was replaced by the generic SHOW information_schema_table.
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.1.1
Com_show_open_tables
- Description: Number of SHOW OPEN TABLES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_package_status
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_show_package_body_status
- Description:
- Scope: Global, Session
- Data Type:
numeric
Com_show_plugins
- Description: Number of SHOW PLUGINS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_privileges
- Description: Number of SHOW PRIVILEGES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_procedure_status
- Description: Number of SHOW PROCEDURE STATUS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_processlist
- Description: Number of SHOW PROCESSLIST commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_profile
- Description: Number of SHOW PROFILE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_profiles
- Description: Number of SHOW PROFILES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_relaylog_events
- Description: Number of SHOW RELAYLOG EVENTS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_status
- Description: Number of SHOW STATUS commands executed.
- Scope: Global, Session
- Data Type:
numeric
st
Com_show_storage_engines
- Description: Number of SHOW STORAGE ENGINES - or
SHOW ENGINES
- commands executed. - Scope: Global, Session
- Data Type:
numeric
Com_show_table_statistics
- Description: Number of SHOW TABLE STATISTICS commands executed. Removed in MariaDB 10.1.1 when that statement was replaced by the generic SHOW information_schema_table.
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.1.1
Com_show_table_status
- Description: Number of SHOW TABLE STATUS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_tables
- Description: Number of SHOW TABLES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_triggers
- Description: Number of SHOW TRIGGERS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_user_statistics
- Description: Number of SHOW USER STATISTICS commands executed. Removed in MariaDB 10.1.1 when that statement was replaced by the generic SHOW information_schema_table.
- Scope: Global, Session
- Data Type:
numeric
- Removed: MariaDB 10.1.1
Com_show_variable
- Description: Number of SHOW VARIABLES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_show_warnings
- Description: Number of SHOW WARNINGS commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_shutdown
- Description: Number of SHUTDOWN commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_close
- Description: Number of prepared statements closed (deallocated or dropped).
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_execute
- Description: Number of prepared statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_fetch
- Description: Number of prepared statements fetched.
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_prepare
- Description: Number of prepared statements prepared.
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_reprepare
- Description: Number of prepared statements reprepared.
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_reset
- Description: Number of prepared statements where the data of a prepared statement which was accumulated in chunks by sending long data has been reset.
- Scope: Global, Session
- Data Type:
numeric
Com_stmt_send_long_data
- Description: Number of prepared statements where the parameter data has been sent in chunks (long data).
- Scope: Global, Session
- Data Type:
numeric
Com_truncate
- Description: Number of TRUNCATE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_uninstall_plugin
- Description: Number of UNINSTALL PLUGIN commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_unlock_tables
- Description: Number of UNLOCK TABLES commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_update
- Description: Number of UPDATE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_update_multi
- Description: Number of multi-table UPDATE commands executed.
- Scope: Global, Session
- Data Type:
numeric
Com_xa_commit
- Description: Number of XA statements committed.
- Scope: Global, Session
- Data Type:
numeric
Com_xa_end
- Description: Number of XA statements ended.
- Scope: Global, Session
- Data Type:
numeric
Com_xa_prepare
- Description: Number of XA statements prepared.
- Scope: Global, Session
- Data Type:
numeric
Com_xa_recover
- Description: Number of XA RECOVER statements executed.
- Scope: Global, Session
- Data Type:
numeric
Com_xa_rollback
- Description: Number of XA statements rolled back.
- Scope: Global, Session
- Data Type:
numeric
Com_xa_start
- Description: Number of XA statements started.
- Scope: Global, Session
- Data Type:
numeric
Compression
- Description: Whether client-server traffic is compressed.
- Scope: Session
- Data Type:
boolean
Connection_errors_accept
- Description: Number of errors that occurred during calls to accept() on the listening port. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Connection_errors_internal
- Description: Number of refused connections due to internal server errors, for example out of memory errors, or failed thread starts. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Connection_errors_max_connections
- Description: Number of refused connections due to the max_connections limit being reached. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Connection_errors_peer_address
- Description: Number of errors while searching for the connecting client IP address. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Connection_errors_select
- Description: Number of errors during calls to select() or poll() on the listening port. The client would not necessarily have been rejected in these cases. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Connection_errors_tcpwrap
- Description: Number of connections the libwrap library refused. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Connections
- Description: Number of connection attempts (both successful and unsuccessful)
- Scope: Global
- Data Type:
numeric
Cpu_time
- Description: Total CPU time used. Part of User Statistics. Requires the userstat system variable to be set in order to be recorded.
- Scope: Global, Session
- Data Type:
numeric
Created_tmp_disk_tables
- Description: Number of on-disk temporary tables created.
- Scope: Global, Session
- Data Type:
numeric
Created_tmp_files
- Description: Number of temporary files created. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Created_tmp_tables
- Description: Number of in-memory temporary tables created.
- Scope: Global
- Data Type:
numeric
Delayed_errors
- Description: Number of errors which occurred while doing INSERT DELAYED. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Delayed_insert_threads
- Description: Number of INSERT DELAYED threads.
- Scope: Global
- Data Type:
numeric
Delayed_writes
- Description: Number of INSERT DELAYED rows written. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Delete_scan
- Description: Number of DELETEs that required a full table scan.
- Scope: Global
- Data Type:
numeric
Empty_queries
- Description: Number of queries returning no results. Note this is not the same as Com_empty_query.
- Scope: Global, Session
- Data Type:
numeric
Executed_events
- Description: Number of times events created with CREATE EVENT have executed. This differs from Com_create_event in that it is only incremented when the event has run, not when it executes.
- Scope: Global, Session
- Data Type:
numeric
Executed_triggers
- Description: Number of times triggers created with CREATE TRIGGER have executed. This differs from Com_create_trigger in that it is only incremented when the trigger has run, not when it executes.
- Scope: Global, Session
- Data Type:
numeric
Feature_application_time_periods
- Description: Number of times a table created with periods has been opened.
- Scope: Global, Session
- Data Type:
numeric
Feature_check_constraint
- Description: Number of times constraints were checked. The global value can be flushed by
FLUSH STATUS
. - Scope: Global, Session
- Data Type:
numeric
Feature_custom_aggregate_functions
- Description: Number of queries which make use of custom aggregate functions.
- Scope: Global, Session
- Data Type:
numeric
Feature_delay_key_write
- Description: Number of tables opened that are using delay_key_write. The global value can be flushed by
FLUSH STATUS
. - Scope: Global, Session
- Data Type:
numeric
Feature_dynamic_columns
- Description: Number of times the COLUMN_CREATE() function was used.
- Scope: Global, Session
- Data Type:
numeric
Feature_fulltext
- Description: Number of times the MATCH … AGAINST() function was used.
- Scope: Global, Session
- Data Type:
numeric
Feature_gis
- Description: Number of times a table with a any of the geometry columns was opened.
- Scope: Global, Session
- Data Type:
numeric
Feature_insert_returning
- Description:
- Scope: Global, Session
- Data Type:
numeric
- Introduced: MariaDB 10.5.0
Feature_invisible_columns
- Description: Number of invisible columns in all opened tables.
- Scope: Global, Session
- Data Type:
numeric
Feature_json
- Description: Number of times JSON functionality has been used, such as one of the JSON functions. Does not include the CONNECT engine JSON type, or EXPLAIN/ANALYZE FORMAT=JSON.
- Scope: Global, Session
- Data Type:
numeric
Feature_locale
- Description: Number of times the @@lc_messages variable was assigned into.
- Scope: Global, Session
- Data Type:
numeric
Feature_subquery
- Description: Number of subqueries (excluding subqueries in the FROM clause) used.
- Scope: Global, Session
- Data Type:
numeric
Feature_system_versioning
- Description: Number of times system versioning functionality has been used (opening a table WITH SYSTEM VERSIONING).
- Scope: Global, Session
- Data Type:
numeric
Feature_timezone
- Description: Number of times an explicit timezone (excluding UTC and SYSTEM) was specified.
- Scope: Global, Session
- Data Type:
numeric
Feature_trigger
- Description: Number of triggers loaded.
- Scope: Global, Session
- Data Type:
numeric
Feature_window_functions
- Description: Number of times window functions were used.
- Scope: Global, Session
- Data Type:
numeric
Feature_xml
- Description: Number of times XML functions (EXTRACTVALUE() and UPDATEXML()) were used.
- Scope: Global, Session
- Data Type:
numeric
Flush_commands
- Description: Number of FLUSH statements executed, as well as due to internal server flush requests. This differs from Com_flush, which simply counts FLUSH statements, not internal server flush operations.
- Scope: Global
- Data Type:
numeric
- Removed: MariaDB 10.5.1
Handler_commit
- Description: Number of internal COMMIT requests. Differs from Com_commit, which counts the number of COMMIT statements executed.
- Scope: Global, Session
- Data Type:
numeric
Handler_delete
- Description: Number of times rows have been deleted from tables. Differs from Com_delete, which counts DELETE statements.
- Scope: Global, Session
- Data Type:
numeric
Handler_discover
- Description: Discovery is when the server asks the NDBCLUSTER storage engine if it knows about a table with a given name. Handler_discover indicates the number of times that tables have been discovered in this way.
- Scope: Global, Session
- Data Type:
numeric
Handler_external_lock
- Description: Incremented for each call to the external_lock() function, which generally occurs at the beginning and end of access to a table instance.
- Scope: Global, Session
- Data Type:
numeric
Handler_icp_attempts
- Description: Number of times pushed index condition was checked. The smaller the ratio of Handler_icp_attempts to Handler_icp_match the better the filtering. See Index Condition Pushdown.
- Scope: Global, Session
- Data Type:
numeric
Handler_icp_match
- Description: Number of times pushed index condition was matched. The smaller the ratio of Handler_icp_attempts to Handler_icp_match the better the filtering. See See Index Condition Pushdown.
- Scope: Global, Session
- Data Type:
numeric
Handler_mrr_init
- Description: Counts how many MRR (multi-range read) scans were performed. See Multi Range Read optimization.
- Scope: Global, Session
- Data Type:
numeric
Handler_mrr_key_refills
- Description: Number of times key buffer was refilled (not counting the initial fill). A non-zero value indicates there wasn't enough memory to do key sort-and-sweep passes in one go. See Multi Range Read optimization.
- Scope: Global, Session
- Data Type:
numeric
Handler_mrr_rowid_refills
- Description: Number of times rowid buffer was refilled (not counting the initial fill). A non-zero value indicates there wasn't enough memory to do rowid sort-and-sweep passes in one go. See Multi Range Read optimization.
- Scope: Global, Session
- Data Type:
numeric
Handler_prepare
- Description: Number of two-phase commit prepares.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_first
- Description: Number of requests to read the first row from an index. A high value indicates many full index scans, e.g.
SELECT a FROM table_name
wherea
is an indexed column. - Scope: Global, Session
- Data Type:
numeric
Handler_read_key
- Description: Number of row read requests based on an index value. A high value indicates indexes are regularly being used, which is usually positive.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_last
- Description: Number of requests to read the last row from an index. ORDER BY DESC results in a last-key request followed by several previous-key requests.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_next
- Description: Number of requests to read the next row from an index (in order). Increments when doing an index scan or querying an index column with a range constraint.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_prev
- Description: Number of requests to read the previous row from an index (in order). Mostly used with ORDER BY DESC.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_retry
- Description: Number of read retrys triggered by semi_consistent_read (InnoDB feature).
- Scope: Global
- Data Type:
numeric
Handler_read_rnd
- Description: Number of requests to read a row based on its position. If this value is high, you may not be using joins that don't use indexes properly, or be doing many full table scans.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_rnd_deleted
- Description: Number of requests to delete a row based on its position.
- Scope: Global, Session
- Data Type:
numeric
Handler_read_rnd_next
- Description: Number of requests to read the next row. A large number of these may indicate many table scans and improperly used indexes.
- Scope: Global, Session
- Data Type:
numeric
Handler_rollback
- Description: Number of transaction rollback requests given to a storage engine. Differs from Com_rollback, which is the number of ROLLBACK commands executed.
- Scope: Global, Session
- Data Type:
numeric
Handler_savepoint
- Description: Number of transaction savepoint creation requests. Differs from Com_savepoint which is the number of SAVEPOINT commands executed.
- Scope: Global, Session
- Data Type:
numeric
Handler_savepoint_rollback
- Description: Number of requests to rollback to a transaction savepoint.
- Scope: Global, Session
- Data Type:
numeric
Handler_tmp_delete
- Description: Number of requests to delete a row in a temporary table.
- Scope: Global, Session
- Data Type:
numeric
Handler_tmp_update
- Description: Number of requests to update a row to a temporary table.
- Scope: Global, Session
- Data Type:
numeric
Handler_tmp_write
- Description: Number of requests to write a row to a temporary table.
- Scope: Global, Session
- Data Type:
numeric
Handler_update
- Description: Number of requests to update a row in a table. Since MariaDB 5.3, this no longer counts temporary tables - see Handler_tmp_update.
- Scope: Global, Session
- Data Type:
numeric
Handler_write
- Description: Number of requests to write a row to a table. Since MariaDB 5.3, this no longer counts temporary tables - see Handler_tmp_write.
- Scope: Global, Session
- Data Type:
numeric
Key_blocks_not_flushed
- Description: Number of key cache blocks which have been modified but not flushed to disk.
- Scope: Global
- Data Type:
numeric
Key_blocks_unused
- Description: Number of unused key cache blocks.
- Scope: Global
- Data Type:
numeric
Key_blocks_used
- Description: Max number of key cache blocks which have been used simultaneously.
- Scope: Global
- Data Type:
numeric
Key_blocks_warm
- Description: Number of key cache blocks in the warm list.
- Scope: Global
- Data Type:
numeric
Key_read_requests
- Description: Number of key cache block read requests. See Optimizing key_buffer_size.
- Scope: Global
- Data Type:
numeric
Key_reads
- Description: Number of physical index block reads. See Optimizing key_buffer_size.
- Scope: Global
- Data Type:
numeric
Key_write_requests
- Description: Number of requests to write a block to the key cache.
- Scope: Global
- Data Type:
numeric
Key_writes
- Description: Number of key cache block write requests
- Scope: Global
- Data Type:
numeric
Last_query_cost
- Description: The most recent query optimizer query cost calculation. Can not be calculated for complex queries, such as subqueries or UNION. It will be set to 0 for complex queries.
- Scope: Session
- Data Type:
numeric
Maria_*
- Description: When the Maria storage engine was renamed Aria, the Maria variables existing at the time were renamed at the same time. See Aria Server Status Variables.
Max_statement_time_exceeded
- Description: Number of queries that exceeded the execution time specified by max_statement_time. See Aborting statements that take longer than a certain time to execute.
- Data Type:
numeric
Max_tmp_space_used
- Description: Maximum temporary space used. See Limiting Size of Created Disk Temporary Files and Tables Overview
- Scope: Global, Session
- Data Type:
numeric
- Introduced: MariaDB 11.5
Max_used_connections
- Description: Max number of connections ever open at the same time. The global value can be flushed by FLUSH STATUS.
- Scope: Global
- Data Type:
numeric
Max_used_connections_time
- Description: The time at which the last change of max_used_connections occured. The global value can be flushed by FLUSH STATUS.
- Scope: Global
- Data Type:
datetime
- Introduced: MariaDB 11.0.2, MariaDB 11.1.1
Memory_used
- Description: Global or per-connection memory usage, in bytes. This includes all per-connection memory allocations, but excludes global allocations such as the key_buffer, innodb_buffer_pool etc.
- Scope: Global, Session
- Data Type:
numeric
Memory_used_initial
- Description: Amount of memory that was used when the server started to service the user connections.
- Scope: Global
- Data Type:
numeric
Not_flushed_delayed_rows
- Description: Number of INSERT DELAYED rows waiting to be written.
- Scope: Global
- Data Type:
numeric
Open_files
- Description: Number of regular files currently opened by the server. Does not include sockets or pipes, or storage engines using internal functions.
- Scope: Global
- Data Type:
numeric
Open_streams
- Description: Number of currently opened streams, usually log files.
- Scope: Global
- Data Type:
numeric
Open_table_definitions
- Description: Number of currently cached .frm files.
- Scope: Global
- Data Type:
numeric
Open_tables
- Description: Number of currently opened tables, excluding temporary tables.
- Scope: Global, Session
- Data Type:
numeric
Opened_files
- Description: Number of files the server has opened.
- Scope: Global
- Data Type:
numeric
Opened_plugin_libraries
- Description: Number of shared libraries that the server has opened to load plugins.
- Scope: Global
- Data Type:
numeric
Opened_table_definitions
- Description: Number of .frm files that have been cached.
- Scope: Global, Session
- Data Type:
numeric
Opened_tables
- Description: Number of tables the server has opened.
- Scope: Global, Session
- Data Type:
numeric
Opened_views
- Description: Number of views the server has opened.
- Scope: Global, Session
- Data Type:
numeric
Prepared_stmt_count
- Description: Current number of prepared statements.
- Scope: Global
- Data Type:
numeric
Qcache_free_blocks
- Description: Number of free query cache memory blocks.
- Scope: Global
- Data Type:
numeric
Qcache_free_memory
- Description: Amount of free query cache memory.
- Scope: Global
- Data Type:
numeric
Qcache_hits
- Description: Number of requests served by the query cache. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Qcache_inserts
- Description: Number of queries ever cached in the query cache. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Qcache_lowmem_prunes
- Description: Number of pruning operations performed to remove old results to make space for new results in the query cache. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Qcache_not_cached
- Description: Number of queries that are uncacheable by the query cache, or use SQL_NO_CACHE. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Qcache_queries_in_cache
- Description: Number of queries currently cached by the query cache.
- Scope: Global
- Data Type:
numeric
Qcache_total_blocks
- Description: Number of blocks used by the query cache.
- Scope: Global
- Data Type:
numeric
Queries
- Description: Number of statements executed by the server, excluding COM_PING and COM_STATISTICS. Differs from Questions in that it also counts statements executed within stored programs.
- Scope: Global, Session
- Data Type:
numeric
Questions
- Description: Number of statements executed by the server, excluding COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, and COM_STMT_RESET statements. Differs from Queries in that it doesn't count statements executed within stored programs.
- Scope: Global, Session
- Data Type:
numeric
Resultset_metadata_skipped
- Description: Number of times sending the metadata has been skipped. Metadata is not resent if metadata does not change between prepare and execute of prepared statement, or between executes.
- Scope: Global, Session
- Data Type:
numeric
- Introduced: MariaDB 10.6.0
Rows_read
- Description: Number of requests to read a row (excluding temporary tables).
- Scope: Global, Session
- Data Type:
numeric
Rows_sent
- Description:
- Scope: Global, Session
- Data Type:
numeric
Rows_tmp_read
- Description: Number of requests to read a row in a temporary table.
- Scope: Global, Session
- Data Type:
numeric
Select_full_join
- Description: Number of joins which did not use an index. If not zero, you may need to check table indexes.
- Scope: Global, Session
- Data Type:
numeric
Select_full_range_join
- Description: Number of joins which used a range search of the first table.
- Scope: Global, Session
- Data Type:
numeric
Select_range
- Description: Number of joins which used a range on the first table.
- Scope: Global, Session
- Data Type:
numeric
Select_range_check
- Description: Number of joins without keys that check for key usage after each row. If not zero, you may need to check table indexes.
- Scope: Global, Session
- Data Type:
numeric
Select_scan
- Description: Number of joins which used a full scan of the first table.
- Scope: Global, Session
- Data Type:
numeric
Slow_launch_threads
- Description: Number of threads which took longer than slow_launch_time to create. The global value can be flushed by
FLUSH STATUS
. - Scope: Global, Session
- Data Type:
numeric
Slow_queries
- Description: Number of queries which took longer than long_query_time to run. The slow query log does not need to be active for this to be recorded.
- Scope: Global, Session
- Data Type:
numeric
Sort_merge_passes
- Description: Number of merge passes performed by the sort algorithm. If too high, you may need to look at improving your query indexes, or increasing the sort_buffer_size.
- Scope: Global, Session
- Data Type:
numeric
Sort_priority_queue_sorts
- Description: The number of times that sorting was done through a priority queue. (The total number of times sorting was done is a sum Sort_range and Sort_scan). See filesort with small LIMIT optimization.
- Scope: Global, Session
- Data Type:
numeric
Sort_range
- Description: Number of sorts which used a range.
- Scope: Global, Session
- Data Type:
numeric
Sort_rows
- Description: Number of rows sorted.
- Scope: Global, Session
- Data Type:
numeric
Sort_scan
- Description: Number of sorts which used a full table scan.
- Scope: Global, Session
- Data Type:
numeric
Subquery_cache_hit
- Description: Counter for all subquery cache hits. The global value can be flushed by
FLUSH STATUS
. - Scope: Global, Session
- Data Type:
numeric
Subquery_cache_miss
- Description: Counter for all subquery cache misses. The global value can be flushed by
FLUSH STATUS
. - Scope: Global, Session
- Data Type:
numeric
Syncs
- Description: Number of times my_sync() has been called, or the number of times the server has had to force data to disk. Covers the binary log, .frm creation (if these operations are configured to sync) and some storage engines (Archive, CSV, Aria), but not XtraDB/InnoDB).
- Scope: Global, Session
- Data Type:
numeric
Table_locks_immediate
- Description: Number of table locks which were completed immediately. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Table_locks_waited
- Description: Number of table locks which had to wait. Indicates table lock contention. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Table_open_cache_active_instances
- Description: Number of active instances for open tables cache lookups.
- Scope:
- Data Type:
numeric
Table_open_cache_hits
- Description: Number of hits for open tables cache lookups.
- Scope:
- Data Type:
numeric
Table_open_cache_misses
- Description: Number of misses for open tables cache lookups.
- Scope:
- Data Type:
numeric
Table_open_cache_overflows
- Description: Number of overflows for open tables cache lookups.
- Scope:
- Data Type:
numeric
Tc_log_max_pages_used
- Description: Max number of pages used by the memory-mapped file-based transaction coordinator log. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Tc_log_page_size
- Description: Page size of the memory-mapped file-based transaction coordinator log.
- Scope: Global
- Data Type:
numeric
Tc_log_page_waits
- Description: Number of times a two-phase commit was forced to wait for a free memory-mapped file-based transaction coordinator log page. The global value can be flushed by
FLUSH STATUS
. - Scope: Global
- Data Type:
numeric
Threads_cached
- Description: Number of threads cached in the thread cache. This value will be zero if the thread pool is in use.
- Scope: Global
- Data Type:
numeric
Threads_connected
- Description: Number of clients connected to the server. See Handling Too Many Connections. The
Threads_connected
name is inaccurate when the thread pool is in use, since each client connection does not correspond to a dedicated thread in that case. - Scope: Global
- Data Type:
numeric
Threads_created
- Description: Number of threads created to respond to client connections. If too large, look at increasing thread_cache_size.
- Scope: Global
- Data Type:
numeric
Threads_running
- Description: Number of client connections that are actively running a command, and not just sleeping while waiting to receive the next command to execute. Some internal system threads also count towards this status variable if they would show up in the output of the
SHOW PROCESSLIST
statement.- In MariaDB 10.3.2 and before, a global counter was updated each time a client connection dispatched a command. In these versions, the global and session status variable are always the same value.
- In MariaDB 10.3.3 and later, the global counter has been removed as a performance improvement. Instead, when the global status variable is queried, it is calculated dynamically by essentially adding up all the running client connections as they would appear in
SHOW PROCESSLIST
output. A client connection is only considered to be running if its threadCOMMAND
value is not equal toSleep
. When the session status variable is queried, it always returns1
.
- Scope: Global
- Data Type:
numeric
Tmp_space_used
- Description: Temporary space used. See Limiting Size of Created Disk Temporary Files and Tables Overview
- Scope: Global, Session
- Data Type:
numeric
- Introduced: MariaDB 11.5
Update_scan
- Description: Number of updates that required a full table scan.
- Scope: Global
- Data Type:
numeric
Uptime
- Description: Number of seconds the server has been running.
- Scope: Global
- Data Type:
numeric
Uptime_since_flush_status
- Description: Number of seconds since the last FLUSH STATUS.
- Scope: Global
- Data Type:
numeric
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.