Home

MySQL Variables
State    Processes   State   Variables   

 

NameValue
Aborted_clients187
Aborted_connects49324
Binlog_cache_disk_use81
Binlog_cache_use975439
Binlog_stmt_cache_disk_use167208
Binlog_stmt_cache_use3676316
Bytes_received274
Bytes_sent2803
Com_admin_commands0
Com_assign_to_keycache0
Com_alter_db0
Com_alter_db_upgrade0
Com_alter_event0
Com_alter_function0
Com_alter_procedure0
Com_alter_server0
Com_alter_table0
Com_alter_tablespace0
Com_alter_user0
Com_analyze0
Com_begin0
Com_binlog0
Com_call_procedure0
Com_change_db0
Com_change_master0
Com_check0
Com_checksum0
Com_commit0
Com_create_db0
Com_create_event0
Com_create_function0
Com_create_index0
Com_create_procedure0
Com_create_server0
Com_create_table0
Com_create_trigger0
Com_create_udf0
Com_create_user0
Com_create_view0
Com_dealloc_sql0
Com_delete0
Com_delete_multi0
Com_do0
Com_drop_db0
Com_drop_event0
Com_drop_function0
Com_drop_index0
Com_drop_procedure0
Com_drop_server0
Com_drop_table0
Com_drop_trigger0
Com_drop_user0
Com_drop_view0
Com_empty_query0
Com_execute_sql0
Com_flush0
Com_get_diagnostics0
Com_grant0
Com_ha_close0
Com_ha_open0
Com_ha_read0
Com_help0
Com_insert0
Com_insert_select0
Com_install_plugin0
Com_kill0
Com_load0
Com_lock_tables0
Com_optimize0
Com_preload_keys0
Com_prepare_sql0
Com_purge0
Com_purge_before_date0
Com_release_savepoint0
Com_rename_table0
Com_rename_user0
Com_repair0
Com_replace0
Com_replace_select0
Com_reset0
Com_resignal0
Com_revoke0
Com_revoke_all0
Com_rollback0
Com_rollback_to_savepoint0
Com_savepoint0
Com_select1
Com_set_option2
Com_signal0
Com_show_binlog_events0
Com_show_binlogs0
Com_show_charsets1
Com_show_collations0
Com_show_create_db0
Com_show_create_event0
Com_show_create_func0
Com_show_create_proc0
Com_show_create_table0
Com_show_create_trigger0
Com_show_databases0
Com_show_engine_logs0
Com_show_engine_mutex0
Com_show_engine_status0
Com_show_events0
Com_show_errors0
Com_show_fields0
Com_show_function_code0
Com_show_function_status0
Com_show_grants0
Com_show_keys0
Com_show_master_status0
Com_show_open_tables0
Com_show_plugins0
Com_show_privileges0
Com_show_procedure_code0
Com_show_procedure_status0
Com_show_processlist0
Com_show_profile0
Com_show_profiles0
Com_show_relaylog_events0
Com_show_slave_hosts0
Com_show_slave_status0
Com_show_status1
Com_show_storage_engines0
Com_show_table_status0
Com_show_tables0
Com_show_triggers0
Com_show_variables1
Com_show_warnings0
Com_slave_start0
Com_slave_stop0
Com_stmt_close0
Com_stmt_execute0
Com_stmt_fetch0
Com_stmt_prepare0
Com_stmt_reprepare0
Com_stmt_reset0
Com_stmt_send_long_data0
Com_truncate0
Com_uninstall_plugin0
Com_unlock_tables0
Com_update0
Com_update_multi0
Com_xa_commit0
Com_xa_end0
Com_xa_prepare0
Com_xa_recover0
Com_xa_rollback0
Com_xa_start0
CompressionOFF
Connection_errors_accept0
Connection_errors_internal0
Connection_errors_max_connections0
Connection_errors_peer_address0
Connection_errors_select0
Connection_errors_tcpwrap0
Connections1366756
Created_tmp_disk_tables0
Created_tmp_files166835
Created_tmp_tables2
Delayed_errors0
Delayed_insert_threads0
Delayed_writes0
Flush_commands1
Handler_commit0
Handler_delete0
Handler_discover0
Handler_external_lock0
Handler_mrr_init0
Handler_prepare0
Handler_read_first0
Handler_read_key0
Handler_read_last0
Handler_read_next0
Handler_read_prev0
Handler_read_rnd0
Handler_read_rnd_next43
Handler_rollback0
Handler_savepoint0
Handler_savepoint_rollback0
Handler_update0
Handler_write41
Innodb_buffer_pool_dump_statusnot started
Innodb_buffer_pool_load_statusnot started
Innodb_buffer_pool_pages_data15149
Innodb_buffer_pool_bytes_data248201216
Innodb_buffer_pool_pages_dirty0
Innodb_buffer_pool_bytes_dirty0
Innodb_buffer_pool_pages_flushed3247108
Innodb_buffer_pool_pages_free1025
Innodb_buffer_pool_pages_misc209
Innodb_buffer_pool_pages_total16383
Innodb_buffer_pool_read_ahead_rnd0
Innodb_buffer_pool_read_ahead58920
Innodb_buffer_pool_read_ahead_evicted1666
Innodb_buffer_pool_read_requests450628395
Innodb_buffer_pool_reads503651
Innodb_buffer_pool_wait_free0
Innodb_buffer_pool_write_requests16102402
Innodb_data_fsyncs1314552
Innodb_data_pending_fsyncs0
Innodb_data_pending_reads0
Innodb_data_pending_writes0
Innodb_data_read9234288640
Innodb_data_reads565467
Innodb_data_writes4978459
Innodb_data_written109694329344
Innodb_dblwr_pages_written3247108
Innodb_dblwr_writes200037
Innodb_have_atomic_builtinsON
Innodb_log_waits0
Innodb_log_write_requests5643085
Innodb_log_writes1329513
Innodb_os_log_fsyncs483817
Innodb_os_log_pending_fsyncs0
Innodb_os_log_pending_writes0
Innodb_os_log_written3193337344
Innodb_page_size16384
Innodb_pages_created7504
Innodb_pages_read563611
Innodb_pages_written3247108
Innodb_row_lock_current_waits0
Innodb_row_lock_time376258
Innodb_row_lock_time_avg621
Innodb_row_lock_time_max25786
Innodb_row_lock_waits605
Innodb_rows_deleted223512
Innodb_rows_inserted451075
Innodb_rows_read389360328
Innodb_rows_updated551855
Innodb_num_open_files1024
Innodb_truncated_status_writes0
Innodb_available_undo_logs128
Key_blocks_not_flushed0
Key_blocks_unused95461
Key_blocks_used51211
Key_read_requests1059666863
Key_reads1061727
Key_write_requests222909936
Key_writes7232248
Last_query_cost10.499000
Last_query_partial_plans1
Max_used_connections31
Not_flushed_delayed_rows0
Open_files1166
Open_streams0
Open_table_definitions2048
Open_tables1024
Opened_files3777243
Opened_table_definitions0
Opened_tables0
Performance_schema_accounts_lost0
Performance_schema_cond_classes_lost0
Performance_schema_cond_instances_lost0
Performance_schema_digest_lost1700373
Performance_schema_file_classes_lost0
Performance_schema_file_handles_lost0
Performance_schema_file_instances_lost0
Performance_schema_hosts_lost0
Performance_schema_locker_lost0
Performance_schema_mutex_classes_lost0
Performance_schema_mutex_instances_lost0
Performance_schema_rwlock_classes_lost0
Performance_schema_rwlock_instances_lost0
Performance_schema_session_connect_attrs_lost0
Performance_schema_socket_classes_lost0
Performance_schema_socket_instances_lost0
Performance_schema_stage_classes_lost0
Performance_schema_statement_classes_lost0
Performance_schema_table_handles_lost0
Performance_schema_table_instances_lost0
Performance_schema_thread_classes_lost0
Performance_schema_thread_instances_lost0
Performance_schema_users_lost0
Prepared_stmt_count0
Qcache_free_blocks2566
Qcache_free_memory8505488
Qcache_hits14423219
Qcache_inserts9183498
Qcache_lowmem_prunes997048
Qcache_not_cached1401747
Qcache_queries_in_cache5933
Qcache_total_blocks15668
Queries36503306
Questions6
Select_full_join0
Select_full_range_join0
Select_range0
Select_range_check0
Select_scan2
Slave_heartbeat_period0.000
Slave_last_heartbeat
Slave_open_temp_tables0
Slave_received_heartbeats0
Slave_retried_transactions0
Slave_runningOFF
Slow_launch_threads0
Slow_queries0
Sort_merge_passes0
Sort_range0
Sort_rows0
Sort_scan0
Ssl_accept_renegotiates0
Ssl_accepts0
Ssl_callback_cache_hits0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects0
Ssl_connect_renegotiates0
Ssl_ctx_verify_depth0
Ssl_ctx_verify_mode0
Ssl_default_timeout0
Ssl_finished_accepts0
Ssl_finished_connects0
Ssl_server_not_after
Ssl_server_not_before
Ssl_session_cache_hits0
Ssl_session_cache_misses0
Ssl_session_cache_modeNONE
Ssl_session_cache_overflows0
Ssl_session_cache_size0
Ssl_session_cache_timeouts0
Ssl_sessions_reused0
Ssl_used_session_cache_entries0
Ssl_verify_depth0
Ssl_verify_mode0
Ssl_version
Table_locks_immediate19254324
Table_locks_waited9873
Table_open_cache_hits0
Table_open_cache_misses0
Table_open_cache_overflows0
Tc_log_max_pages_used0
Tc_log_page_size0
Tc_log_page_waits0
Threads_cached6
Threads_connected2
Threads_created1308
Threads_running2
Uptime2385882
Uptime_since_flush_status2385882