Skip navigation links
MySQL 5.4 Reference Manual :: Status Variable Index
Statement/Syntax Index »
Section Navigation      [Toggle]

Status Variable Index

Aborted_clients

Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.7, “Server Status Variables”

Aborted_connects

Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.7, “Server Status Variables”

Binlog_cache_disk_use

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.1.7, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”

Binlog_cache_use

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.1.7, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”

Bytes_received

Section 5.1.7, “Server Status Variables”

Bytes_sent

Section 5.1.7, “Server Status Variables”

Compression

Section 5.1.7, “Server Status Variables”

Connections

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

Created_tmp_disk_tables

Section 7.5.10, “How MySQL Uses Internal Temporary Tables”
Section 5.1.7, “Server Status Variables”
Section 5.1.4, “Server System Variables”

Created_tmp_files

Section 5.1.7, “Server Status Variables”

Created_tmp_tables

Section 12.4.5.36, “SHOW STATUS Syntax”
Section 7.5.10, “How MySQL Uses Internal Temporary Tables”
Section 5.1.7, “Server Status Variables”
Section 5.1.4, “Server System Variables”

Delayed_errors

Section 5.1.7, “Server Status Variables”

Delayed_insert_threads

Section 12.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.7, “Server Status Variables”

Delayed_writes

Section 12.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.7, “Server Status Variables”

Flush_commands

Section 5.1.7, “Server Status Variables”

Handler_commit

Section 5.1.7, “Server Status Variables”

Handler_delete

Section 5.1.7, “Server Status Variables”

Handler_prepare

Section 5.1.7, “Server Status Variables”

Handler_read_first

Section 5.1.7, “Server Status Variables”

Handler_read_key

Section 5.1.7, “Server Status Variables”

Handler_read_next

Section 5.1.7, “Server Status Variables”

Handler_read_prev

Section 5.1.7, “Server Status Variables”

Handler_read_rnd

Section 5.1.7, “Server Status Variables”

Handler_read_rnd_next

Section 5.1.7, “Server Status Variables”

Handler_rollback

Section 5.1.7, “Server Status Variables”

Handler_savepoint

Section 5.1.7, “Server Status Variables”

Handler_savepoint_rollback

Section 5.1.7, “Server Status Variables”

Handler_update

Section 5.1.7, “Server Status Variables”

Handler_write

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_data

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_dirty

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_flushed

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_free

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_latched

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_misc

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_pages_total

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_read_ahead

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_read_ahead_evicted

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_read_ahead_rnd

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_read_ahead_seq

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_read_requests

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_reads

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_wait_free

Section 5.1.7, “Server Status Variables”

Innodb_buffer_pool_write_requests

Section 5.1.7, “Server Status Variables”

Innodb_data_fsyncs

Section 5.1.7, “Server Status Variables”

Innodb_data_pending_fsyncs

Section 5.1.7, “Server Status Variables”

Innodb_data_pending_reads

Section 5.1.7, “Server Status Variables”

Innodb_data_pending_writes

Section 5.1.7, “Server Status Variables”

Innodb_data_read

Section 5.1.7, “Server Status Variables”

Innodb_data_reads

Section 5.1.7, “Server Status Variables”

Innodb_data_writes

Section 5.1.7, “Server Status Variables”

Innodb_data_written

Section 5.1.7, “Server Status Variables”

Innodb_dblwr_pages_written

Section 5.1.7, “Server Status Variables”

Innodb_dblwr_writes

Section 5.1.7, “Server Status Variables”

Innodb_have_atomic_builtins

Section 1.5.5, “Configuration Differences in MySQL 5.4 from MySQL 5.1”
Section 1.5.4, “Diagnostic and Monitoring Capabilities”
Section 1.5.1, “Scalability Improvements”
Section 5.1.7, “Server Status Variables”

Innodb_have_sync_atomic

Section 5.1.7, “Server Status Variables”

Innodb_heap_enabled

Section 5.1.7, “Server Status Variables”

Innodb_log_waits

Section 5.1.7, “Server Status Variables”

Innodb_log_write_requests

Section 5.1.7, “Server Status Variables”

Innodb_log_writes

