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 |