This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

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 B.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.6, “Server Status Variables”

Aborted_connects

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

B

[index top]

Binlog_cache_disk_use

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

Binlog_cache_use

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The Binary Log”

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”

Compression

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, “Internal Temporary Table Use in MySQL”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

Created_tmp_files

Section 5.1.6, “Server Status Variables”

Created_tmp_tables

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

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_discover

Section 17.3.3.7.3, “MySQL Cluster 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_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_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_rnd

Section 5.1.6, “Server Status Variables”

Innodb_buffer_pool_read_ahead_seq

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.2, “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_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_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”

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”

M

[index top]

Max_used_connections

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

N

[index top]

Ndb_cluster_node_id

Section 17.3.3.7.3, “MySQL Cluster Status Variables”

Ndb_config_from_host

Section 17.3.3.7.3, “MySQL Cluster Status Variables”

Ndb_config_from_port

Section 17.3.3.7.3, “MySQL Cluster Status Variables”

Ndb_number_of_data_nodes

Section 17.3.3.7.3, “MySQL Cluster Status Variables”

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_tables

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]

Prepared_stmt_count

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

Q

[index top]

Qcache_free_blocks

Section 8.10.3.3, “Query Cache Configuration”
Section 8.10.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.10.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.10.3.3, “Query Cache Configuration”
Section 8.10.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.10.3.3, “Query Cache Configuration”
Section 5.1.6, “Server Status Variables”

Qcache_total_blocks

Section 8.10.3.3, “Query Cache Configuration”
Section 8.10.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_status

Section 5.1.6, “Server Status Variables”

S

[index top]

Select_full_join

Section 5.1.6, “Server Status Variables”

Select_full_range_join

Section 5.1.6, “Server Status Variables”

Select_range

Section 5.1.6, “Server Status Variables”

Select_range_check

Section 5.1.6, “Server Status Variables”

Select_scan

Section 5.1.6, “Server Status Variables”

Slave_open_temp_tables

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

Slave_retried_transactions

Section 5.1.6, “Server Status Variables”

Slave_running

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”

Sort_range

Section 5.1.6, “Server Status Variables”

Sort_rows

Section 5.1.6, “Server Status Variables”

Sort_scan

Section 5.1.6, “Server Status Variables”

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 6.3.6.4, “Configuring MySQL to Use Secure Connections”
Section 6.3.6.3, “Secure Connection Protocols and Ciphers”
Section 5.1.6, “Server Status Variables”

Ssl_cipher_list

Section 6.3.6.3, “Secure Connection Protocols and Ciphers”
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_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 6.3.6.3, “Secure Connection Protocols and Ciphers”
Section 5.1.6, “Server Status Variables”

T

[index top]

Table_locks_immediate

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

Table_locks_waited

Section 8.11.1, “Internal Locking Methods”
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.12.6.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.12.6.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”