Status Variables in 10.5 ES

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

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

Column_compressions

Column_decompressions

Columnstore_commit_hash

Columnstore_version

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

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

Com_show_package_body_status

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

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_hash_searches

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_free

Innodb_buffer_pool_pages_lru_flushed

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

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_buffered_aio_submitted

Innodb_checkpoint_age

Innodb_checkpoint_max_age

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

Innodb_master_thread_idle_loops

Innodb_max_trx_id

Innodb_mem_adaptive_hash

Innodb_mem_dictionary

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

Memory_used_initial

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_index_stat_lost

Performance_schema_locker_lost

Performance_schema_memory_classes_lost

Performance_schema_metadata_lock_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

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_semi_sync_master_clients

Rpl_semi_sync_master_get_ack

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_request_ack

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_send_ack

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_session_filter

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_delete

Spider_direct_order_limit

Spider_direct_update

Spider_mon_table_cache_version

Spider_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

Transactions_gtid_foreign_engine

Transactions_multi_engine

Update_scan

Uptime

Uptime_since_flush_status

wsrep

wsrep_applier_thread_count

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

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

Xpand_direct_delete

Xpand_direct_update

Xpand_select_handler_fallback