Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.1Mb
PDF (A4) - 31.1Mb
PDF (RPM) - 29.4Mb
HTML Download (TGZ) - 7.2Mb
HTML Download (Zip) - 7.2Mb
HTML Download (RPM) - 6.2Mb
Man Pages (TGZ) - 177.1Kb
Man Pages (Zip) - 287.3Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  ...  /  Server Status Variables

5.1.7 Server Status Variables

The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 13.7.5.36, “SHOW STATUS Syntax”). The optional GLOBAL keyword aggregates the values over all connections, and SESSION shows the values for the current connection.

mysql> SHOW GLOBAL STATUS;
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 0          |
| Aborted_connects                  | 0          |
| Bytes_received                    | 155372598  |
| Bytes_sent                        | 1176560426 |
...
| Connections                       | 30023      |
| Created_tmp_disk_tables           | 0          |
| Created_tmp_files                 | 3          |
| Created_tmp_tables                | 2          |
...
| Threads_created                   | 217        |
| Threads_running                   | 88         |
| Uptime                            | 1389872    |
+-----------------------------------+------------+

Several status variables provide statement counts. To determine the number of statements executed, use these relationships:

  SUM(Com_xxx) + Qcache_hits
= Questions + statements executed within stored programs
= Queries

Many status variables are reset to 0 by the FLUSH STATUS statement.

The following table lists all available server status variables:

Table 5.5 Status Variable Summary

