MySQL 运行状态 extended-status 详解


使用以下命令查看 MySQL 详细运行状态:

1
mysqladmin -u root -p extended-status

不同版本的 MySQL 输出的参数个数不同。以下为从 MySQL 5.7 版本官方文档截取的输出,各个参数的详细解释见下,中文含义后续用到哪个再去翻译吧。

TIP
以下表格内容是从 MySQL 官网复制过来的,但是官网复制的是 html ,使用 html 转 markdown 在线工具转换为 markdown,但是转换后的文本是这样的 | Aborted_clients | integer | GLOBAL | ,有些不需要的字符,这时候可以使用 IDEA 编辑器的查找/替换功能,使用正则表达式匹配不需要的字符,然后替换为空字符就可以了。其中,替换小括号和里面内容的正则表达式语法如下 [\((][^\))]+[\))]

参数名 参数类型 作用域
Aborted_clients integer GLOBAL
Aborted_connects integer GLOBAL
Audit_log_current_size integer GLOBAL
Audit_log_event_max_drop_size integer GLOBAL
Audit_log_events integer GLOBAL
Audit_log_events_filtered integer GLOBAL
Audit_log_events_lost integer GLOBAL
Audit_log_events_written integer GLOBAL
Audit_log_total_size integer GLOBAL
Audit_log_write_waits integer GLOBAL
Binlog_cache_disk_use integer GLOBAL
Binlog_cache_use integer GLOBAL
Binlog_stmt_cache_disk_use integer GLOBAL
Binlog_stmt_cache_use integer GLOBAL
Bytes_received integer GLOBAL/SESSION
Bytes_sent integer GLOBAL/SESSION
Com_admin_commands integer GLOBAL/SESSION
Com_alter_db integer GLOBAL/SESSION
Com_alter_db_upgrade integer GLOBAL/SESSION
Com_alter_event integer GLOBAL/SESSION
Com_alter_function integer GLOBAL/SESSION
Com_alter_procedure integer GLOBAL/SESSION
Com_alter_server integer GLOBAL/SESSION
Com_alter_table integer GLOBAL/SESSION
Com_alter_tablespace integer GLOBAL/SESSION
Com_alter_user integer GLOBAL/SESSION
Com_analyze integer GLOBAL/SESSION
Com_assign_to_keycache integer GLOBAL/SESSION
Com_begin integer GLOBAL/SESSION
Com_binlog integer GLOBAL/SESSION
Com_call_procedure integer GLOBAL/SESSION
Com_change_db integer GLOBAL/SESSION
Com_change_master integer GLOBAL/SESSION
Com_change_repl_filter integer GLOBAL/SESSION
Com_check integer GLOBAL/SESSION
Com_checksum integer GLOBAL/SESSION
Com_commit integer GLOBAL/SESSION
Com_create_db integer GLOBAL/SESSION
Com_create_event integer GLOBAL/SESSION
Com_create_function integer GLOBAL/SESSION
Com_create_index integer GLOBAL/SESSION
Com_create_procedure integer GLOBAL/SESSION
Com_create_server integer GLOBAL/SESSION
Com_create_table integer GLOBAL/SESSION
Com_create_trigger integer GLOBAL/SESSION
Com_create_udf integer GLOBAL/SESSION
Com_create_user integer GLOBAL/SESSION
Com_create_view integer GLOBAL/SESSION
Com_dealloc_sql integer GLOBAL/SESSION
Com_delete integer GLOBAL/SESSION
Com_delete_multi integer GLOBAL/SESSION
Com_do integer GLOBAL/SESSION
Com_drop_db integer GLOBAL/SESSION
Com_drop_event integer GLOBAL/SESSION
Com_drop_function integer GLOBAL/SESSION
Com_drop_index integer GLOBAL/SESSION
Com_drop_procedure integer GLOBAL/SESSION
Com_drop_server integer GLOBAL/SESSION
Com_drop_table integer GLOBAL/SESSION
Com_drop_trigger integer GLOBAL/SESSION
Com_drop_user integer GLOBAL/SESSION
Com_drop_view integer GLOBAL/SESSION
Com_empty_query integer GLOBAL/SESSION
Com_execute_sql integer GLOBAL/SESSION
Com_explain_other integer GLOBAL/SESSION
Com_flush integer GLOBAL/SESSION
Com_get_diagnostics integer GLOBAL/SESSION
Com_grant integer GLOBAL/SESSION
Com_group_replication_start GLOBAL
Com_group_replication_stop GLOBAL
Com_ha_close integer GLOBAL/SESSION
Com_ha_open integer GLOBAL/SESSION
Com_ha_read integer GLOBAL/SESSION
Com_help integer GLOBAL/SESSION
Com_insert integer GLOBAL/SESSION
Com_insert_select integer GLOBAL/SESSION
Com_install_plugin integer GLOBAL/SESSION
Com_kill integer GLOBAL/SESSION
Com_load integer GLOBAL/SESSION
Com_lock_tables integer GLOBAL/SESSION
Com_optimize integer GLOBAL/SESSION
Com_preload_keys integer GLOBAL/SESSION
Com_prepare_sql integer GLOBAL/SESSION
Com_purge integer GLOBAL/SESSION
Com_purge_before_date integer GLOBAL/SESSION
Com_release_savepoint integer GLOBAL/SESSION
Com_rename_table integer GLOBAL/SESSION
Com_rename_user integer GLOBAL/SESSION
Com_repair integer GLOBAL/SESSION
Com_replace integer GLOBAL/SESSION
Com_replace_select integer GLOBAL/SESSION
Com_reset integer GLOBAL/SESSION
Com_resignal integer GLOBAL/SESSION
Com_revoke integer GLOBAL/SESSION
Com_revoke_all integer GLOBAL/SESSION
Com_rollback integer GLOBAL/SESSION
Com_rollback_to_savepoint integer GLOBAL/SESSION
Com_savepoint integer GLOBAL/SESSION
Com_select integer GLOBAL/SESSION
Com_set_option integer GLOBAL/SESSION
Com_show_authors integer GLOBAL/SESSION
Com_show_binlog_events integer GLOBAL/SESSION
Com_show_binlogs integer GLOBAL/SESSION
Com_show_charsets integer GLOBAL/SESSION
Com_show_collations integer GLOBAL/SESSION
Com_show_contributors integer GLOBAL/SESSION
Com_show_create_db integer GLOBAL/SESSION
Com_show_create_event integer GLOBAL/SESSION
Com_show_create_func integer GLOBAL/SESSION
Com_show_create_proc integer GLOBAL/SESSION
Com_show_create_table integer GLOBAL/SESSION
Com_show_create_trigger integer GLOBAL/SESSION
Com_show_create_user integer GLOBAL/SESSION
Com_show_databases integer GLOBAL/SESSION
Com_show_engine_logs integer GLOBAL/SESSION
Com_show_engine_mutex integer GLOBAL/SESSION
Com_show_engine_status integer GLOBAL/SESSION
Com_show_errors integer GLOBAL/SESSION
Com_show_events integer GLOBAL/SESSION
Com_show_fields integer GLOBAL/SESSION
Com_show_function_code integer GLOBAL/SESSION
Com_show_function_status integer GLOBAL/SESSION
Com_show_grants integer GLOBAL/SESSION
Com_show_keys integer GLOBAL/SESSION
Com_show_master_status integer GLOBAL/SESSION
Com_show_ndb_status integer GLOBAL/SESSION
Com_show_new_master integer GLOBAL/SESSION
Com_show_open_tables integer GLOBAL/SESSION
Com_show_plugins integer GLOBAL/SESSION
Com_show_privileges integer GLOBAL/SESSION
Com_show_procedure_code integer GLOBAL/SESSION
Com_show_procedure_status integer GLOBAL/SESSION
Com_show_processlist integer GLOBAL/SESSION
Com_show_profile integer GLOBAL/SESSION
Com_show_profiles integer GLOBAL/SESSION
Com_show_relaylog_events integer GLOBAL/SESSION
Com_show_slave_hosts integer GLOBAL/SESSION
Com_show_slave_status integer GLOBAL/SESSION
Com_show_slave_status_nonblocking integer GLOBAL/SESSION
Com_show_status integer GLOBAL/SESSION
Com_show_storage_engines integer GLOBAL/SESSION
Com_show_table_status integer GLOBAL/SESSION
Com_show_tables integer GLOBAL/SESSION
Com_show_triggers integer GLOBAL/SESSION
Com_show_variables integer GLOBAL/SESSION
Com_show_warnings integer GLOBAL/SESSION
Com_shutdown integer GLOBAL/SESSION
Com_signal integer GLOBAL/SESSION
Com_slave_start integer GLOBAL/SESSION
Com_slave_stop integer GLOBAL/SESSION
Com_stmt_close integer GLOBAL/SESSION
Com_stmt_execute integer GLOBAL/SESSION
Com_stmt_fetch integer GLOBAL/SESSION
Com_stmt_prepare integer GLOBAL/SESSION
Com_stmt_reprepare integer GLOBAL/SESSION
Com_stmt_reset integer GLOBAL/SESSION
Com_stmt_send_long_data integer GLOBAL/SESSION
Com_truncate integer GLOBAL/SESSION
Com_uninstall_plugin integer GLOBAL/SESSION
Com_unlock_tables integer GLOBAL/SESSION
Com_update integer GLOBAL/SESSION
Com_update_multi integer GLOBAL/SESSION
Com_xa_commit integer GLOBAL/SESSION
Com_xa_end integer GLOBAL/SESSION
Com_xa_prepare integer GLOBAL/SESSION
Com_xa_recover integer GLOBAL/SESSION
Com_xa_rollback integer GLOBAL/SESSION
Com_xa_start integer GLOBAL/SESSION
Compression integer SESSION
Connection_control_delay_generated GLOBAL
Connection_errors_accept integer GLOBAL
Connection_errors_internal integer GLOBAL
Connection_errors_max_connections integer GLOBAL
Connection_errors_peer_address integer GLOBAL
Connection_errors_select integer GLOBAL
Connection_errors_tcpwrap integer GLOBAL
Connections integer GLOBAL
Created_tmp_disk_tables integer GLOBAL/SESSION
Created_tmp_files integer GLOBAL
Created_tmp_tables integer GLOBAL/SESSION
Delayed_errors integer GLOBAL
Delayed_insert_threads integer GLOBAL
Delayed_writes integer GLOBAL
Firewall_access_denied integer GLOBAL
Firewall_access_granted integer GLOBAL
Firewall_cached_entries integer GLOBAL
Flush_commands integer GLOBAL
Handler_commit integer GLOBAL/SESSION
Handler_delete integer GLOBAL/SESSION
Handler_discover integer GLOBAL/SESSION
Handler_external_lock integer GLOBAL/SESSION
Handler_mrr_init integer GLOBAL/SESSION
Handler_prepare integer GLOBAL/SESSION
Handler_read_first integer GLOBAL/SESSION
Handler_read_key integer GLOBAL/SESSION
Handler_read_last integer GLOBAL/SESSION
Handler_read_next integer GLOBAL/SESSION
Handler_read_prev integer GLOBAL/SESSION
Handler_read_rnd integer GLOBAL/SESSION
Handler_read_rnd_next integer GLOBAL/SESSION
Handler_rollback integer GLOBAL/SESSION
Handler_savepoint integer GLOBAL/SESSION
Handler_savepoint_rollback integer GLOBAL/SESSION
Handler_update integer GLOBAL/SESSION
Handler_write integer GLOBAL/SESSION
Innodb_available_undo_logs integer GLOBAL
Innodb_buffer_pool_bytes_data integer GLOBAL
Innodb_buffer_pool_bytes_dirty integer GLOBAL
Innodb_buffer_pool_dump_status string GLOBAL
Innodb_buffer_pool_load_status string GLOBAL
Innodb_buffer_pool_pages_data integer GLOBAL
Innodb_buffer_pool_pages_dirty integer GLOBAL
Innodb_buffer_pool_pages_flushed integer GLOBAL
Innodb_buffer_pool_pages_free integer GLOBAL
Innodb_buffer_pool_pages_latched integer GLOBAL
Innodb_buffer_pool_pages_misc integer GLOBAL
Innodb_buffer_pool_pages_total integer GLOBAL
Innodb_buffer_pool_read_ahead integer GLOBAL
Innodb_buffer_pool_read_ahead_evicted integer GLOBAL
Innodb_buffer_pool_read_ahead_rnd integer GLOBAL
Innodb_buffer_pool_read_requests integer GLOBAL
Innodb_buffer_pool_reads integer GLOBAL
Innodb_buffer_pool_resize_status string GLOBAL
Innodb_buffer_pool_wait_free integer GLOBAL
Innodb_buffer_pool_write_requests integer GLOBAL
Innodb_data_fsyncs integer GLOBAL
Innodb_data_pending_fsyncs integer GLOBAL
Innodb_data_pending_reads integer GLOBAL
Innodb_data_pending_writes integer GLOBAL
Innodb_data_read integer GLOBAL
Innodb_data_reads integer GLOBAL
Innodb_data_writes integer GLOBAL
Innodb_data_written integer GLOBAL
Innodb_dblwr_pages_written integer GLOBAL
Innodb_dblwr_writes integer GLOBAL
Innodb_have_atomic_builtins integer GLOBAL
Innodb_log_waits integer GLOBAL
Innodb_log_write_requests integer GLOBAL
Innodb_log_writes integer GLOBAL
Innodb_num_open_files integer GLOBAL
Innodb_os_log_fsyncs integer GLOBAL
Innodb_os_log_pending_fsyncs integer GLOBAL
Innodb_os_log_pending_writes integer GLOBAL
Innodb_os_log_written integer GLOBAL
Innodb_page_size integer GLOBAL
Innodb_pages_created integer GLOBAL
Innodb_pages_read integer GLOBAL
Innodb_pages_written integer GLOBAL
Innodb_row_lock_current_waits integer GLOBAL
Innodb_row_lock_time integer GLOBAL
Innodb_row_lock_time_avg integer GLOBAL
Innodb_row_lock_time_max integer GLOBAL
Innodb_row_lock_waits integer GLOBAL
Innodb_rows_deleted integer GLOBAL
Innodb_rows_inserted integer GLOBAL
Innodb_rows_read integer GLOBAL
Innodb_rows_updated integer GLOBAL
Innodb_truncated_status_writes integer GLOBAL
Key_blocks_not_flushed integer GLOBAL
Key_blocks_unused integer GLOBAL
Key_blocks_used integer GLOBAL
Key_read_requests integer GLOBAL
Key_reads integer GLOBAL
Key_write_requests integer GLOBAL
Key_writes integer GLOBAL
Last_query_cost numeric SESSION
Last_query_partial_plans integer SESSION
Locked_connects integer GLOBAL
Max_execution_time_exceeded integer GLOBAL/SESSION
Max_execution_time_set integer GLOBAL/SESSION
Max_execution_time_set_failed integer GLOBAL/SESSION
Max_statement_time_exceeded integer GLOBAL/SESSION
Max_statement_time_set integer GLOBAL/SESSION
Max_statement_time_set_failed integer GLOBAL/SESSION
Max_used_connections integer GLOBAL
Max_used_connections_time datetime GLOBAL
mecab_charset string GLOBAL
Mysqlx_aborted_clients integer GLOBAL
Mysqlx_address string GLOBAL
Mysqlx_bytes_received integer GLOBAL/SESSION
Mysqlx_bytes_sent integer GLOBAL/SESSION
Mysqlx_connection_accept_errors integer GLOBAL/SESSION
Mysqlx_connection_errors integer GLOBAL/SESSION
Mysqlx_connections_accepted integer GLOBAL
Mysqlx_connections_closed integer GLOBAL
Mysqlx_connections_rejected integer GLOBAL
Mysqlx_crud_create_view integer GLOBAL/SESSION
Mysqlx_crud_delete integer GLOBAL/SESSION
Mysqlx_crud_drop_view integer GLOBAL/SESSION
Mysqlx_crud_find integer GLOBAL/SESSION
Mysqlx_crud_insert integer GLOBAL/SESSION
Mysqlx_crud_modify_view integer GLOBAL/SESSION
Mysqlx_crud_update integer GLOBAL/SESSION
Mysqlx_errors_sent integer GLOBAL/SESSION
Mysqlx_errors_unknown_message_type integer GLOBAL/SESSION
Mysqlx_expect_close integer GLOBAL/SESSION
Mysqlx_expect_open integer GLOBAL/SESSION
Mysqlx_init_error integer GLOBAL/SESSION
Mysqlx_notice_other_sent integer GLOBAL/SESSION
Mysqlx_notice_warning_sent integer GLOBAL/SESSION
Mysqlx_port string GLOBAL
Mysqlx_rows_sent integer GLOBAL/SESSION
Mysqlx_sessions integer GLOBAL
Mysqlx_sessions_accepted integer GLOBAL
Mysqlx_sessions_closed integer GLOBAL
Mysqlx_sessions_fatal_error integer GLOBAL
Mysqlx_sessions_killed integer GLOBAL
Mysqlx_sessions_rejected integer GLOBAL
Mysqlx_socket string GLOBAL
Mysqlx_ssl_accept_renegotiates integer GLOBAL
Mysqlx_ssl_accepts integer GLOBAL
Mysqlx_ssl_active integer GLOBAL/SESSION
Mysqlx_ssl_cipher integer GLOBAL/SESSION
Mysqlx_ssl_cipher_list integer GLOBAL/SESSION
Mysqlx_ssl_ctx_verify_depth integer GLOBAL/SESSION
Mysqlx_ssl_ctx_verify_mode integer GLOBAL/SESSION
Mysqlx_ssl_finished_accepts integer GLOBAL
Mysqlx_ssl_server_not_after integer GLOBAL
Mysqlx_ssl_server_not_before integer GLOBAL
Mysqlx_ssl_verify_depth integer GLOBAL
Mysqlx_ssl_verify_mode integer GLOBAL
Mysqlx_ssl_version integer GLOBAL/SESSION
Mysqlx_stmt_create_collection integer GLOBAL/SESSION
Mysqlx_stmt_create_collection_index integer GLOBAL/SESSION
Mysqlx_stmt_disable_notices integer GLOBAL/SESSION
Mysqlx_stmt_drop_collection integer GLOBAL/SESSION
Mysqlx_stmt_drop_collection_index integer GLOBAL/SESSION
Mysqlx_stmt_enable_notices integer GLOBAL/SESSION
Mysqlx_stmt_ensure_collection string GLOBAL/SESSION
Mysqlx_stmt_execute_mysqlx integer GLOBAL/SESSION
Mysqlx_stmt_execute_sql integer GLOBAL/SESSION
Mysqlx_stmt_execute_xplugin integer GLOBAL/SESSION
Mysqlx_stmt_kill_client integer GLOBAL/SESSION
Mysqlx_stmt_list_clients integer GLOBAL/SESSION
Mysqlx_stmt_list_notices integer GLOBAL/SESSION
Mysqlx_stmt_list_objects integer GLOBAL/SESSION
Mysqlx_stmt_ping integer GLOBAL/SESSION
Mysqlx_worker_threads integer GLOBAL
Mysqlx_worker_threads_active integer GLOBAL
Ndb_api_bytes_received_count integer GLOBAL
Ndb_api_bytes_received_count_session integer SESSION
Ndb_api_bytes_received_count_slave integer GLOBAL
Ndb_api_bytes_sent_count integer GLOBAL
Ndb_api_bytes_sent_count_slave integer GLOBAL
Ndb_api_event_bytes_count_injector integer GLOBAL
Ndb_api_event_data_count_injector integer GLOBAL
Ndb_api_event_nondata_count_injector integer GLOBAL
Ndb_api_pk_op_count integer GLOBAL
Ndb_api_pk_op_count_session integer SESSION
Ndb_api_pk_op_count_slave integer GLOBAL
Ndb_api_pruned_scan_count integer GLOBAL
Ndb_api_pruned_scan_count_session integer SESSION
Ndb_api_range_scan_count_slave integer GLOBAL
Ndb_api_read_row_count integer GLOBAL
Ndb_api_read_row_count_session integer SESSION
Ndb_api_scan_batch_count_slave integer GLOBAL
Ndb_api_table_scan_count integer GLOBAL
Ndb_api_table_scan_count_session integer SESSION
Ndb_api_trans_abort_count integer GLOBAL
Ndb_api_trans_abort_count_session integer SESSION
Ndb_api_trans_abort_count_slave integer GLOBAL
Ndb_api_trans_close_count integer GLOBAL
Ndb_api_trans_close_count_session integer SESSION
Ndb_api_trans_close_count_slave integer GLOBAL
Ndb_api_trans_commit_count integer GLOBAL
Ndb_api_trans_commit_count_session integer SESSION
Ndb_api_trans_commit_count_slave integer GLOBAL
Ndb_api_trans_local_read_row_count_slave integer GLOBAL
Ndb_api_trans_start_count integer GLOBAL
Ndb_api_trans_start_count_session integer SESSION
Ndb_api_trans_start_count_slave integer GLOBAL
Ndb_api_uk_op_count integer GLOBAL
Ndb_api_uk_op_count_slave integer GLOBAL
Ndb_api_wait_exec_complete_count integer GLOBAL
Ndb_api_wait_exec_complete_count_session integer SESSION
Ndb_api_wait_exec_complete_count_slave integer GLOBAL
Ndb_api_wait_meta_request_count integer GLOBAL
Ndb_api_wait_meta_request_count_session integer SESSION
Ndb_api_wait_nanos_count integer GLOBAL
Ndb_api_wait_nanos_count_session integer SESSION
Ndb_api_wait_nanos_count_slave integer GLOBAL
Ndb_api_wait_scan_result_count integer GLOBAL
Ndb_api_wait_scan_result_count_session integer SESSION
Ndb_api_wait_scan_result_count_slave integer GLOBAL
Ndb_cluster_node_id integer GLOBAL/SESSION
Ndb_config_from_host integer GLOBAL/SESSION
Ndb_config_from_port integer GLOBAL/SESSION
Ndb_conflict_fn_epoch_trans integer GLOBAL
Ndb_conflict_fn_max integer GLOBAL
Ndb_conflict_fn_old integer GLOBAL
Ndb_conflict_trans_detect_iter_count integer GLOBAL
Ndb_conflict_trans_row_reject_count integer GLOBAL
Ndb_last_commit_epoch_server integer GLOBAL
Ndb_last_commit_epoch_session integer SESSION
Ndb_cluster_node_id integer GLOBAL
Ndb_number_of_data_nodes integer GLOBAL
Ndb_pushed_queries_defined integer GLOBAL
Ndb_pushed_queries_executed integer GLOBAL
Ndb_scan_count integer GLOBAL
Not_flushed_delayed_rows integer GLOBAL
Ongoing_anonymous_gtid_violating_transaction_count integer GLOBAL
Ongoing_anonymous_transaction_count integer GLOBAL
Ongoing_automatic_gtid_violating_transaction_count integer GLOBAL
Open_files integer GLOBAL
Open_streams integer GLOBAL
Open_table_definitions integer GLOBAL
Open_tables integer GLOBAL/SESSION
Opened_files integer GLOBAL
Opened_table_definitions integer GLOBAL/SESSION
Opened_tables integer GLOBAL/SESSION
Performance_schema_accounts_lost integer GLOBAL
Performance_schema_cond_classes_lost integer GLOBAL
Performance_schema_cond_instances_lost integer GLOBAL
Performance_schema_digest_lost integer GLOBAL
Performance_schema_file_classes_lost integer GLOBAL
Performance_schema_file_handles_lost integer GLOBAL
Performance_schema_file_instances_lost integer GLOBAL
Performance_schema_hosts_lost integer GLOBAL
Performance_schema_index_stat_lost integer GLOBAL
Performance_schema_locker_lost integer GLOBAL
Performance_schema_memory_classes_lost integer GLOBAL
Performance_schema_metadata_lock_lost integer GLOBAL
Performance_schema_mutex_classes_lost integer GLOBAL
Performance_schema_mutex_instances_lost integer GLOBAL
Performance_schema_nested_statement_lost integer GLOBAL
Performance_schema_prepared_statements_lost integer GLOBAL
Performance_schema_program_lost integer GLOBAL
Performance_schema_rwlock_classes_lost integer GLOBAL
Performance_schema_rwlock_instances_lost integer GLOBAL
Performance_schema_session_connect_attrs_lost integer GLOBAL
Performance_schema_socket_classes_lost integer GLOBAL
Performance_schema_socket_instances_lost integer GLOBAL
Performance_schema_stage_classes_lost integer GLOBAL
Performance_schema_statement_classes_lost integer GLOBAL
Performance_schema_table_handles_lost integer GLOBAL
Performance_schema_table_instances_lost integer GLOBAL
Performance_schema_table_lock_stat_lost integer GLOBAL
Performance_schema_thread_classes_lost integer GLOBAL
Performance_schema_thread_instances_lost integer GLOBAL
Performance_schema_users_lost integer GLOBAL
Prepared_stmt_count integer GLOBAL
Qcache_free_blocks integer GLOBAL
Qcache_free_memory integer GLOBAL
Qcache_hits integer GLOBAL
Qcache_inserts integer GLOBAL
Qcache_lowmem_prunes integer GLOBAL
Qcache_not_cached integer GLOBAL
Qcache_queries_in_cache integer GLOBAL
Qcache_total_blocks integer GLOBAL
Queries integer GLOBAL/SESSION
Questions integer GLOBAL/SESSION
Rewriter_number_loaded_rules integer GLOBAL
Rewriter_number_reloads integer GLOBAL
Rewriter_number_rewritten_queries integer GLOBAL
Rewriter_reload_error boolean GLOBAL
Rpl_semi_sync_master_clients integer GLOBAL
Rpl_semi_sync_master_net_avg_wait_time integer GLOBAL
Rpl_semi_sync_master_net_wait_time integer GLOBAL
Rpl_semi_sync_master_net_waits integer GLOBAL
Rpl_semi_sync_master_no_times integer GLOBAL
Rpl_semi_sync_master_no_tx integer GLOBAL
Rpl_semi_sync_master_status boolean GLOBAL
Rpl_semi_sync_master_timefunc_failures integer GLOBAL
Rpl_semi_sync_master_tx_avg_wait_time integer GLOBAL
Rpl_semi_sync_master_tx_wait_time integer GLOBAL
Rpl_semi_sync_master_tx_waits integer GLOBAL
Rpl_semi_sync_master_wait_pos_backtraverse integer GLOBAL
Rpl_semi_sync_master_wait_sessions integer GLOBAL
Rpl_semi_sync_master_yes_tx integer GLOBAL
Rpl_semi_sync_slave_status boolean GLOBAL
Rsa_public_key string GLOBAL
Select_full_join integer GLOBAL/SESSION
Select_full_range_join integer GLOBAL/SESSION
Select_range integer GLOBAL/SESSION
Select_range_check integer GLOBAL/SESSION
Select_scan integer GLOBAL/SESSION
Slave_heartbeat_period numeric GLOBAL
Slave_last_heartbeat GLOBAL
Slave_open_temp_tables integer GLOBAL
Slave_received_heartbeats GLOBAL
Slave_retried_transactions integer GLOBAL
Slave_rows_last_search_algorithm_used string GLOBAL
Slave_running boolean GLOBAL
Slow_launch_threads integer GLOBAL/SESSION
Slow_queries integer GLOBAL/SESSION
Sort_merge_passes integer GLOBAL/SESSION
Sort_range integer GLOBAL/SESSION
Sort_rows integer GLOBAL/SESSION
Sort_scan integer GLOBAL/SESSION
Ssl_accept_renegotiates integer GLOBAL
Ssl_accepts integer GLOBAL
Ssl_callback_cache_hits integer GLOBAL
Ssl_cipher string GLOBAL/SESSION
Ssl_cipher_list string GLOBAL/SESSION
Ssl_client_connects integer GLOBAL
Ssl_connect_renegotiates integer GLOBAL
Ssl_ctx_verify_depth integer GLOBAL
Ssl_ctx_verify_mode integer GLOBAL
Ssl_default_timeout integer GLOBAL/SESSION
Ssl_finished_accepts integer GLOBAL
Ssl_finished_connects integer GLOBAL
Ssl_server_not_after integer GLOBAL/SESSION
Ssl_server_not_before integer GLOBAL/SESSION
Ssl_session_cache_hits integer GLOBAL
Ssl_session_cache_misses integer GLOBAL
Ssl_session_cache_mode string GLOBAL
Ssl_session_cache_overflows integer GLOBAL
Ssl_session_cache_size integer GLOBAL
Ssl_session_cache_timeouts integer GLOBAL
Ssl_sessions_reused integer GLOBAL/SESSION
Ssl_used_session_cache_entries integer GLOBAL
Ssl_verify_depth integer GLOBAL/SESSION
Ssl_verify_mode integer GLOBAL/SESSION
Ssl_version string GLOBAL/SESSION
Table_locks_immediate integer GLOBAL
Table_locks_waited integer GLOBAL
Table_open_cache_hits integer GLOBAL/SESSION
Table_open_cache_misses integer GLOBAL/SESSION
Table_open_cache_overflows integer GLOBAL/SESSION
Tc_log_max_pages_used integer GLOBAL
Tc_log_page_size integer GLOBAL
Tc_log_page_waits integer GLOBAL
Threads_cached integer GLOBAL
Threads_connected integer GLOBAL
Threads_created integer GLOBAL
Threads_running integer GLOBAL
Uptime integer GLOBAL
Uptime_since_flush_status integer GLOBAL
validate_password_dictionary_file_last_parsed datetime GLOBAL
validate_password_dictionary_file_words_count integer GLOBAL

参考文档:
5.1.7 Server Status Variables
Markdown 表格之调整宽度技巧