Home

MySQL-Variablen
Status    Prozesse   Status   Variablen   

 

NameInhalt
Aborted_clients3356653
Aborted_connects40390682
Aborted_connects_preauth384836
Access_denied_errors0
Acl_column_grants0
Acl_database_grants5609
Acl_function_grants0
Acl_procedure_grants0
Acl_package_spec_grants0
Acl_package_body_grants0
Acl_proxy_users0
Acl_role_grants0
Acl_roles0
Acl_table_grants1
Acl_users5618
Aria_pagecache_blocks_not_flushed1
Aria_pagecache_blocks_unused124545
Aria_pagecache_blocks_used116048
Aria_pagecache_read_requests171195745471
Aria_pagecache_reads904815101
Aria_pagecache_write_requests22343361516
Aria_pagecache_writes2815582056
Aria_transaction_log_syncs10130519
Binlog_commits0
Binlog_group_commits0
Binlog_group_commit_trigger_count0
Binlog_group_commit_trigger_lock_wait0
Binlog_group_commit_trigger_timeout0
Binlog_snapshot_file
Binlog_snapshot_position0
Binlog_bytes_written0
Binlog_cache_disk_use0
Binlog_cache_use0
Binlog_stmt_cache_disk_use0
Binlog_stmt_cache_use0
Busy_time0.000000
Bytes_received246
Bytes_sent2160
Column_compressions0
Column_decompressions0
Com_admin_commands0
Com_alter_db0
Com_alter_db_upgrade0
Com_alter_event0
Com_alter_function0
Com_alter_procedure0
Com_alter_server0
Com_alter_sequence0
Com_alter_table0
Com_alter_tablespace0
Com_alter_user0
Com_analyze0
Com_assign_to_keycache0
Com_backup0
Com_backup_lock0
Com_begin0
Com_binlog0
Com_call_procedure0
Com_change_db0
Com_change_master0
Com_check0
Com_checksum0
Com_commit0
Com_compound_sql0
Com_create_db0
Com_create_event0
Com_create_function0
Com_create_index0
Com_create_package0
Com_create_package_body0
Com_create_procedure0
Com_create_role0
Com_create_sequence0
Com_create_server0
Com_create_table0
Com_create_temporary_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_package0
Com_drop_package_body0
Com_drop_role0
Com_drop_server0
Com_drop_sequence0
Com_drop_table0
Com_drop_temporary_table0
Com_drop_trigger0
Com_drop_user0
Com_drop_view0
Com_empty_query0
Com_execute_immediate0
Com_execute_sql0
Com_flush0
Com_get_diagnostics0
Com_grant0
Com_grant_role0
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_multi0
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_revoke_role0
Com_rollback0
Com_rollback_to_savepoint0
Com_savepoint0
Com_select1
Com_set_option1
Com_show_authors0
Com_show_binlog_events0
Com_show_binlogs0
Com_show_charsets1
Com_show_collations0
Com_show_contributors0
Com_show_create_db0
Com_show_create_event0
Com_show_create_func0
Com_show_create_package0
Com_show_create_package_body0
Com_show_create_proc0
Com_show_create_table0
Com_show_create_trigger0
Com_show_create_user0
Com_show_databases0
Com_show_engine_logs0
Com_show_engine_mutex0
Com_show_engine_status0
Com_show_errors0
Com_show_events0
Com_show_explain0
Com_show_fields0
Com_show_function_status0
Com_show_generic0
Com_show_grants0
Com_show_keys0
Com_show_binlog_status0
Com_show_open_tables0
Com_show_package_status0
Com_show_package_body_status0
Com_show_plugins0
Com_show_privileges0
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_shutdown0
Com_signal0
Com_start_all_slaves0
Com_start_slave0
Com_stmt_close0
Com_stmt_execute0
Com_stmt_fetch0
Com_stmt_prepare0
Com_stmt_reprepare0
Com_stmt_reset0
Com_stmt_send_long_data0
Com_stop_all_slaves0
Com_stop_slave0
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_internal293
Connection_errors_max_connections0
Connection_errors_peer_address0
Connection_errors_select0
Connection_errors_tcpwrap0
Connections2028722639
Cpu_time0.000000
Created_tmp_disk_tables0
Created_tmp_files13889657
Created_tmp_tables2
Delayed_errors0
Delayed_insert_threads0
Delayed_writes2976
Delete_scan0
Empty_queries0
Executed_events0
Executed_triggers0
Feature_application_time_periods0
Feature_check_constraint26826
Feature_custom_aggregate_functions0
Feature_delay_key_write549
Feature_dynamic_columns0
Feature_fulltext0
Feature_gis0
Feature_insert_returning0
Feature_invisible_columns0
Feature_json0
Feature_locale0
Feature_subquery0
Feature_system_versioning0
Feature_timezone0
Feature_trigger0
Feature_window_functions0
Feature_xml0
Handler_commit0
Handler_delete0
Handler_discover0
Handler_external_lock0
Handler_icp_attempts0
Handler_icp_match0
Handler_mrr_init0
Handler_mrr_key_refills0
Handler_mrr_rowid_refills0
Handler_prepare0
Handler_read_first0
Handler_read_key0
Handler_read_last0
Handler_read_next0
Handler_read_prev0
Handler_read_retry0
Handler_read_rnd0
Handler_read_rnd_deleted0
Handler_read_rnd_next43
Handler_rollback0
Handler_savepoint0
Handler_savepoint_rollback0
Handler_tmp_delete0
Handler_tmp_update0
Handler_tmp_write41
Handler_update0
Handler_write0
Innodb_adaptive_hash_hash_searches0
Innodb_adaptive_hash_non_hash_searches1133544439615
Innodb_background_log_sync23067515
Innodb_buffer_pool_dump_status
Innodb_buffer_pool_load_statusBuffer pool(s) load completed at 231215 23:28:14
Innodb_buffer_pool_resize_status
Innodb_buffer_pool_load_incompleteOFF
Innodb_buffer_pool_pages_data64503
Innodb_buffer_pool_bytes_data1056972800
Innodb_buffer_pool_pages_dirty7229
Innodb_buffer_pool_bytes_dirty118407168
Innodb_buffer_pool_pages_flushed1097602124
Innodb_buffer_pool_pages_free0
Innodb_buffer_pool_pages_made_not_young3745985665443
Innodb_buffer_pool_pages_made_young31536672487
Innodb_buffer_pool_pages_misc17
Innodb_buffer_pool_pages_old23790
Innodb_buffer_pool_pages_total64520
Innodb_buffer_pool_pages_lru_flushed819696493
Innodb_buffer_pool_read_ahead_rnd0
Innodb_buffer_pool_read_ahead208684645
Innodb_buffer_pool_read_ahead_evicted20726803
Innodb_buffer_pool_read_requests8663133439388
Innodb_buffer_pool_reads480588390139
Innodb_buffer_pool_wait_free41665303
Innodb_buffer_pool_write_requests23858567033
Innodb_checkpoint_age29722773
Innodb_checkpoint_max_age80827823
Innodb_data_fsyncs423347557
Innodb_data_pending_fsyncs0
Innodb_data_pending_reads0
Innodb_data_pending_writes0
Innodb_data_read7878746079322112
Innodb_data_reads480944858779
Innodb_data_writes1163456008
Innodb_data_written17983995263975
Innodb_dblwr_pages_written1027070951
Innodb_dblwr_writes27689239
Innodb_deadlocks286
Innodb_history_list_length4
Innodb_ibuf_discarded_delete_marks1
Innodb_ibuf_discarded_deletes1
Innodb_ibuf_discarded_inserts586
Innodb_ibuf_free_list23390
Innodb_ibuf_merged_delete_marks2106
Innodb_ibuf_merged_deletes2100
Innodb_ibuf_merged_inserts7385
Innodb_ibuf_merges635
Innodb_ibuf_segment_size23554
Innodb_ibuf_size163
Innodb_log_waits0
Innodb_log_write_requests1529949002
Innodb_log_writes38047571
Innodb_lsn_current24219381989141
Innodb_lsn_flushed24219381911949
Innodb_lsn_last_checkpoint24219352266368
Innodb_master_thread_active_loops190
Innodb_master_thread_idle_loops23067533
Innodb_max_trx_id12232827996
Innodb_mem_adaptive_hash0
Innodb_mem_dictionary336557064
Innodb_os_log_fsyncs37952380
Innodb_os_log_pending_fsyncs0
Innodb_os_log_pending_writes0
Innodb_os_log_written5897890916352
Innodb_page_size16384
Innodb_pages_created165330645
Innodb_pages_read480795404805
Innodb_pages_written1097602124
Innodb_row_lock_current_waits0
Innodb_row_lock_time4809761
Innodb_row_lock_time_avg2
Innodb_row_lock_time_max51802
Innodb_row_lock_waits1636004
Innodb_rows_deleted567282950
Innodb_rows_inserted882229661
Innodb_rows_read36995236789606
Innodb_rows_updated1826754198
Innodb_system_rows_deleted0
Innodb_system_rows_inserted0
Innodb_system_rows_read0
Innodb_system_rows_updated0
Innodb_num_open_files6144
Innodb_truncated_status_writes0
Innodb_available_undo_logs128
Innodb_undo_truncations0
Innodb_page_compression_saved0
Innodb_num_pages_page_compressed0
Innodb_num_page_compressed_trim_op0
Innodb_num_pages_page_decompressed0
Innodb_num_pages_page_compression_error0
Innodb_num_pages_encrypted0
Innodb_num_pages_decrypted0
Innodb_have_lz4ON
Innodb_have_lzoOFF
Innodb_have_lzmaOFF
Innodb_have_bzip2OFF
Innodb_have_snappyON
Innodb_have_punch_holeON
Innodb_defragment_compression_failures0
Innodb_defragment_failures13021
Innodb_defragment_count19877
Innodb_instant_alter_column4764
Innodb_onlineddl_rowlog_rows0
Innodb_onlineddl_rowlog_pct_used0
Innodb_onlineddl_pct_progress0
Innodb_secondary_index_triggered_cluster_reads581751521701
Innodb_secondary_index_triggered_cluster_reads_avoided0
Innodb_encryption_rotation_pages_read_from_cache0
Innodb_encryption_rotation_pages_read_from_disk0
Innodb_encryption_rotation_pages_modified0
Innodb_encryption_rotation_pages_flushed0
Innodb_encryption_rotation_estimated_iops0
Innodb_encryption_n_merge_blocks_encrypted0
Innodb_encryption_n_merge_blocks_decrypted0
Innodb_encryption_n_rowlog_blocks_encrypted0
Innodb_encryption_n_rowlog_blocks_decrypted0
Innodb_encryption_n_temp_blocks_encrypted0
Innodb_encryption_n_temp_blocks_decrypted0
Innodb_encryption_num_key_requests0
Key_blocks_not_flushed0
Key_blocks_unused1699071
Key_blocks_used477384
Key_blocks_warm0
Key_read_requests1862182158884
Key_reads1702611178
Key_write_requests3884540178
Key_writes2650870347
Last_query_cost10.499000
Master_gtid_wait_count0
Master_gtid_wait_time0
Master_gtid_wait_timeouts0
Max_statement_time_exceeded0
Max_used_connections145
Memory_used189064
Memory_used_initial446125536
Not_flushed_delayed_rows0
Open_files3390
Open_streams4
Open_table_definitions3407
Open_tables6108
Opened_files7406936405
Opened_plugin_libraries341805
Opened_table_definitions0
Opened_tables0
Opened_views0
Performance_schema_accounts_lost0
Performance_schema_cond_classes_lost0
Performance_schema_cond_instances_lost0
Performance_schema_digest_lost0
Performance_schema_file_classes_lost0
Performance_schema_file_handles_lost0
Performance_schema_file_instances_lost0
Performance_schema_hosts_lost0
Performance_schema_index_stat_lost0
Performance_schema_locker_lost0
Performance_schema_memory_classes_lost0
Performance_schema_metadata_lock_lost0
Performance_schema_mutex_classes_lost0
Performance_schema_mutex_instances_lost0
Performance_schema_nested_statement_lost0
Performance_schema_prepared_statements_lost0
Performance_schema_program_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_table_lock_stat_lost0
Performance_schema_thread_classes_lost0
Performance_schema_thread_instances_lost0
Performance_schema_users_lost0
Prepared_stmt_count0
Qcache_free_blocks0
Qcache_free_memory0
Qcache_hits0
Qcache_inserts0
Qcache_lowmem_prunes0
Qcache_not_cached0
Qcache_queries_in_cache0
Qcache_total_blocks0
Queries85410122757
Questions5
Rows_read0
Rows_sent42
Rows_tmp_read41
Rpl_semi_sync_master_clients0
Rpl_semi_sync_master_get_ack0
Rpl_semi_sync_master_net_avg_wait_time0
Rpl_semi_sync_master_net_wait_time0
Rpl_semi_sync_master_net_waits0
Rpl_semi_sync_master_no_times0
Rpl_semi_sync_master_no_tx0
Rpl_semi_sync_master_request_ack0
Rpl_semi_sync_master_statusOFF
Rpl_semi_sync_master_timefunc_failures0
Rpl_semi_sync_master_tx_avg_wait_time0
Rpl_semi_sync_master_tx_wait_time0
Rpl_semi_sync_master_tx_waits0
Rpl_semi_sync_master_wait_pos_backtraverse0
Rpl_semi_sync_master_wait_sessions0
Rpl_semi_sync_master_yes_tx0
Rpl_semi_sync_slave_send_ack0
Rpl_semi_sync_slave_statusOFF
Rpl_statusAUTH_MASTER
Rpl_transactions_multi_engine0
Select_full_join0
Select_full_range_join0
Select_range0
Select_range_check0
Select_scan2
Slave_connections0
Slave_heartbeat_period0.000
Slave_open_temp_tables0
Slave_received_heartbeats0
Slave_retried_transactions0
Slave_runningOFF
Slave_skipped_errors0
Slaves_connected0
Slaves_running0
Slow_launch_threads0
Slow_queries0
Sort_merge_passes0
Sort_priority_queue_sorts0
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
Subquery_cache_hit547853441467
Subquery_cache_miss17894556997
Syncs55418604
Table_locks_immediate195651696884
Table_locks_waited34317774
Table_open_cache_active_instances2
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
Threadpool_idle_threads0
Threadpool_threads0
Threads_cached128
Threads_connected16
Threads_created160
Threads_running1
Transactions_gtid_foreign_engine0
Transactions_multi_engine0
Update_scan0
Uptime23075675
Uptime_since_flush_status23075675
wsrep0
wsrep_applier_thread_count0
wsrep_cluster_capabilities
wsrep_cluster_conf_id18446744073709551615
wsrep_cluster_size0
wsrep_cluster_state_uuid
wsrep_cluster_statusDisconnected
wsrep_connectedOFF
wsrep_local_bf_aborts0
wsrep_local_index18446744073709551615
wsrep_provider_capabilities
wsrep_provider_name
wsrep_provider_vendor
wsrep_provider_version
wsrep_readyOFF
wsrep_rollbacker_thread_count0
wsrep_thread_count0