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:
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 mysqladmin 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.
Aborted_clients
FLUSH STATUS
. numeric
Aborted_connects
FLUSH STATUS
. numeric
Aborted_connects_preauth
numeric
Access_denied_errors
numeric
Acl_column_grants
numeric
Acl_database_grants
numeric
Acl_function_grants
FUNCTION
). numeric
Acl_package_body_grants
numeric
Acl_package_spec_grants
numeric
Acl_procedure_grants
PROCEDURE
). numeric
Acl_proxy_users
numeric
Acl_role_grants
numeric
Acl_roles
is_role='Y'
). numeric
Acl_table_grants
numeric
Acl_users
is_role='N'
). numeric
Busy_time
numeric
Bytes_received
numeric
Bytes_sent
numeric
Com_admin_commands
numeric
Com_alter_db
numeric
Com_alter_db_upgrade
numeric
Com_alter_event
numeric
Com_alter_function
numeric
Com_alter_procedure
numeric
Com_alter_sequence
numeric
Com_alter_server
numeric
Com_alter_table
numeric
Com_alter_tablespace
numeric
Com_alter_user
numeric
Com_analyze
numeric
Com_assign_to_keycache
numeric
Com_backup
numeric
Com_backup_lock
numeric
Com_backup_table
numeric
Com_begin
numeric
Com_binlog
numeric
Com_call_procedure
numeric
Com_change_db
numeric
Com_check
numeric
Com_checksum
numeric
Com_commit
numeric
Com_compound_sql
numeric
Com_create_db
numeric
Com_create_event
numeric
Com_create_function
numeric
Com_create_index
numeric
Com_create_package
numeric
Com_create_package_body
numeric
Com_create_procedure
numeric
Com_create_role
numeric
Com_create_sequence
numeric
Com_create_server
numeric
Com_create_table
numeric
Com_create_temporary_table
numeric
Com_create_trigger
numeric
Com_create_udf
numeric
Com_create_user
numeric
Com_create_view
numeric
Com_dealloc_sql
numeric
Com_delete
numeric
Com_delete_multi
numeric
Com_do
numeric
Com_drop_db
numeric
Com_drop_event
numeric
Com_drop_function
numeric
Com_drop_index
numeric
Com_drop_package
numeric
Com_drop_package_body
numeric
Com_drop_procedure
numeric
Com_drop_role
numeric
Com_drop_sequence
numeric
Com_drop_server
numeric
Com_drop_table
numeric
Com_drop_temporary_table
numeric
Com_drop_trigger
numeric
Com_drop_user
numeric
Com_drop_view
numeric
Com_empty_query
Com_empty_query
- see Empty_queries instead. An example of an empty query sent to the server is mysql --comments -e '-- sql comment'
numeric
Com_execute_immediate
numeric
Com_execute_sql
numeric
Com_flush
numeric
Com_get_diagnostics
numeric
Com_grant
numeric
Com_grant_role
numeric
Com_ha_close
numeric
Com_ha_open
numeric
Com_ha_read
numeric
Com_help
numeric
Com_insert
numeric
Com_insert_select
numeric
Com_install_plugin
numeric
Com_kill
numeric
Com_load
numeric
Com_load_master_data
numeric
Com_load_master_table
numeric
Com_multi
numeric
Com_lock_tables
numeric
Com_optimize
numeric
Com_preload_keys
numeric
Com_prepare_sql
numeric
Com_purge
numeric
Com_purge_before_date
numeric
Com_release_savepoint
numeric
Com_rename_table
numeric
Com_rename_user
numeric
Com_repair
numeric
Com_replace
numeric
Com_replace_select
numeric
Com_reset
numeric
Com_resignal
numeric
Com_restore_table
numeric
Com_revoke
numeric
Com_revoke_all
numeric
Com_revoke_grant
numeric
Com_rollback
numeric
Com_rollback_to_savepoint
numeric
Com_savepoint
numeric
Com_select
numeric
Com_set_option
numeric
Com_signal
numeric
Com_show_authors
numeric
Com_show_binlog_events
numeric
Com_show_binlogs
numeric
Com_show_charsets
numeric
Com_show_client_statistics
numeric
Com_show_collations
numeric
Com_show_column_types
numeric
Com_show_contributors
numeric
Com_show_create_db
numeric
Com_show_create_event
numeric
Com_show_create_func
numeric
Com_show_create_package
numeric
Com_show_create_package_body
numeric
Com_show_create_proc
numeric
Com_show_create_table
numeric
Com_show_create_trigger
numeric
Com_show_create_user
numeric
Com_show_databases
numeric
Com_show_engine_logs
numeric
Com_show_engine_mutex
numeric
Com_show_engine_status
numeric
Com_show_events
numeric
Com_show_errors
numeric
Com_show_explain
numeric
Com_show_fields
numeric
Com_show_function_status
numeric
Com_show_generic
numeric
Com_show_grants
numeric
Com_show_keys
numeric
Com_show_index_statistics
numeric
Com_show_open_tables
numeric
Com_show_package_status
numeric
Com_show_package_body_status
numeric
Com_show_plugins
numeric
Com_show_privileges
numeric
Com_show_procedure_status
numeric
Com_show_processlist
numeric
Com_show_profile
numeric
Com_show_profiles
numeric
Com_show_relaylog_events
numeric
Com_show_status
numeric
st Com_show_storage_engines
SHOW ENGINES
- commands executed. numeric
Com_show_table_statistics
numeric
Com_show_table_status
numeric
Com_show_tables
numeric
Com_show_triggers
numeric
Com_show_user_statistics
numeric
Com_show_variable
numeric
Com_show_warnings
numeric
Com_shutdown
numeric
Com_stmt_close
numeric
Com_stmt_execute
numeric
Com_stmt_fetch
numeric
Com_stmt_prepare
numeric
Com_stmt_reprepare
numeric
Com_stmt_reset
numeric
Com_stmt_send_long_data
numeric
Com_truncate
numeric
Com_uninstall_plugin
numeric
Com_unlock_tables
numeric
Com_update
numeric
Com_update_multi
numeric
Com_xa_commit
numeric
Com_xa_end
numeric
Com_xa_prepare
numeric
Com_xa_recover
numeric
Com_xa_rollback
numeric
Com_xa_start
numeric
Compression
boolean
Connection_errors_accept
FLUSH STATUS
. numeric
Connection_errors_internal
FLUSH STATUS
. numeric
Connection_errors_max_connections
FLUSH STATUS
. numeric
Connection_errors_peer_address
FLUSH STATUS
. numeric
Connection_errors_select
FLUSH STATUS
. numeric
Connection_errors_tcpwrap
FLUSH STATUS
. numeric
Connections
numeric
Cpu_time
numeric
Created_tmp_disk_tables
numeric
Created_tmp_files
FLUSH STATUS
. numeric
Created_tmp_tables
numeric
Delayed_errors
FLUSH STATUS
. numeric
Delayed_insert_threads
numeric
Delayed_writes
FLUSH STATUS
. numeric
Delete_scan
numeric
Empty_queries
numeric
Executed_events
numeric
Executed_triggers
numeric
Feature_application_time_periods
numeric
Feature_check_constraint
FLUSH STATUS
. numeric
Feature_custom_aggregate_functions
numeric
Feature_delay_key_write
FLUSH STATUS
. numeric
Feature_dynamic_columns
numeric
Feature_fulltext
numeric
Feature_gis
numeric
Feature_invisible_columns
numeric
Feature_json
numeric
Feature_locale
numeric
Feature_subquery
numeric
Feature_system_versioning
numeric
Feature_timezone
numeric
Feature_trigger
numeric
Feature_window_functions
numeric
Feature_xml
numeric
Flush_commands
numeric
Handler_commit
numeric
Handler_delete
numeric
Handler_discover
numeric
Handler_external_lock
numeric
Handler_icp_attempts
numeric
Handler_icp_match
numeric
Handler_mrr_init
numeric
Handler_mrr_key_refills
numeric
Handler_mrr_rowid_refills
numeric
Handler_prepare
numeric
Handler_read_first
SELECT a FROM table_name
where a
is an indexed column. numeric
Handler_read_key
numeric
Handler_read_last
numeric
Handler_read_next
numeric
Handler_read_prev
numeric
Handler_read_retry
numeric
Handler_read_rnd
numeric
Handler_read_rnd_deleted
numeric
Handler_read_rnd_next
numeric
Handler_rollback
numeric
Handler_savepoint
numeric
Handler_savepoint_rollback
numeric
Handler_tmp_delete
numeric
Handler_tmp_update
numeric
Handler_tmp_write
numeric
Handler_update
numeric
Handler_write
numeric
Key_blocks_not_flushed
numeric
Key_blocks_unused
numeric
Key_blocks_used
numeric
Key_blocks_warm
numeric
Key_read_requests
numeric
Key_reads
numeric
Key_write_requests
numeric
Key_writes
numeric
Last_query_cost
numeric
Maria_*
Max_statement_time_exceeded
numeric
Max_used_connections
FLUSH STATUS
. numeric
Memory_used
numeric
Memory_used_initial
numeric
Not_flushed_delayed_rows
numeric
Open_files
numeric
Open_streams
numeric
Open_table_definitions
numeric
Open_tables
numeric
Opened_files
numeric
Opened_plugin_libraries
numeric
Opened_table_definitions
numeric
Opened_tables
numeric
Opened_views
numeric
Performance_schema_accounts_lost
FLUSH STATUS
. numeric
Performance_schema_cond_classes_lost
numeric
Performance_schema_cond_instances_lost
FLUSH STATUS
. numeric
Performance_schema_digest_lost
FLUSH STATUS
. numeric
Performance_schema_file_classes_lost
numeric
Performance_schema_file_handles_lost
FLUSH STATUS
. numeric
Performance_schema_file_instances_lost
FLUSH STATUS
. numeric
Performance_schema_hosts_lost
FLUSH STATUS
. numeric
Performance_schema_locker_lost
FLUSH STATUS
. numeric
Performance_schema_mutex_classes_lost
numeric
Performance_schema_mutex_instances_lost
FLUSH STATUS
. numeric
Performance_schema_rwlock_classes_lost
numeric
Performance_schema_rwlock_instances_lost
FLUSH STATUS
. numeric
Performance_schema_session_connect_attrs_lost
FLUSH STATUS
. numeric
Performance_schema_socket_classes_lost
numeric
Performance_schema_socket_instances_lost
FLUSH STATUS
. numeric
Performance_schema_stage_classes_lost
FLUSH STATUS
. numeric
Performance_schema_statement_classes_lost
FLUSH STATUS
. numeric
Performance_schema_table_handles_lost
FLUSH STATUS
. numeric
Performance_schema_table_instances_lost
FLUSH STATUS
. numeric
Performance_schema_thread_classes_lost
numeric
Performance_schema_thread_instances_lost
FLUSH STATUS
. numeric
Performance_schema_users_lost
FLUSH STATUS
. numeric
Prepared_stmt_count
numeric
Qcache_free_blocks
numeric
Qcache_free_memory
numeric
Qcache_hits
FLUSH STATUS
. numeric
Qcache_inserts
FLUSH STATUS
. numeric
Qcache_lowmem_prunes
FLUSH STATUS
. numeric
Qcache_not_cached
FLUSH STATUS
. numeric
Qcache_queries_in_cache
numeric
Qcache_total_blocks
numeric
Queries
numeric
Questions
numeric
Rows_read
numeric
Rows_sent
numeric
Rows_tmp_read
numeric
Select_full_join
numeric
Select_full_range_join
numeric
Select_range
numeric
Select_range_check
numeric
Select_scan
numeric
Slow_launch_threads
FLUSH STATUS
. numeric
Slow_queries
numeric
Sort_merge_passes
numeric
Sort_priority_queue_sorts
numeric
Sort_range
numeric
Sort_rows
numeric
Sort_scan
numeric
Subquery_cache_hit
FLUSH STATUS
. numeric
Subquery_cache_miss
FLUSH STATUS
. numeric
Syncs
numeric
Table_locks_immediate
FLUSH STATUS
. numeric
Table_locks_waited
FLUSH STATUS
. numeric
Table_open_cache_active_instances
numeric
Table_open_cache_hits
numeric
Table_open_cache_misses
numeric
Table_open_cache_overflows
numeric
Tc_log_max_pages_used
FLUSH STATUS
. numeric
Tc_log_page_size
numeric
Tc_log_page_waits
FLUSH STATUS
. numeric
Threads_cached
numeric
Threads_connected
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. numeric
Threads_created
numeric
Threads_running
SHOW PROCESSLIST
statement. SHOW PROCESSLIST
output. A client connection is only considered to be running if its thread COMMAND
value is not equal to Sleep
. When the session status variable is queried, it always returns 1
. numeric
Update_scan
numeric
Uptime
numeric
Uptime_since_flush_status
numeric
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/server-status-variables/