Section 5.1.7, “Server Status Variables”

Innodb_os_log_fsyncs

Section 5.1.7, “Server Status Variables”

Innodb_os_log_pending_fsyncs

Section 5.1.7, “Server Status Variables”

Innodb_os_log_pending_writes

Section 5.1.7, “Server Status Variables”

Innodb_os_log_written

Section 5.1.7, “Server Status Variables”

Innodb_page_size

Section 5.1.7, “Server Status Variables”

Innodb_pages_created

Section 5.1.7, “Server Status Variables”

Innodb_pages_read

Section 5.1.7, “Server Status Variables”

Innodb_pages_written

Section 5.1.7, “Server Status Variables”

Innodb_row_lock_current_waits

Section 5.1.7, “Server Status Variables”

Innodb_row_lock_time

Section 5.1.7, “Server Status Variables”

Innodb_row_lock_time_avg

Section 5.1.7, “Server Status Variables”

Innodb_row_lock_time_max

Section 5.1.7, “Server Status Variables”

Innodb_row_lock_waits

Section 5.1.7, “Server Status Variables”

Innodb_rows_deleted

Section 5.1.7, “Server Status Variables”

Innodb_rows_inserted

Section 5.1.7, “Server Status Variables”

Innodb_rows_read

Section 5.1.7, “Server Status Variables”

Innodb_rows_updated

Section 5.1.7, “Server Status Variables”

Innodb_wake_ups

Section 5.1.7, “Server Status Variables”

Key_blocks_not_flushed

Section 5.1.7, “Server Status Variables”

Key_blocks_unused

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

Key_blocks_used

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

Key_read_requests

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

Key_reads

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

Key_write_requests

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

Key_writes

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

Last_query_cost

Section 5.1.7, “Server Status Variables”

Max_used_connections

Section 12.4.6.3, “FLUSH Syntax”
Section 5.1.7, “Server Status Variables”

Not_flushed_delayed_rows

Section 12.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.7, “Server Status Variables”

Not_flushed_key_blocks

Section 5.1.7, “Server Status Variables”

Open_files

Section 5.1.7, “Server Status Variables”

Open_streams

Section 5.1.7, “Server Status Variables”

Open_table_definitions

Section 5.1.7, “Server Status Variables”

Open_tables

Section 5.1.7, “Server Status Variables”

Opened_files

Section 5.1.7, “Server Status Variables”

Opened_table_definitions

Section 5.1.7, “Server Status Variables”

Opened_tables

Section 7.4.8, “How MySQL Opens and Closes Tables”
Section 5.1.7, “Server Status Variables”
Section 5.1.4, “Server System Variables”

Prepared_stmt_count

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

Qcache_free_blocks

Section 7.5.5.3, “Query Cache Configuration”
Section 7.5.5.4, “Query Cache Status and Maintenance”
Section 5.1.7, “Server Status Variables”

Qcache_free_memory

Section 5.1.7, “Server Status Variables”

Qcache_hits

Section 7.5.5.1, “How the Query Cache Operates”
Section 5.1.7, “Server Status Variables”

Qcache_inserts

Section 5.1.7, “Server Status Variables”

Qcache_lowmem_prunes

Section 7.5.5.3, “Query Cache Configuration”
Section 7.5.5.4, “Query Cache Status and Maintenance”
Section 5.1.7, “Server Status Variables”

Qcache_not_cached

Section 5.1.7, “Server Status Variables”

Qcache_queries_in_cache

Section 7.5.5.3, “Query Cache Configuration”
Section 5.1.7, “Server Status Variables”

Qcache_total_blocks

Section 7.5.5.3, “Query Cache Configuration”
Section 7.5.5.4, “Query Cache Status and Maintenance”
Section 5.1.7, “Server Status Variables”

Queries

Section 5.1.7, “Server Status Variables”

Questions

Description
Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_clients

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_net_avg_wait_time

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_net_wait_time

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_net_waits

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_no_times

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_no_tx

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_status

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_timefunc_failures

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_tx_avg_wait_time

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_tx_wait_time

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_tx_waits

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_wait_pos_backtraverse

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_wait_sessions

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_master_yes_tx

