Status Variable Index
Prev		Next

Status Variable Index

A | B | C | D | F | H | I | K | L | M | N | O | P | Q | R | S | T | U

A

`Aborted_clients`

Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.6, “Server Status Variables”

`Aborted_connects`

Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.6, “Server Status Variables”

B

`Binlog_cache_disk_use`

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.6, “Server Status Variables”
Section 5.2.4, “The Binary Log”

`Binlog_cache_use`

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.6, “Server Status Variables”
Section 5.2.4, “The Binary Log”

`Binlog_stmt_cache_disk_use`

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.6, “Server Status Variables”

`Binlog_stmt_cache_use`

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.6, “Server Status Variables”

`Bytes_received`

Section 5.1.6, “Server Status Variables”

`Bytes_sent`

Section 5.1.6, “Server Status Variables”

C

`Com_flush`

Section 5.1.6, “Server Status Variables”

`Com_stmt_reprepare`

Section 8.9.4, “Caching of Prepared Statements and Stored Programs”

`Compression`

Section 5.1.6, “Server Status Variables”

`Connection_errors_accept`

Section 5.1.6, “Server Status Variables”

`Connection_errors_internal`

Section 5.1.6, “Server Status Variables”

`Connection_errors_max_connections`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Connection_errors_peer_addr`

Section 5.1.6, “Server Status Variables”

`Connection_errors_select`

Section 5.1.6, “Server Status Variables”

`Connection_errors_tcpwrap`

Section 5.1.6, “Server Status Variables”

`Connection_errors_xxx`

Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 5.1.6, “Server Status Variables”

`Connections`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Created_tmp_disk_tables`