Variable Name Variable Type Variable Scope
Aborted_clients integer GLOBAL
Aborted_connects integer GLOBAL
Audit_log_current_size integer GLOBAL
Audit_log_event_max_drop_size integer GLOBAL
Audit_log_events integer GLOBAL
Audit_log_events_filtered integer GLOBAL
Audit_log_events_lost integer GLOBAL
Audit_log_events_written integer GLOBAL
Audit_log_total_size integer GLOBAL
Audit_log_write_waits integer GLOBAL
Binlog_cache_disk_use integer GLOBAL
Binlog_cache_use integer GLOBAL
Binlog_stmt_cache_disk_use integer GLOBAL
Binlog_stmt_cache_use integer GLOBAL
Bytes_received integer GLOBAL | SESSION
Bytes_sent integer GLOBAL | SESSION
Com_admin_commands integer GLOBAL | SESSION
Com_alter_db integer GLOBAL | SESSION
Com_alter_db_upgrade integer GLOBAL | SESSION
Com_alter_event integer GLOBAL | SESSION
Com_alter_function integer GLOBAL | SESSION
Com_alter_procedure integer GLOBAL | SESSION
Com_alter_server integer GLOBAL | SESSION
Com_alter_table integer GLOBAL | SESSION
Com_alter_tablespace integer GLOBAL | SESSION
Com_alter_user integer GLOBAL | SESSION
Com_analyze integer GLOBAL | SESSION
Com_assign_to_keycache integer GLOBAL | SESSION
Com_begin integer GLOBAL | SESSION
Com_binlog integer GLOBAL | SESSION
Com_call_procedure integer GLOBAL | SESSION
Com_change_db integer GLOBAL | SESSION
Com_change_master integer GLOBAL | SESSION
Com_check integer GLOBAL | SESSION
Com_checksum integer GLOBAL | SESSION
Com_commit integer GLOBAL | SESSION
Com_create_db integer GLOBAL | SESSION
Com_create_event integer GLOBAL | SESSION
Com_create_function integer GLOBAL | SESSION
Com_create_index integer GLOBAL | SESSION
Com_create_procedure integer GLOBAL | SESSION
Com_create_server integer GLOBAL | SESSION
Com_create_table integer GLOBAL | SESSION
Com_create_trigger integer GLOBAL | SESSION
Com_create_udf integer GLOBAL | SESSION
Com_create_user integer GLOBAL | SESSION
Com_create_view integer GLOBAL | SESSION
Com_dealloc_sql integer GLOBAL | SESSION
Com_delete integer GLOBAL | SESSION
Com_delete_multi integer GLOBAL | SESSION
Com_do integer GLOBAL | SESSION
Com_drop_db integer GLOBAL | SESSION
Com_drop_event integer GLOBAL | SESSION
Com_drop_function integer GLOBAL | SESSION
Com_drop_index integer GLOBAL | SESSION
Com_drop_procedure integer GLOBAL | SESSION
Com_drop_server integer GLOBAL | SESSION
Com_drop_table integer GLOBAL | SESSION
Com_drop_trigger integer GLOBAL | SESSION
Com_drop_user integer GLOBAL | SESSION
Com_drop_view integer GLOBAL | SESSION
Com_empty_query integer GLOBAL | SESSION
Com_execute_sql integer GLOBAL | SESSION
Com_flush integer GLOBAL | SESSION
Com_get_diagnostics integer GLOBAL | SESSION
Com_grant integer GLOBAL | SESSION
Com_ha_close integer GLOBAL | SESSION
Com_ha_open integer GLOBAL | SESSION
Com_ha_read integer GLOBAL | SESSION
Com_help integer GLOBAL | SESSION
Com_insert integer GLOBAL | SESSION
Com_insert_select integer GLOBAL | SESSION
Com_install_plugin integer GLOBAL | SESSION
Com_kill integer GLOBAL | SESSION
Com_load integer GLOBAL | SESSION
Com_lock_tables integer GLOBAL | SESSION
Com_optimize integer GLOBAL | SESSION
Com_preload_keys integer GLOBAL | SESSION
Com_prepare_sql integer GLOBAL | SESSION
Com_purge integer GLOBAL | SESSION
Com_purge_before_date integer GLOBAL | SESSION
Com_release_savepoint integer GLOBAL | SESSION
Com_rename_table integer GLOBAL | SESSION
Com_rename_user integer GLOBAL | SESSION
Com_repair integer GLOBAL | SESSION
Com_replace integer GLOBAL | SESSION
Com_replace_select integer GLOBAL | SESSION
Com_reset integer GLOBAL | SESSION
Com_resignal integer GLOBAL | SESSION
Com_revoke integer GLOBAL | SESSION
Com_revoke_all integer GLOBAL | SESSION
Com_rollback integer GLOBAL | SESSION
Com_rollback_to_savepoint integer GLOBAL | SESSION
Com_savepoint integer GLOBAL | SESSION
Com_select integer GLOBAL | SESSION
Com_set_option integer GLOBAL | SESSION
Com_show_authors integer GLOBAL | SESSION
Com_show_binlog_events integer GLOBAL | SESSION
Com_show_binlogs integer GLOBAL | SESSION
Com_show_charsets integer GLOBAL | SESSION
Com_show_collations integer GLOBAL | SESSION
Com_show_contributors integer GLOBAL | SESSION
Com_show_create_db integer GLOBAL | SESSION
Com_show_create_event integer GLOBAL | SESSION
Com_show_create_func integer GLOBAL | SESSION
Com_show_create_proc integer GLOBAL | SESSION
Com_show_create_table integer GLOBAL | SESSION
Com_show_create_trigger integer GLOBAL | SESSION
Com_show_databases integer GLOBAL | SESSION
Com_show_engine_logs integer GLOBAL | SESSION
Com_show_engine_mutex integer GLOBAL | SESSION
Com_show_engine_status integer GLOBAL | SESSION
Com_show_errors integer GLOBAL | SESSION
Com_show_events integer GLOBAL | SESSION
Com_show_fields integer GLOBAL | SESSION
Com_show_function_code integer GLOBAL | SESSION
Com_show_function_status integer GLOBAL | SESSION
Com_show_grants integer GLOBAL | SESSION
Com_show_keys integer GLOBAL | SESSION
Com_show_master_status integer GLOBAL | SESSION
Com_show_ndb_status integer GLOBAL | SESSION
Com_show_new_master integer GLOBAL | SESSION
Com_show_open_tables integer GLOBAL | SESSION
Com_show_plugins integer GLOBAL | SESSION
Com_show_privileges integer GLOBAL | SESSION
Com_show_procedure_code integer GLOBAL | SESSION
Com_show_procedure_status integer GLOBAL | SESSION
Com_show_processlist integer GLOBAL | SESSION
Com_show_profile integer GLOBAL | SESSION
Com_show_profiles integer GLOBAL | SESSION
Com_show_relaylog_events integer GLOBAL | SESSION
Com_show_slave_hosts integer GLOBAL | SESSION
Com_show_slave_status integer GLOBAL | SESSION
Com_show_status integer GLOBAL | SESSION
Com_show_storage_engines integer GLOBAL | SESSION
Com_show_table_status integer GLOBAL | SESSION
Com_show_tables integer GLOBAL | SESSION
Com_show_triggers integer GLOBAL | SESSION
Com_show_variables integer GLOBAL | SESSION
Com_show_warnings integer GLOBAL | SESSION
Com_signal integer GLOBAL | SESSION
Com_slave_start integer GLOBAL | SESSION
Com_slave_stop integer GLOBAL | SESSION
Com_stmt_close integer GLOBAL | SESSION
Com_stmt_execute integer GLOBAL | SESSION
Com_stmt_fetch integer GLOBAL | SESSION
Com_stmt_prepare integer GLOBAL | SESSION
Com_stmt_reprepare integer GLOBAL | SESSION
Com_stmt_reset integer GLOBAL | SESSION
Com_stmt_send_long_data integer GLOBAL | SESSION
Com_truncate integer GLOBAL | SESSION
Com_uninstall_plugin integer GLOBAL | SESSION
Com_unlock_tables integer GLOBAL | SESSION
Com_update integer GLOBAL | SESSION
Com_update_multi integer GLOBAL | SESSION
Com_xa_commit integer GLOBAL | SESSION
Com_xa_end integer GLOBAL | SESSION
Com_xa_prepare integer GLOBAL | SESSION
Com_xa_recover integer GLOBAL | SESSION
Com_xa_rollback integer GLOBAL | SESSION
Com_xa_start integer GLOBAL | SESSION
Compression integer SESSION
Connection_control_delay_generated GLOBAL
Connection_errors_accept integer GLOBAL
Connection_errors_internal integer GLOBAL
Connection_errors_max_connections integer GLOBAL
Connection_errors_peer_address integer GLOBAL
Connection_errors_select integer GLOBAL
Connection_errors_tcpwrap integer GLOBAL
Connections integer GLOBAL
Created_tmp_disk_tables integer GLOBAL | SESSION
Created_tmp_files integer GLOBAL
Created_tmp_tables integer GLOBAL | SESSION
Delayed_errors integer GLOBAL
Delayed_insert_threads integer GLOBAL
Delayed_writes integer GLOBAL
Firewall_access_denied integer GLOBAL
Firewall_access_granted integer GLOBAL
Firewall_cached_entries integer GLOBAL
Flush_commands integer GLOBAL
Handler_commit integer GLOBAL | SESSION
Handler_delete integer GLOBAL | SESSION
Handler_discover integer GLOBAL | SESSION
Handler_external_lock integer GLOBAL | SESSION
Handler_mrr_init integer GLOBAL | SESSION
Handler_prepare integer GLOBAL | SESSION
Handler_read_first integer GLOBAL | SESSION
Handler_read_key integer GLOBAL | SESSION
Handler_read_last integer GLOBAL | SESSION
Handler_read_next integer GLOBAL | SESSION
Handler_read_prev integer GLOBAL | SESSION
Handler_read_rnd integer GLOBAL | SESSION
Handler_read_rnd_next integer GLOBAL | SESSION
Handler_rollback integer GLOBAL | SESSION
Handler_savepoint integer GLOBAL | SESSION
Handler_savepoint_rollback integer GLOBAL | SESSION
Handler_update integer GLOBAL | SESSION
Handler_write integer GLOBAL | SESSION
Innodb_available_undo_logs integer GLOBAL
Innodb_buffer_pool_bytes_data integer GLOBAL
Innodb_buffer_pool_bytes_dirty integer GLOBAL
Innodb_buffer_pool_dump_status string GLOBAL
Innodb_buffer_pool_load_status string GLOBAL
Innodb_buffer_pool_pages_data integer GLOBAL
Innodb_buffer_pool_pages_dirty integer GLOBAL
Innodb_buffer_pool_pages_flushed integer GLOBAL
Innodb_buffer_pool_pages_free integer GLOBAL
Innodb_buffer_pool_pages_latched integer GLOBAL
Innodb_buffer_pool_pages_misc integer GLOBAL
Innodb_buffer_pool_pages_total integer GLOBAL
Innodb_buffer_pool_read_ahead integer GLOBAL
Innodb_buffer_pool_read_ahead_evicted integer GLOBAL
Innodb_buffer_pool_read_ahead_rnd integer GLOBAL
Innodb_buffer_pool_read_requests integer GLOBAL
Innodb_buffer_pool_reads integer GLOBAL
Innodb_buffer_pool_wait_free integer GLOBAL
Innodb_buffer_pool_write_requests integer GLOBAL
Innodb_data_fsyncs integer GLOBAL
Innodb_data_pending_fsyncs integer GLOBAL
Innodb_data_pending_reads integer GLOBAL
Innodb_data_pending_writes integer GLOBAL
Innodb_data_read integer GLOBAL
Innodb_data_reads integer GLOBAL
Innodb_data_writes integer GLOBAL
Innodb_data_written integer GLOBAL
Innodb_dblwr_pages_written integer GLOBAL
Innodb_dblwr_writes integer GLOBAL
Innodb_have_atomic_builtins integer GLOBAL
Innodb_log_waits integer GLOBAL
Innodb_log_write_requests integer GLOBAL
Innodb_log_writes integer GLOBAL
Innodb_num_open_files integer GLOBAL
Innodb_os_log_fsyncs integer GLOBAL
Innodb_os_log_pending_fsyncs integer GLOBAL
Innodb_os_log_pending_writes integer GLOBAL
Innodb_os_log_written integer GLOBAL
Innodb_page_size integer GLOBAL
Innodb_pages_created integer GLOBAL
Innodb_pages_read integer GLOBAL
Innodb_pages_written integer GLOBAL
Innodb_row_lock_current_waits integer GLOBAL
Innodb_row_lock_time integer GLOBAL
Innodb_row_lock_time_avg integer GLOBAL
Innodb_row_lock_time_max integer GLOBAL
Innodb_row_lock_waits integer GLOBAL
Innodb_rows_deleted integer GLOBAL
Innodb_rows_inserted integer GLOBAL
Innodb_rows_read integer GLOBAL
Innodb_rows_updated integer GLOBAL
Innodb_truncated_status_writes integer GLOBAL
Key_blocks_not_flushed integer GLOBAL
Key_blocks_unused integer GLOBAL
Key_blocks_used integer GLOBAL
Key_read_requests integer GLOBAL
Key_reads integer GLOBAL
Key_write_requests integer GLOBAL
Key_writes integer GLOBAL
Last_query_cost numeric SESSION
Last_query_partial_plans integer SESSION
Max_used_connections integer GLOBAL
Ndb_api_bytes_received_count integer GLOBAL
Ndb_api_bytes_received_count_session integer SESSION
Ndb_api_bytes_received_count_slave integer GLOBAL
Ndb_api_bytes_sent_count integer GLOBAL
Ndb_api_bytes_sent_count_session integer SESSION
Ndb_api_bytes_sent_count_slave integer GLOBAL
Ndb_api_event_bytes_count integer GLOBAL
Ndb_api_event_bytes_count_injector integer GLOBAL
Ndb_api_event_data_count integer GLOBAL
Ndb_api_event_data_count_injector integer GLOBAL
Ndb_api_event_nondata_count integer GLOBAL
Ndb_api_event_nondata_count_injector integer GLOBAL
Ndb_api_pk_op_count integer GLOBAL
Ndb_api_pk_op_count_session integer SESSION
Ndb_api_pk_op_count_slave integer GLOBAL
Ndb_api_pruned_scan_count integer GLOBAL
Ndb_api_pruned_scan_count_session integer SESSION
Ndb_api_pruned_scan_count_slave integer GLOBAL
Ndb_api_range_scan_count integer GLOBAL
Ndb_api_range_scan_count_session integer SESSION
Ndb_api_range_scan_count_slave integer GLOBAL
Ndb_api_read_row_count integer GLOBAL
Ndb_api_read_row_count_session integer SESSION
Ndb_api_read_row_count_slave integer GLOBAL
Ndb_api_scan_batch_count integer GLOBAL
Ndb_api_scan_batch_count_session integer SESSION
Ndb_api_scan_batch_count_slave integer GLOBAL
Ndb_api_table_scan_count integer GLOBAL
Ndb_api_table_scan_count_session integer SESSION
Ndb_api_table_scan_count_slave integer GLOBAL
Ndb_api_trans_abort_count integer GLOBAL
Ndb_api_trans_abort_count_session integer SESSION
Ndb_api_trans_abort_count_slave integer GLOBAL
Ndb_api_trans_close_count integer GLOBAL
Ndb_api_trans_close_count_session integer SESSION
Ndb_api_trans_close_count_slave integer GLOBAL
Ndb_api_trans_commit_count integer GLOBAL
Ndb_api_trans_commit_count_session integer SESSION
Ndb_api_trans_commit_count_slave integer GLOBAL
Ndb_api_trans_local_read_row_count integer GLOBAL
Ndb_api_trans_local_read_row_count_session integer SESSION
Ndb_api_trans_local_read_row_count_slave integer GLOBAL
Ndb_api_trans_start_count integer GLOBAL
Ndb_api_trans_start_count_session integer SESSION
Ndb_api_trans_start_count_slave integer GLOBAL
Ndb_api_uk_op_count integer GLOBAL
Ndb_api_uk_op_count_session integer SESSION
Ndb_api_uk_op_count_slave integer GLOBAL
Ndb_api_wait_exec_complete_count integer GLOBAL
Ndb_api_wait_exec_complete_count_session integer SESSION
Ndb_api_wait_exec_complete_count_slave integer GLOBAL
Ndb_api_wait_meta_request_count integer GLOBAL
Ndb_api_wait_meta_request_count_session integer SESSION
Ndb_api_wait_meta_request_count_slave integer GLOBAL
Ndb_api_wait_nanos_count integer GLOBAL
Ndb_api_wait_nanos_count_session integer SESSION
Ndb_api_wait_nanos_count_slave integer GLOBAL
Ndb_api_wait_scan_result_count integer GLOBAL
Ndb_api_wait_scan_result_count_session integer SESSION
Ndb_api_wait_scan_result_count_slave integer GLOBAL
Ndb_cluster_node_id integer GLOBAL | SESSION
Ndb_config_from_host integer GLOBAL | SESSION
Ndb_config_from_port integer GLOBAL | SESSION
Ndb_conflict_fn_epoch integer GLOBAL
Ndb_conflict_fn_epoch_trans integer GLOBAL
Ndb_conflict_fn_epoch2 integer GLOBAL
Ndb_conflict_fn_epoch2_trans integer GLOBAL
Ndb_conflict_fn_max integer GLOBAL
Ndb_conflict_fn_max_del_win integer GLOBAL
Ndb_conflict_fn_old integer GLOBAL
Ndb_conflict_last_stable_epoch integer GLOBAL
Ndb_conflict_reflected_op_discard_count integer GLOBAL
Ndb_conflict_reflected_op_prepare_count integer GLOBAL
Ndb_conflict_refresh_op_count integer GLOBAL
Ndb_conflict_trans_conflict_commit_count integer GLOBAL
Ndb_conflict_trans_detect_iter_count integer GLOBAL
Ndb_conflict_trans_reject_count integer GLOBAL
Ndb_conflict_trans_row_conflict_count integer GLOBAL
Ndb_conflict_trans_row_reject_count integer GLOBAL
Ndb_epoch_delete_delete_count integer GLOBAL
Ndb_execute_count integer GLOBAL
Ndb_last_commit_epoch_server integer GLOBAL
Ndb_last_commit_epoch_session integer SESSION
Ndb_cluster_node_id integer GLOBAL
Ndb_number_of_data_nodes integer GLOBAL
Ndb_pruned_scan_count integer GLOBAL
Ndb_pushed_queries_defined integer GLOBAL
Ndb_pushed_queries_dropped integer GLOBAL
Ndb_pushed_queries_executed integer GLOBAL
Ndb_pushed_reads integer GLOBAL
Ndb_scan_count integer GLOBAL
Not_flushed_delayed_rows integer GLOBAL
Open_files integer GLOBAL
Open_streams integer GLOBAL
Open_table_definitions integer GLOBAL
Open_tables integer GLOBAL | SESSION
Opened_files integer GLOBAL
Opened_table_definitions integer GLOBAL | SESSION
Opened_tables integer GLOBAL | SESSION
Performance_schema_accounts_lost integer GLOBAL
Performance_schema_cond_classes_lost integer GLOBAL
Performance_schema_cond_instances_lost integer GLOBAL
Performance_schema_digest_lost integer GLOBAL
Performance_schema_file_classes_lost integer GLOBAL
Performance_schema_file_handles_lost integer GLOBAL
Performance_schema_file_instances_lost integer GLOBAL
Performance_schema_hosts_lost integer GLOBAL
Performance_schema_locker_lost integer GLOBAL
Performance_schema_mutex_classes_lost integer GLOBAL
Performance_schema_mutex_instances_lost integer GLOBAL
Performance_schema_rwlock_classes_lost integer GLOBAL
Performance_schema_rwlock_instances_lost integer GLOBAL
Performance_schema_session_connect_attrs_lost integer GLOBAL
Performance_schema_socket_classes_lost integer GLOBAL
Performance_schema_socket_instances_lost integer GLOBAL
Performance_schema_stage_classes_lost integer GLOBAL
Performance_schema_statement_classes_lost integer GLOBAL
Performance_schema_table_handles_lost integer GLOBAL
Performance_schema_table_instances_lost integer GLOBAL
Performance_schema_thread_classes_lost integer GLOBAL
Performance_schema_thread_instances_lost integer GLOBAL
Performance_schema_users_lost integer GLOBAL
Prepared_stmt_count integer GLOBAL
Qcache_free_blocks integer GLOBAL
Qcache_free_memory integer GLOBAL
Qcache_hits integer GLOBAL
Qcache_inserts integer GLOBAL
Qcache_lowmem_prunes integer GLOBAL
Qcache_not_cached integer GLOBAL
Qcache_queries_in_cache integer GLOBAL
Qcache_total_blocks integer GLOBAL
Queries integer GLOBAL | SESSION
Questions integer GLOBAL | SESSION
Rpl_semi_sync_master_clients integer GLOBAL
Rpl_semi_sync_master_net_avg_wait_time integer GLOBAL
Rpl_semi_sync_master_net_wait_time integer GLOBAL
Rpl_semi_sync_master_net_waits integer GLOBAL
Rpl_semi_sync_master_no_times integer GLOBAL
Rpl_semi_sync_master_no_tx integer GLOBAL
Rpl_semi_sync_master_status boolean GLOBAL
Rpl_semi_sync_master_timefunc_failures integer GLOBAL
Rpl_semi_sync_master_tx_avg_wait_time integer GLOBAL
Rpl_semi_sync_master_tx_wait_time integer GLOBAL
Rpl_semi_sync_master_tx_waits integer GLOBAL
Rpl_semi_sync_master_wait_pos_backtraverse integer GLOBAL
Rpl_semi_sync_master_wait_sessions integer GLOBAL
Rpl_semi_sync_master_yes_tx integer GLOBAL
Rpl_semi_sync_slave_status boolean GLOBAL
Rsa_public_key string GLOBAL
Select_full_join integer GLOBAL | SESSION
Select_full_range_join integer GLOBAL | SESSION
Select_range integer GLOBAL | SESSION
Select_range_check integer GLOBAL | SESSION
Select_scan integer GLOBAL | SESSION
Slave_heartbeat_period numeric GLOBAL
Slave_last_heartbeat GLOBAL
Slave_open_temp_tables integer GLOBAL
Slave_received_heartbeats GLOBAL
Slave_retried_transactions integer GLOBAL
Slave_rows_last_search_algorithm_used string GLOBAL
Slave_running boolean GLOBAL
Slow_launch_threads integer GLOBAL | SESSION
Slow_queries integer GLOBAL | SESSION
Sort_merge_passes integer GLOBAL | SESSION
Sort_range integer GLOBAL | SESSION
Sort_rows integer GLOBAL | SESSION
Sort_scan integer GLOBAL | SESSION
Ssl_accept_renegotiates integer GLOBAL
Ssl_accepts integer GLOBAL
Ssl_callback_cache_hits integer GLOBAL
Ssl_cipher string GLOBAL | SESSION
Ssl_cipher_list string GLOBAL | SESSION
Ssl_client_connects integer GLOBAL
Ssl_connect_renegotiates integer GLOBAL
Ssl_ctx_verify_depth integer GLOBAL
Ssl_ctx_verify_mode integer GLOBAL
Ssl_default_timeout integer GLOBAL | SESSION
Ssl_finished_accepts integer GLOBAL
Ssl_finished_connects integer GLOBAL
Ssl_server_not_after integer GLOBAL | SESSION
Ssl_server_not_before integer GLOBAL | SESSION
Ssl_session_cache_hits integer GLOBAL
Ssl_session_cache_misses integer GLOBAL
Ssl_session_cache_mode string GLOBAL
Ssl_session_cache_overflows integer GLOBAL
Ssl_session_cache_size integer GLOBAL
Ssl_session_cache_timeouts integer GLOBAL
Ssl_sessions_reused integer GLOBAL | SESSION
Ssl_used_session_cache_entries integer GLOBAL
Ssl_verify_depth integer GLOBAL | SESSION
Ssl_verify_mode integer GLOBAL | SESSION
Ssl_version string GLOBAL | SESSION
Table_locks_immediate integer GLOBAL
Table_locks_waited integer GLOBAL
Table_open_cache_hits integer GLOBAL | SESSION
Table_open_cache_misses integer GLOBAL | SESSION
Table_open_cache_overflows integer GLOBAL | SESSION
Tc_log_max_pages_used integer GLOBAL
Tc_log_page_size integer GLOBAL
Tc_log_page_waits integer GLOBAL
Threads_cached integer GLOBAL
Threads_connected integer GLOBAL
Threads_created integer GLOBAL
Threads_running integer GLOBAL
Uptime integer GLOBAL
Uptime_since_flush_status integer GLOBAL
validate_password_dictionary_file_last_parsed datetime GLOBAL
validate_password_dictionary_file_words_count integer GLOBAL