Section 5.1.7, “Server Status Variables”

Rpl_semi_sync_slave_status

Section 5.1.7, “Server Status Variables”

Rpl_status

Section 5.1.7, “Server Status Variables”

Select_full_join

Section 5.1.7, “Server Status Variables”

Select_full_range_join

Section 5.1.7, “Server Status Variables”

Select_range

Section 5.1.7, “Server Status Variables”

Select_range_check

Section 5.1.7, “Server Status Variables”

Select_scan

Section 5.1.7, “Server Status Variables”

Slave_heartbeat_period

Section 5.1.7, “Server Status Variables”

Slave_open_temp_tables

Section 16.4.1, “Replication Features and Issues”
Section 16.4.1.25, “Replication and Temporary Tables”
Section 5.1.7, “Server Status Variables”

Slave_received_heartbeats

Section 5.1.7, “Server Status Variables”

Slave_retried_transactions

Section 5.1.7, “Server Status Variables”

Slave_running

Section 12.4.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.2.1, “Replication Implementation Details”
Section 5.1.7, “Server Status Variables”

Slow_launch_threads

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

Slow_queries

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

Sort_merge_passes

Section 5.1.7, “Server Status Variables”

Sort_range

Section 5.1.7, “Server Status Variables”

Sort_rows

Section 5.1.7, “Server Status Variables”

Sort_scan

Section 5.1.7, “Server Status Variables”

Ssl_accept_renegotiates

Section 5.1.7, “Server Status Variables”

Ssl_accepts

Section 5.1.7, “Server Status Variables”

Ssl_callback_cache_hits

Section 5.1.7, “Server Status Variables”

Ssl_cipher

Section 5.1.7, “Server Status Variables”
Section 5.5.6.2, “Using SSL Connections”

Ssl_cipher_list

Section 5.1.7, “Server Status Variables”

Ssl_client_connects

Section 5.1.7, “Server Status Variables”

Ssl_connect_renegotiates

Section 5.1.7, “Server Status Variables”

Ssl_ctx_verify_depth

Section 5.1.7, “Server Status Variables”

Ssl_ctx_verify_mode

Section 5.1.7, “Server Status Variables”

Ssl_default_timeout

Section 5.1.7, “Server Status Variables”

Ssl_finished_accepts

Section 5.1.7, “Server Status Variables”

Ssl_finished_connects

Section 5.1.7, “Server Status Variables”

Ssl_session_cache_hits

Section 5.1.7, “Server Status Variables”

Ssl_session_cache_misses

Section 5.1.7, “Server Status Variables”

Ssl_session_cache_mode

Section 5.1.7, “Server Status Variables”

Ssl_session_cache_overflows

Section 5.1.7, “Server Status Variables”

Ssl_session_cache_size

Section 5.1.7, “Server Status Variables”

Ssl_session_cache_timeouts

Section 5.1.7, “Server Status Variables”

Ssl_sessions_reused

Section 5.1.7, “Server Status Variables”

Ssl_used_session_cache_entries

Section 5.1.7, “Server Status Variables”

Ssl_verify_depth

Section 5.1.7, “Server Status Variables”

Ssl_verify_mode

Section 5.1.7, “Server Status Variables”

Ssl_version

Section 5.1.7, “Server Status Variables”

Table_locks_immediate

Section 7.3.1, “Internal Locking Methods”
Section 5.1.7, “Server Status Variables”

Table_locks_waited

Section 7.3.1, “Internal Locking Methods”
Section 5.1.7, “Server Status Variables”

Tc_log_max_pages_used

Section 5.1.7, “Server Status Variables”

Tc_log_page_size

Section 5.1.7, “Server Status Variables”

Tc_log_page_waits

Section 5.1.7, “Server Status Variables”

Threads_cached

Section 7.5.7, “How MySQL Uses Threads for Client Connections”
Section 5.1.7, “Server Status Variables”

Threads_connected

Section 5.1.7, “Server Status Variables”

Threads_created

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

Threads_running

Section 5.1.7, “Server Status Variables”

Uptime

Description
Section 5.1.7, “Server Status Variables”

Uptime_since_flush_status

Section 5.1.7, “Server Status Variables”