Section 8.4.4, “How MySQL Uses Internal Temporary Tables”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Created_tmp_files`

Section 5.1.6, “Server Status Variables”

`Created_tmp_tables`

Section 13.7.5.34, “SHOW STATUS Syntax”
Section 8.4.4, “How MySQL Uses Internal Temporary Tables”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 21.9.6.1, “The events_statements_current Table”

D

`Delayed_errors`

Section 5.1.6, “Server Status Variables”

`Delayed_insert_threads`

Section 5.1.6, “Server Status Variables”

`Delayed_writes`

Section 5.1.6, “Server Status Variables”

F

`Flush_commands`

Section 5.1.6, “Server Status Variables”

H

`Handler_commit`

Section 5.1.6, “Server Status Variables”

`Handler_delete`

Section 5.1.6, “Server Status Variables”

`Handler_external_lock`

Section 5.1.6, “Server Status Variables”

`Handler_mrr_init`

Section 5.1.6, “Server Status Variables”

`Handler_prepare`

Section 5.1.6, “Server Status Variables”

`Handler_read_first`

Section 8.2.1.3.4, “Range Optimization of Row Constructor Expressions”
Section 5.1.6, “Server Status Variables”

`Handler_read_key`

Section 8.2.1.3.4, “Range Optimization of Row Constructor Expressions”
Section 5.1.6, “Server Status Variables”

`Handler_read_last`

Section 5.1.6, “Server Status Variables”

`Handler_read_next`

Section 8.2.1.3.4, “Range Optimization of Row Constructor Expressions”
Section 5.1.6, “Server Status Variables”
Section 8.2.1.7, “Use of Index Extensions”

`Handler_read_prev`

Section 5.1.6, “Server Status Variables”

`Handler_read_rnd`

Section 5.1.6, “Server Status Variables”

`Handler_read_rnd_next`

Section 5.1.6, “Server Status Variables”

`Handler_rollback`

Section 5.1.6, “Server Status Variables”

`Handler_savepoint`

Section 5.1.6, “Server Status Variables”

`Handler_savepoint_rollback`

Section 5.1.6, “Server Status Variables”

`Handler_update`

Section 5.1.6, “Server Status Variables”

`Handler_write`

Section 5.1.6, “Server Status Variables”

I

`Innodb_available_undo_logs`

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_bytes_data`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_bytes_dirty`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_dump_status`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_load_status`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_data`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_dirty`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_flushed`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_free`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_latched`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_misc`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_pages_total`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_read_ahead`

Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.13.7, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_read_ahead_evicted`

Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.13.7, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_read_requests`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_reads`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_wait_free`

Section 5.1.6, “Server Status Variables”

`Innodb_buffer_pool_write_requests`

Section 5.1.6, “Server Status Variables”

`Innodb_data_fsyncs`

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.6, “Server Status Variables”

`Innodb_data_pending_fsyncs`

Section 5.1.6, “Server Status Variables”

`Innodb_data_pending_reads`

Section 5.1.6, “Server Status Variables”

`Innodb_data_pending_writes`

Section 5.1.6, “Server Status Variables”

`Innodb_data_read`

Section 5.1.6, “Server Status Variables”

`Innodb_data_reads`

Section 5.1.6, “Server Status Variables”

`Innodb_data_writes`

Section 5.1.6, “Server Status Variables”

`Innodb_data_written`

Section 5.1.6, “Server Status Variables”

`Innodb_dblwr_pages_written`

Section 5.1.6, “Server Status Variables”

`Innodb_dblwr_writes`

Section 5.1.6, “Server Status Variables”

`Innodb_have_atomic_builtins`

Section 5.1.6, “Server Status Variables”

`Innodb_log_waits`

Section 5.1.6, “Server Status Variables”

`Innodb_log_write_requests`

Section 5.1.6, “Server Status Variables”

`Innodb_log_writes`

Section 5.1.6, “Server Status Variables”

`Innodb_num_open_files`

Section 5.1.6, “Server Status Variables”

`Innodb_os_log_fsyncs`

Section 5.1.6, “Server Status Variables”

`Innodb_os_log_pending_fsyncs`

Section 5.1.6, “Server Status Variables”

`Innodb_os_log_pending_writes`

Section 5.1.6, “Server Status Variables”

`Innodb_os_log_written`

Section 5.1.6, “Server Status Variables”

`Innodb_page_size`

Section 5.1.6, “Server Status Variables”

`Innodb_pages_created`

Section 5.1.6, “Server Status Variables”

`Innodb_pages_read`

Section 5.1.6, “Server Status Variables”

`Innodb_pages_written`

Section 5.1.6, “Server Status Variables”

`Innodb_row_lock_current_waits`

Section 5.1.6, “Server Status Variables”

`Innodb_row_lock_time`

Section 5.1.6, “Server Status Variables”

`Innodb_row_lock_time_avg`

Section 5.1.6, “Server Status Variables”

`Innodb_row_lock_time_max`

Section 5.1.6, “Server Status Variables”

`Innodb_row_lock_waits`

Section 5.1.6, “Server Status Variables”

`Innodb_rows_deleted`

Section 5.1.6, “Server Status Variables”

`Innodb_rows_inserted`

Section 5.1.6, “Server Status Variables”

`Innodb_rows_read`

Section 5.1.6, “Server Status Variables”

`Innodb_rows_updated`

Section 5.1.6, “Server Status Variables”

`Innodb_truncated_status_writes`

Section 5.1.6, “Server Status Variables”

K

`Key_blocks_not_flushed`

Section 5.1.6, “Server Status Variables”

`Key_blocks_unused`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Key_blocks_used`

Section 5.1.6, “Server Status Variables”

