Status Variables for MariaDB Community Server 10.2

Overview

MariaDB Community Server stores information about its current state using status variables. To view the values on status variables, use the SHOW STATUS statement.

Variable

Aborted_clients

Aborted_connects

Access_denied_errors

Acl_column_grants

Acl_database_grants

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

Com_admin_commands

Com_alter_db

Com_alter_db_upgrade

Com_alter_event

Com_alter_function

Com_alter_procedure

Com_alter_server

Com_alter_table

Com_alter_tablespace

Com_alter_user

Com_analyze

Com_assign_to_keycache

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_procedure

Com_create_role

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_procedure

Com_drop_role

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_lock_tables

Com_multi

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_revoke

Com_revoke_all

Com_revoke_role

Com_rollback

Com_rollback_to_savepoint

Com_savepoint

Com_select

Com_set_option

Com_show_authors

Com_show_binlog_events

Com_show_binlogs

Com_show_charsets

Com_show_collations

Com_show_contributors

Com_show_create_db

Com_show_create_event

Com_show_create_func

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_errors

Com_show_events

Com_show_explain

Com_show_fields

Com_show_function_status

Com_show_generic

Com_show_grants

Com_show_keys

Com_show_master_status

Com_show_open_tables

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_status

Com_show_tables

Com_show_triggers

Com_show_variables

Com_show_warnings

Com_shutdown

Com_signal

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_check_constraint

Feature_delay_key_write

Feature_dynamic_columns

Feature_fulltext

Feature_gis

Feature_locale

Feature_subquery

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_update

Handler_tmp_write

Handler_update

Handler_write

Innodb_available_undo_logs

Innodb_buffer_pool_bytes_data

Innodb_buffer_pool_bytes_dirty

Innodb_buffer_pool_dump_status

Innodb_buffer_pool_load_status

Innodb_buffer_pool_pages_data

Innodb_buffer_pool_pages_dirty

Innodb_buffer_pool_pages_flushed

Innodb_buffer_pool_pages_free

Innodb_buffer_pool_pages_misc

Innodb_buffer_pool_pages_total

Innodb_buffer_pool_read_ahead

Innodb_buffer_pool_read_ahead_evicted

Innodb_buffer_pool_read_ahead_rnd

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

Innodb_defragment_count

Innodb_defragment_failures

Innodb_encryption_key_rotation_list_length

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_bzip2

Innodb_have_lz4

Innodb_have_lzma

Innodb_have_lzo

Innodb_have_punch_hole

Innodb_have_snappy

Innodb_log_waits

Innodb_log_write_requests

Innodb_log_writes

Innodb_num_index_pages_written

Innodb_num_non_index_pages_written

Innodb_num_open_files

Innodb_num_page_compressed_trim_op

Innodb_num_pages_decrypted

Innodb_num_pages_encrypted

Innodb_num_pages_page_compressed

Innodb_num_pages_page_compression_error

Innodb_num_pages_page_decompressed

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_size

Innodb_pages0_read

Innodb_pages_created

Innodb_pages_read

Innodb_pages_written

Innodb_row_lock_current_waits

Innodb_row_lock_time

Innodb_row_lock_time_avg

Innodb_row_lock_time_max

Innodb_row_lock_waits

Innodb_rows_deleted

Innodb_rows_inserted

Innodb_rows_read

Innodb_rows_updated

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_scrub_log

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

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

Master_gtid_wait_count

Master_gtid_wait_time

Master_gtid_wait_timeouts

Max_statement_time_exceeded

Max_used_connections

Memory_used

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

Performance_schema_accounts_lost

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

Performance_schema_mutex_classes_lost

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

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_manual_compactions_processed

Rocksdb_manual_compactions_running

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_status

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

Spider_direct_aggregate

Spider_direct_order_limit

Spider_mon_table_cache_version

Spider_mon_table_cache_version_req

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

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

Update_scan

Uptime

Uptime_since_flush_status

wsrep_applier_thread_count

wsrep_cert_deps_distance

wsrep_cluster_conf_id

wsrep_cluster_size

wsrep_cluster_state_uuid

wsrep_cluster_status

wsrep_connected

wsrep_flow_control_paused

wsrep_flow_control_paused_ns

wsrep_flow_control_recv

wsrep_flow_control_sent

wsrep_gcomm_uuid

wsrep_incoming_addresses

wsrep_last_committed

wsrep_local_bf_aborts

wsrep_local_cached_downto

wsrep_local_cert_failures

wsrep_local_commits

wsrep_local_index

wsrep_local_recv_queue

wsrep_local_recv_queue_avg

wsrep_local_recv_queue_max

wsrep_local_recv_queue_min

wsrep_local_replays

wsrep_local_send_queue

wsrep_local_send_queue_avg

wsrep_local_send_queue_max

wsrep_local_send_queue_min

wsrep_local_state

wsrep_local_state_comment

wsrep_local_state_uuid

wsrep_open_connections

wsrep_open_transactions

wsrep_protocol_version

wsrep_provider_name

wsrep_provider_vendor

wsrep_provider_version

wsrep_ready

wsrep_received

wsrep_received_bytes

wsrep_repl_data_bytes

wsrep_repl_keys

wsrep_repl_keys_bytes

wsrep_repl_other_bytes

wsrep_replicated

wsrep_replicated_bytes

wsrep_rollbacker_thread_count

wsrep_thread_count

The following Status Variables are not present in MariaDB Community Server 10.2.43 but are present in one or more older 10.2 CS versions. Click on an item to see its details, including when it was removed.

Variable

Innodb_background_log_sync

Innodb_buffer_pool_pages_lru_flushed

Innodb_buffer_pool_pages_made_not_young

Innodb_buffer_pool_pages_made_young

Innodb_buffer_pool_pages_old

Innodb_checkpoint_age

Innodb_checkpoint_max_age

Innodb_deadlocks

Innodb_have_atomic_builtins

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_lsn_current

Innodb_lsn_flushed

Innodb_lsn_last_checkpoint

Innodb_master_thread_active_loops

Innodb_master_thread_idle_loops

Innodb_max_trx_id

Innodb_mem_adaptive_hash

Innodb_mem_dictionary

Innodb_mem_total

Innodb_mutex_os_waits

Innodb_mutex_spin_rounds

Innodb_mutex_spin_waits

Innodb_num_page_compressed_trim_op_saved

Innodb_oldest_view_low_limit_trx_id

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_purge_trx_id

Innodb_purge_undo_no

Innodb_read_views_memory

Innodb_s_lock_os_waits

Innodb_s_lock_spin_rounds

Innodb_s_lock_spin_waits

Innodb_x_lock_os_waits

Innodb_x_lock_spin_rounds

Innodb_x_lock_spin_waits

Rocksdb_l0_num_files_stall_micros

Rocksdb_l0_slowdown_micros

Rocksdb_memtable_compaction_micros

Rocksdb_number_stat_computes

Rocksdb_rate_limit_delay_millis