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_clientsFLUSH STATUS. numeric Aborted_connectsFLUSH STATUS. numeric Aborted_connects_preauthnumeric Access_denied_errorsnumeric Acl_column_grantsnumeric Acl_database_grantsnumeric Acl_function_grantsFUNCTION). numeric Acl_package_body_grantsnumeric Acl_package_spec_grantsnumeric Acl_procedure_grantsPROCEDURE). numeric Acl_proxy_usersnumeric Acl_role_grantsnumeric Acl_rolesis_role='Y'). numeric Acl_table_grantsnumeric Acl_usersis_role='N'). numeric Busy_timenumeric Bytes_receivednumeric Bytes_sentnumeric Com_admin_commandsnumeric Com_alter_dbnumeric Com_alter_db_upgradenumeric Com_alter_eventnumeric Com_alter_functionnumeric Com_alter_procedurenumeric Com_alter_sequencenumeric Com_alter_servernumeric Com_alter_tablenumeric Com_alter_tablespacenumeric Com_alter_usernumeric Com_analyzenumeric Com_assign_to_keycachenumeric Com_backupnumeric Com_backup_locknumeric Com_backup_tablenumeric Com_beginnumeric Com_binlognumeric Com_call_procedurenumeric Com_change_dbnumeric Com_checknumeric Com_checksumnumeric Com_commitnumeric Com_compound_sqlnumeric Com_create_dbnumeric Com_create_eventnumeric Com_create_functionnumeric Com_create_indexnumeric Com_create_packagenumeric Com_create_package_bodynumeric Com_create_procedurenumeric Com_create_rolenumeric Com_create_sequencenumeric Com_create_servernumeric Com_create_tablenumeric Com_create_temporary_tablenumeric Com_create_triggernumeric Com_create_udfnumeric Com_create_usernumeric Com_create_viewnumeric Com_dealloc_sqlnumeric Com_deletenumeric Com_delete_multinumeric Com_donumeric Com_drop_dbnumeric Com_drop_eventnumeric Com_drop_functionnumeric Com_drop_indexnumeric Com_drop_packagenumeric Com_drop_package_bodynumeric Com_drop_procedurenumeric Com_drop_rolenumeric Com_drop_sequencenumeric Com_drop_servernumeric Com_drop_tablenumeric Com_drop_temporary_tablenumeric Com_drop_triggernumeric Com_drop_usernumeric Com_drop_viewnumeric Com_empty_queryCom_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_immediatenumeric Com_execute_sqlnumeric Com_flushnumeric Com_get_diagnosticsnumeric Com_grantnumeric Com_grant_rolenumeric Com_ha_closenumeric Com_ha_opennumeric Com_ha_readnumeric Com_helpnumeric Com_insertnumeric Com_insert_selectnumeric Com_install_pluginnumeric Com_killnumeric Com_loadnumeric Com_load_master_datanumeric Com_load_master_tablenumeric Com_multinumeric Com_lock_tablesnumeric Com_optimizenumeric Com_preload_keysnumeric Com_prepare_sqlnumeric Com_purgenumeric Com_purge_before_datenumeric Com_release_savepointnumeric Com_rename_tablenumeric Com_rename_usernumeric Com_repairnumeric Com_replacenumeric Com_replace_selectnumeric Com_resetnumeric Com_resignalnumeric Com_restore_tablenumeric Com_revokenumeric Com_revoke_allnumeric Com_revoke_grantnumeric Com_rollbacknumeric Com_rollback_to_savepointnumeric Com_savepointnumeric Com_selectnumeric Com_set_optionnumeric Com_signalnumeric Com_show_authorsnumeric Com_show_binlog_eventsnumeric Com_show_binlogsnumeric Com_show_charsetsnumeric Com_show_client_statisticsnumeric Com_show_collationsnumeric Com_show_column_typesnumeric Com_show_contributorsnumeric Com_show_create_dbnumeric Com_show_create_eventnumeric Com_show_create_funcnumeric Com_show_create_packagenumeric Com_show_create_package_bodynumeric Com_show_create_procnumeric Com_show_create_tablenumeric Com_show_create_triggernumeric Com_show_create_usernumeric Com_show_databasesnumeric Com_show_engine_logsnumeric Com_show_engine_mutexnumeric Com_show_engine_statusnumeric Com_show_eventsnumeric Com_show_errorsnumeric Com_show_explainnumeric Com_show_fieldsnumeric Com_show_function_statusnumeric Com_show_genericnumeric Com_show_grantsnumeric Com_show_keysnumeric Com_show_index_statisticsnumeric Com_show_open_tablesnumeric Com_show_package_statusnumeric Com_show_package_body_statusnumeric Com_show_pluginsnumeric Com_show_privilegesnumeric Com_show_procedure_statusnumeric Com_show_processlistnumeric Com_show_profilenumeric Com_show_profilesnumeric Com_show_relaylog_eventsnumeric Com_show_statusnumericst Com_show_storage_enginesSHOW ENGINES - commands executed. numeric Com_show_table_statisticsnumeric Com_show_table_statusnumeric Com_show_tablesnumeric Com_show_triggersnumeric Com_show_user_statisticsnumeric Com_show_variablenumeric Com_show_warningsnumeric Com_shutdownnumeric Com_stmt_closenumeric Com_stmt_executenumeric Com_stmt_fetchnumeric Com_stmt_preparenumeric Com_stmt_repreparenumeric Com_stmt_resetnumeric Com_stmt_send_long_datanumeric Com_truncatenumeric Com_uninstall_pluginnumeric Com_unlock_tablesnumeric Com_updatenumeric Com_update_multinumeric Com_xa_commitnumeric Com_xa_endnumeric Com_xa_preparenumeric Com_xa_recovernumeric Com_xa_rollbacknumeric Com_xa_startnumeric Compressionboolean Connection_errors_acceptFLUSH STATUS. numeric Connection_errors_internalFLUSH STATUS. numeric Connection_errors_max_connectionsFLUSH STATUS. numeric Connection_errors_peer_addressFLUSH STATUS. numeric Connection_errors_selectFLUSH STATUS. numeric Connection_errors_tcpwrapFLUSH STATUS. numeric Connectionsnumeric Cpu_timenumeric Created_tmp_disk_tablesnumeric Created_tmp_filesFLUSH STATUS. numeric Created_tmp_tablesnumeric Delayed_errorsFLUSH STATUS. numeric Delayed_insert_threadsnumeric Delayed_writesFLUSH STATUS. numeric Delete_scannumeric Empty_queriesnumeric Executed_eventsnumeric Executed_triggersnumeric Feature_application_time_periodsnumeric Feature_check_constraintFLUSH STATUS. numeric Feature_custom_aggregate_functionsnumeric Feature_delay_key_writeFLUSH STATUS. numeric Feature_dynamic_columnsnumeric Feature_fulltextnumeric Feature_gisnumeric Feature_invisible_columnsnumeric Feature_jsonnumeric Feature_localenumeric Feature_subquerynumeric Feature_system_versioningnumeric Feature_timezonenumeric Feature_triggernumeric Feature_window_functionsnumeric Feature_xmlnumeric Flush_commandsnumeric Handler_commitnumeric Handler_deletenumeric Handler_discovernumeric Handler_external_locknumeric Handler_icp_attemptsnumeric Handler_icp_matchnumeric Handler_mrr_initnumeric Handler_mrr_key_refillsnumeric Handler_mrr_rowid_refillsnumeric Handler_preparenumeric Handler_read_firstSELECT a FROM table_name where a is an indexed column. numeric Handler_read_keynumeric Handler_read_lastnumeric Handler_read_nextnumeric Handler_read_prevnumeric Handler_read_retrynumeric Handler_read_rndnumeric Handler_read_rnd_deletednumeric Handler_read_rnd_nextnumeric Handler_rollbacknumeric Handler_savepointnumeric Handler_savepoint_rollbacknumeric Handler_tmp_deletenumeric Handler_tmp_updatenumeric Handler_tmp_writenumeric Handler_updatenumeric Handler_writenumeric Key_blocks_not_flushednumeric Key_blocks_unusednumeric Key_blocks_usednumeric Key_blocks_warmnumeric Key_read_requestsnumeric Key_readsnumeric Key_write_requestsnumeric Key_writesnumeric Last_query_costnumeric Maria_*Max_statement_time_exceedednumeric Max_used_connectionsFLUSH STATUS. numeric Memory_usednumeric Memory_used_initialnumeric Not_flushed_delayed_rowsnumeric Open_filesnumeric Open_streamsnumeric Open_table_definitionsnumeric Open_tablesnumeric Opened_filesnumeric Opened_plugin_librariesnumeric Opened_table_definitionsnumeric Opened_tablesnumeric Opened_viewsnumeric Performance_schema_accounts_lostFLUSH STATUS. numeric Performance_schema_cond_classes_lostnumeric Performance_schema_cond_instances_lostFLUSH STATUS. numeric Performance_schema_digest_lostFLUSH STATUS. numeric Performance_schema_file_classes_lostnumeric Performance_schema_file_handles_lostFLUSH STATUS. numeric Performance_schema_file_instances_lostFLUSH STATUS. numeric Performance_schema_hosts_lostFLUSH STATUS. numeric Performance_schema_locker_lostFLUSH STATUS. numeric Performance_schema_mutex_classes_lostnumeric Performance_schema_mutex_instances_lostFLUSH STATUS. numeric Performance_schema_rwlock_classes_lostnumeric Performance_schema_rwlock_instances_lostFLUSH STATUS. numeric Performance_schema_session_connect_attrs_lostFLUSH STATUS. numeric Performance_schema_socket_classes_lostnumeric Performance_schema_socket_instances_lostFLUSH STATUS. numeric Performance_schema_stage_classes_lostFLUSH STATUS. numeric Performance_schema_statement_classes_lostFLUSH STATUS. numeric Performance_schema_table_handles_lostFLUSH STATUS. numeric Performance_schema_table_instances_lostFLUSH STATUS. numeric Performance_schema_thread_classes_lostnumeric Performance_schema_thread_instances_lostFLUSH STATUS. numeric Performance_schema_users_lostFLUSH STATUS. numeric Prepared_stmt_countnumeric Qcache_free_blocksnumeric Qcache_free_memorynumeric Qcache_hitsFLUSH STATUS. numeric Qcache_insertsFLUSH STATUS. numeric Qcache_lowmem_prunesFLUSH STATUS. numeric Qcache_not_cachedFLUSH STATUS. numeric Qcache_queries_in_cachenumeric Qcache_total_blocksnumeric Queriesnumeric Questionsnumeric Rows_readnumeric Rows_sentnumeric Rows_tmp_readnumeric Select_full_joinnumeric Select_full_range_joinnumeric Select_rangenumeric Select_range_checknumeric Select_scannumeric Slow_launch_threadsFLUSH STATUS. numeric Slow_queriesnumeric Sort_merge_passesnumeric Sort_priority_queue_sortsnumeric Sort_rangenumeric Sort_rowsnumeric Sort_scannumeric Subquery_cache_hitFLUSH STATUS. numeric Subquery_cache_missFLUSH STATUS. numeric Syncsnumeric Table_locks_immediateFLUSH STATUS. numeric Table_locks_waitedFLUSH STATUS. numeric Table_open_cache_active_instancesnumeric Table_open_cache_hitsnumeric Table_open_cache_missesnumeric Table_open_cache_overflowsnumeric Tc_log_max_pages_usedFLUSH STATUS. numeric Tc_log_page_sizenumeric Tc_log_page_waitsFLUSH STATUS. numeric Threads_cachednumeric Threads_connectedThreads_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_creatednumeric Threads_runningSHOW 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_scannumeric Uptimenumeric Uptime_since_flush_statusnumeric
© 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/