`Key_read_requests`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Key_reads`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Key_write_requests`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Key_writes`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

L

`Last_query_cost`

Section 5.1.6, “Server Status Variables”

`Last_query_partial_plans`

Section 5.1.6, “Server Status Variables”

M

`Max_statement_time_exceeded`

Section 5.1.6, “Server Status Variables”

`Max_statement_time_set`

Section 5.1.6, “Server Status Variables”

`Max_statement_time_set_failed`

Section 5.1.6, “Server Status Variables”

`Max_used_connections`

Section 13.7.6.3, “FLUSH Syntax”
Section 5.1.6, “Server Status Variables”

`Max_used_connections_time`

Section 5.1.6, “Server Status Variables”

N

`Not_flushed_delayed_rows`

Section 5.1.6, “Server Status Variables”

O

`Open_files`

Section 5.1.6, “Server Status Variables”

`Open_streams`

Section 5.1.6, “Server Status Variables”

`Open_table_definitions`

Section 5.1.6, “Server Status Variables”

`Open_tables`

Section 5.1.6, “Server Status Variables”

`Opened_files`

Section 5.1.6, “Server Status Variables”

`Opened_table_definitions`

Section 5.1.6, “Server Status Variables”

`Opened_tables`

Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

P

`Performance_schema_digest_lost`

Section 21.12, “Performance Schema System Variables”

`Performance_schema_memory_classes_lost`

Section 21.13, “Performance Schema Status Variables”

`Performance_schema_metadata_lock_lost`

Section 21.13, “Performance Schema Status Variables”
Section 21.12, “Performance Schema System Variables”

`Performance_schema_mutex_classes_lost`

Section 21.5, “Performance Schema Status Monitoring”

`Performance_schema_mutex_instances_lost`

Section 21.5, “Performance Schema Status Monitoring”

`Performance_schema_nested_statement_lost`

Section 21.13, “Performance Schema Status Variables”
Section 21.12, “Performance Schema System Variables”

`Performance_schema_prepared_statements_lost`

Section 21.13, “Performance Schema Status Variables”
Section 21.12, “Performance Schema System Variables”
Section 21.9.6.4, “The prepared_statements_instances Table”

`Performance_schema_program_lost`

Section 21.13, “Performance Schema Status Variables”
Section 21.12, “Performance Schema System Variables”

`Performance_schema_session_connect_attrs_lost`

Section 21.12, “Performance Schema System Variables”

`Performance_schema_table_handles_lost`

Section 21.12, “Performance Schema System Variables”

`Performance_schema_thread_instances_lost`

Section 21.12, “Performance Schema System Variables”

`Prepared_stmt_count`

Section 5.1.6, “Server Status Variables”

Q

`Qcache_free_blocks`

Section 8.9.3.3, “Query Cache Configuration”
Section 8.9.3.4, “Query Cache Status and Maintenance”
Section 5.1.6, “Server Status Variables”

`Qcache_free_memory`

Section 5.1.6, “Server Status Variables”

`Qcache_hits`

Section 8.9.3.1, “How the Query Cache Operates”
Section 5.1.6, “Server Status Variables”

`Qcache_inserts`

Section 5.1.6, “Server Status Variables”

`Qcache_lowmem_prunes`

Section 8.9.3.3, “Query Cache Configuration”
Section 8.9.3.4, “Query Cache Status and Maintenance”
Section 5.1.6, “Server Status Variables”

`Qcache_not_cached`

Section 5.1.6, “Server Status Variables”

`Qcache_queries_in_cache`

Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.6, “Server Status Variables”

`Qcache_total_blocks`

Section 8.9.3.3, “Query Cache Configuration”
Section 8.9.3.4, “Query Cache Status and Maintenance”
Section 5.1.6, “Server Status Variables”

`Queries`

Section 5.1.6, “Server Status Variables”

`Questions`

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.1.6, “Server Status Variables”

R

`Rpl_semi_sync_master_clients`

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_net_avg_wait_time`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_net_wait_time`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_net_waits`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_no_times`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_no_tx`

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_status`

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_timefunc_failures`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_tx_avg_wait_time`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_tx_wait_time`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_tx_waits`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_wait_pos_backtraverse`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_wait_sessions`

Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_master_yes_tx`

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

`Rpl_semi_sync_slave_status`

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

`Rsa_public_key`

Section 5.1.6, “Server Status Variables”
Section 6.3.9.4, “The SHA-256 Authentication Plugin”

S