The status variables have the following meanings. For meanings of status variables specific to NDB Cluster, see Section 18.3.3.8.3, “NDB Cluster Status Variables”.


User Comments
  Posted by Demetrios Stavrinos on July 22, 2004
Reading the explanation for Handler read rnd next , I question it! I list some number from a test db that does almost all accesses by locating a record with a key (GE or xxx%) and then using next to access related record; yet the Handler read rnd next is relatively large.
Handler read key 42053
Handler read next 453703
Handler read rnd 696
Handler read rnd next 104378

  Posted by Heikki Hannikainen on April 28, 2006
On MySQL 5.0 the com_* variables of 'show status' are counted for the current connection only. The new undocumented command 'show global status' shows server-wide counters. (http://bugs.mysql.com/bug.php?id=19422)
  Posted by sheila yao on April 16, 2007
In version 4.0.17, the explanation to Handler_ is different:
Example:
Handler_delete:
The number of times a row was deleted from a table.
Handler_update
The number of requests to update a row in a table.
Handler_write
The number of requests to insert a row in a table.

Could this be a typo for Handler_delete? Because requests and rows updated/deleted/inserted are different concept.

Sheila

  Posted by Roel Van de Paar on September 21, 2009
There's a bug in 5.0.36 (and likely surrounding versions) for Handler_write: it increases by one every time a row from SHOW STATUS is displayed:

------
mysql> FLUSH STATUS;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL STATUS; SHOW SESSION STATUS;
[...] 224 rows in set (0.01 sec)
[...] 224 rows in set (0.01 sec)

mysql> SHOW SESSION STATUS LIKE 'Handler_write';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Handler_write | 448 |
+---------------+-------+
1 row in set (0.00 sec)
------

Given the bug for Handler_write it is not possible to find out how many rows were inserted in this version, unless you use a workaround:

Rows_inserted= Handler_write - (number of times SHOW STATUS was run * number of rows SHOW STATUS displayed)

This could be programmed further using the Com_show_status variable:

--------
mysql> SHOW SESSION STATUS LIKE 'Com_show_status';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| Com_show_status | 8 |
+-----------------+-------+
1 row in set (0.00 sec)
--------

So, on a system/version that had 224 rows in SHOW STATUS (please check), the workaround formula would be:

Rows_inserted=Handler_write-(Com_show_status * 224)

Note though that this workaround does not work when using partial SHOW STATUS statements (using LIKE etc) from time to time.
Sign Up Login You must be logged in to post a comment.