Status Variable Index

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

A

[index top]

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

[index top]

Binlog_cache_disk_use

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

Binlog_cache_use

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

Binlog_stmt_cache_disk_use

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.1.6, “Server Status Variables”

Binlog_stmt_cache_use

Section 16.1.4.4, “Binary Log 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

[index top]

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”
Section 1.4, “What Is New in MySQL 5.6”

Connections

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

Created_tmp_disk_tables

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

Created_tmp_files

Section 5.1.6, “Server Status Variables”

Created_tmp_tables

Section 13.7.5.36, “SHOW STATUS Syntax”
Section 8.4.3.3, “How MySQL Uses Internal Temporary Tables”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 20.9.5.1, “The events_statements_current Table”

D

[index top]

Delayed_errors

Section 5.1.6, “Server Status Variables”

Delayed_insert_threads

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.6, “Server Status Variables”

Delayed_writes

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.6, “Server Status Variables”

F

[index top]

Flush_commands

Section 5.1.6, “Server Status Variables”

H

[index top]

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 5.1.6, “Server Status Variables”

Handler_read_key

Section 5.1.6, “Server Status Variables”

Handler_read_last

Section 5.1.6, “Server Status Variables”

Handler_read_next

Section 5.1.6, “Server Status Variables”

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

[index top]

Innodb_available_undo_logs

Section 14.2.7, “InnoDB Startup Options and System Variables”
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.2.6.11, “More Read-Ahead Statistics”
Section 5.1.6, “Server Status Variables”

Innodb_buffer_pool_read_ahead_evicted

Section 14.2.6.11, “More Read-Ahead Statistics”
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.2.7, “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

[index top]

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

[index top]

Last_query_cost

Section 5.1.6, “Server Status Variables”

Last_query_partial_plans

Section 5.1.6, “Server Status Variables”

M

[index top]

Max_used_connections

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

N

[index top]

Not_flushed_delayed_rows

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.6, “Server Status Variables”

O

[index top]

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

[index top]

Performance_schema_mutex_classes_lost

Section 20.5, “Performance Schema Status Monitoring”

Performance_schema_mutex_instances_lost

Section 20.5, “Performance Schema Status Monitoring”

Performance_schema_session_connect_attrs_lost

Section 20.11, “Performance Schema System Variables”

Prepared_stmt_count

Section 5.1.6, “Server Status Variables”

Q

[index top]

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

[index top]

Rpl_semi_sync_master_clients

Section 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.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 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

Rpl_semi_sync_master_status

Section 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.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 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.6, “Server Status Variables”

Rpl_semi_sync_slave_status

Section 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.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.6.2, “The SHA-256 Authentication Plugin”

S

[index top]

Select_full_join

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

Select_full_range_join

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

Select_range

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

Select_range_check

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

Select_scan

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

Slave_heartbeat_period

Section 5.1.6, “Server Status Variables”

Slave_last_heartbeat

Section 5.1.6, “Server Status Variables”

Slave_open_temp_tables

Section 16.4.1.22, “Replication and Temporary Tables”
Section 5.1.6, “Server Status Variables”

Slave_received_heartbeats

Section 5.1.6, “Server Status Variables”

Slave_retried_transactions

Section 5.1.6, “Server Status Variables”

Slave_running

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.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 20.9.5.1, “The events_statements_current Table”

Sort_range

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

Sort_rows

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

Sort_scan

Section 5.1.6, “Server Status Variables”
Section 20.9.5.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.8.3, “Using SSL Connections”

Ssl_cipher_list

Section 5.1.6, “Server Status Variables”

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

[index top]

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

[index top]

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”