`Select_full_join`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Select_full_range_join`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Select_range`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Select_range_check`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Select_scan`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Slave_heartbeat_period`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.6, “Server Status Variables”

`Slave_last_heartbeat`

Section 5.1.6, “Server Status Variables”

`Slave_open_temp_tables`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.4.2.7, “STOP SLAVE Syntax”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 5.1.6, “Server Status Variables”
Section 1.4, “What Is New in MySQL 5.7”

`Slave_received_heartbeats`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.6, “Server Status Variables”

`Slave_retried_transactions`

Section 5.1.6, “Server Status Variables”

`Slave_running`

Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.2.1, “Replication Implementation Details”
Section 5.1.6, “Server Status Variables”

`Slow_launch_threads`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Slow_queries`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Sort_merge_passes`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Sort_range`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Sort_rows`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Sort_scan`

Section 5.1.6, “Server Status Variables”
Section 21.9.6.1, “The events_statements_current Table”

`Ssl_accept_renegotiates`

Section 5.1.6, “Server Status Variables”

`Ssl_accepts`

Section 5.1.6, “Server Status Variables”

`Ssl_callback_cache_hits`

Section 5.1.6, “Server Status Variables”

`Ssl_cipher`

Section 5.1.6, “Server Status Variables”
Section 6.3.11.3, “Using SSL Connections”

`Ssl_cipher_list`

Section 5.1.6, “Server Status Variables”
Section 6.3.11.4, “SSL Command Options”

`Ssl_client_connects`

Section 5.1.6, “Server Status Variables”

`Ssl_connect_renegotiates`

Section 5.1.6, “Server Status Variables”

`Ssl_ctx_verify_depth`

Section 5.1.6, “Server Status Variables”

`Ssl_ctx_verify_mode`

Section 5.1.6, “Server Status Variables”

`Ssl_default_timeout`

Section 5.1.6, “Server Status Variables”

`Ssl_finished_accepts`

Section 5.1.6, “Server Status Variables”

`Ssl_finished_connects`

Section 5.1.6, “Server Status Variables”

`Ssl_server_not_after`

Section 5.1.6, “Server Status Variables”

`Ssl_server_not_before`

Section 5.1.6, “Server Status Variables”

`Ssl_session_cache_hits`

Section 5.1.6, “Server Status Variables”

`Ssl_session_cache_misses`

Section 5.1.6, “Server Status Variables”

`Ssl_session_cache_mode`

Section 5.1.6, “Server Status Variables”

`Ssl_session_cache_overflows`

Section 5.1.6, “Server Status Variables”

`Ssl_session_cache_size`

Section 5.1.6, “Server Status Variables”

`Ssl_session_cache_timeouts`

Section 5.1.6, “Server Status Variables”

`Ssl_sessions_reused`

Section 5.1.6, “Server Status Variables”

`Ssl_used_session_cache_entries`

Section 5.1.6, “Server Status Variables”

`Ssl_verify_depth`

Section 5.1.6, “Server Status Variables”

`Ssl_verify_mode`

Section 5.1.6, “Server Status Variables”

`Ssl_version`

Section 5.1.6, “Server Status Variables”

T

`Table_locks_immediate`

Section 8.10.1, “Internal Locking Methods”
Section 5.1.6, “Server Status Variables”

`Table_locks_waited`

Section 8.10.1, “Internal Locking Methods”
Section 5.1.6, “Server Status Variables”

`Table_open_cache_hits`

Section 5.1.6, “Server Status Variables”

`Table_open_cache_misses`

Section 5.1.6, “Server Status Variables”

`Table_open_cache_overflows`

Section 5.1.6, “Server Status Variables”

`Tc_log_max_pages_used`

Section 5.1.6, “Server Status Variables”

`Tc_log_page_size`

Section 5.1.6, “Server Status Variables”

`Tc_log_page_waits`

Section 5.1.6, “Server Status Variables”

`Threads_cached`

Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 5.1.6, “Server Status Variables”

`Threads_connected`

Section 5.1.6, “Server Status Variables”

`Threads_created`

Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`Threads_running`

Section 5.1.6, “Server Status Variables”

U

`Uptime`

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.1.6, “Server Status Variables”

`Uptime_since_flush_status`

Section 5.1.6, “Server Status Variables”

Prev	Up	Next
System Variable Index	Home	Transaction Isolation Level Index