MySQL 实验室 因为专注,所以专业。

  • 首页
  • 博客
  • 下载
  • 文档
  • 工具
  • 知识库
  • 培训及服务
  • MySQL 5.1 Reference Manual :: Status Variable Index
    • MySQL 5.1 Reference Manual
    • Preface, Notes, Licenses
    • 1 General Information
    • 2 Installing and Upgrading MySQL
    • 3 Tutorial
    • 4 MySQL Programs
    • 5 MySQL Server Administration
    • 6 Backup and Recovery
    • 7 Optimization
    • 8 Language Structure
    • 9 Internationalization and Localization
    • 10 Data Types
    • 11 Functions and Operators
    • 12 SQL Statement Syntax
    • 13 Storage Engines
    • 14 High Availability and Scalability
    • 15 MySQL Enterprise Monitor
    • 16 Replication
    • 17 MySQL Cluster NDB 6.X/7.X
    • 18 Partitioning
    • 19 Stored Programs and Views
    • 20 INFORMATION_SCHEMA Tables
    • 21 Connectors and APIs
    • 22 Extending MySQL
    • A MySQL 5.1 Frequently Asked Questions
    • B Errors, Error Codes, and Common Problems
    • C MySQL Change History
    • D Restrictions and Limits
    • Index
    • Standard Index
    • C Function Index
    • Command Index
    • Function Index
    • INFORMATION_SCHEMA Index
    • Transaction Isolation Level Index
    • JOIN Types Index
    • Operator Index
    • Option Index
    • Privileges Index
    • SQL Modes Index
    • Status Variable Index
    • Statement/Syntax Index
    • System Variable Index

    Status Variable Index

    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”

    Binlog_cache_disk_use

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.1.6, “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.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”

    Bytes_received

    Section 5.1.6, “Server Status Variables”

    Bytes_sent

    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 7.5.10, “How MySQL Uses Internal Temporary Tables”
    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 12.4.5.37, “SHOW STATUS Syntax”
    Section 7.5.10, “How MySQL Uses Internal Temporary Tables”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”

    Delayed_errors

    Section 5.1.6, “Server Status Variables”

    Delayed_insert_threads

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

    Delayed_writes

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

    Flush_commands

    Section 5.1.6, “Server Status Variables”

    Handler_commit

    Section 5.1.6, “Server Status Variables”

    Handler_delete

    Section 5.1.6, “Server Status Variables”

    Handler_discover

    Section 17.3.4.4, “MySQL Cluster 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_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”

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

    Innodb_buffer_pool_read_ahead_evicted

    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 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_have_sync_atomic

    Section 5.1.6, “Server Status Variables”

    Innodb_heap_enabled

    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”

    Innodb_wake_ups

    Section 5.1.6, “Server Status Variables”

    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”
    Section 5.1.4, “Server System 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”

    Last_query_cost

    Section 5.1.6, “Server Status Variables”

    Max_used_connections

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

    Ndb_cluster_node_id

    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Ndb_config_from_host

    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Ndb_config_from_port

    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Ndb_conflict_fn_max

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    Ndb_conflict_fn_old

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    Ndb_execute_count

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Ndb_number_of_data_nodes

    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Ndb_pruned_scan_count

    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Ndb_scan_count

    Section 17.3.4.4, “MySQL Cluster Status Variables”

    Not_flushed_delayed_rows

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

    Not_flushed_key_blocks

    Section 5.1.6, “Server Status Variables”

    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 7.4.8, “How MySQL Opens and Closes Tables”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”

    Prepared_stmt_count

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

    Qcache_free_memory

    Section 5.1.6, “Server Status Variables”

    Qcache_hits

    Section 7.5.5.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 7.5.5.3, “Query Cache Configuration”
    Section 7.5.5.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 7.5.5.3, “Query Cache Configuration”
    Section 5.1.6, “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.6, “Server Status Variables”

    Queries

    Section 5.1.6, “Server Status Variables”

    Questions

    Description
    Section 5.1.6, “Server Status Variables”

    Rpl_semi_sync_master_clients

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

    Rpl_semi_sync_master_status

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

    Rpl_semi_sync_slave_status

    Section 5.1.6, “Server Status Variables”

    Rpl_status

    Section 5.1.6, “Server Status Variables”

    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_heartbeat_period

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.3.4.4, “MySQL Cluster Status Variables”
    Section 5.1.6, “Server Status Variables”

    Slave_open_temp_tables

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

    Slave_received_heartbeats

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.3.4.4, “MySQL Cluster Status Variables”
    Section 5.1.6, “Server Status Variables”

    Slave_retried_transactions

    Section 5.1.6, “Server Status Variables”

    Slave_running

    Section 12.4.5.36, “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”

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

    Table_locks_immediate

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

    Table_locks_waited

    Section 7.3.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 7.5.7, “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 7.5.7, “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”

    Uptime

    Description
    Section 5.1.6, “Server Status Variables”

    Uptime_since_flush_status

    Section 5.1.6, “Server Status Variables”