Created
January 20, 2020 11:00
-
-
Save imranrazakhan/5b0f06529916435e5df71aebdb8062c0 to your computer and use it in GitHub Desktop.
SHOW GLOBAL STATUS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Aborted_clients 0 | |
Aborted_connects 167 | |
Binlog_cache_disk_use 0 | |
Binlog_cache_use 0 | |
Binlog_stmt_cache_disk_use 0 | |
Binlog_stmt_cache_use 0 | |
Bytes_received 10509 | |
Bytes_sent 198400 | |
Com_admin_commands 140 | |
Com_assign_to_keycache 0 | |
Com_alter_db 0 | |
Com_alter_db_upgrade 0 | |
Com_alter_event 0 | |
Com_alter_function 0 | |
Com_alter_instance 0 | |
Com_alter_procedure 0 | |
Com_alter_server 0 | |
Com_alter_table 0 | |
Com_alter_tablespace 0 | |
Com_alter_user 0 | |
Com_analyze 0 | |
Com_begin 0 | |
Com_binlog 0 | |
Com_call_procedure 0 | |
Com_change_db 4 | |
Com_change_master 0 | |
Com_change_repl_filter 0 | |
Com_check 0 | |
Com_checksum 0 | |
Com_commit 0 | |
Com_create_db 0 | |
Com_create_event 0 | |
Com_create_function 0 | |
Com_create_index 0 | |
Com_create_procedure 0 | |
Com_create_server 0 | |
Com_create_table 0 | |
Com_create_trigger 0 | |
Com_create_udf 0 | |
Com_create_user 0 | |
Com_create_view 0 | |
Com_dealloc_sql 0 | |
Com_delete 0 | |
Com_delete_multi 0 | |
Com_do 0 | |
Com_drop_db 0 | |
Com_drop_event 0 | |
Com_drop_function 0 | |
Com_drop_index 0 | |
Com_drop_procedure 0 | |
Com_drop_server 0 | |
Com_drop_table 0 | |
Com_drop_trigger 0 | |
Com_drop_user 0 | |
Com_drop_view 0 | |
Com_empty_query 0 | |
Com_execute_sql 0 | |
Com_explain_other 0 | |
Com_flush 0 | |
Com_get_diagnostics 0 | |
Com_grant 0 | |
Com_ha_close 0 | |
Com_ha_open 0 | |
Com_ha_read 0 | |
Com_help 0 | |
Com_insert 0 | |
Com_insert_select 0 | |
Com_install_plugin 0 | |
Com_kill 0 | |
Com_load 0 | |
Com_lock_tables 0 | |
Com_optimize 0 | |
Com_preload_keys 0 | |
Com_prepare_sql 0 | |
Com_purge 0 | |
Com_purge_before_date 0 | |
Com_release_savepoint 0 | |
Com_rename_table 0 | |
Com_rename_user 0 | |
Com_repair 0 | |
Com_replace 0 | |
Com_replace_select 0 | |
Com_reset 0 | |
Com_resignal 0 | |
Com_revoke 0 | |
Com_revoke_all 0 | |
Com_rollback 0 | |
Com_rollback_to_savepoint 0 | |
Com_savepoint 0 | |
Com_select 125 | |
Com_set_option 11 | |
Com_signal 0 | |
Com_show_binlog_events 0 | |
Com_show_binlogs 0 | |
Com_show_charsets 1 | |
Com_show_collations 1 | |
Com_show_create_db 0 | |
Com_show_create_event 0 | |
Com_show_create_func 0 | |
Com_show_create_proc 0 | |
Com_show_create_table 0 | |
Com_show_create_trigger 0 | |
Com_show_databases 2 | |
Com_show_engine_logs 0 | |
Com_show_engine_mutex 0 | |
Com_show_engine_status 0 | |
Com_show_events 0 | |
Com_show_errors 0 | |
Com_show_fields 129 | |
Com_show_function_code 0 | |
Com_show_function_status 1 | |
Com_show_grants 0 | |
Com_show_keys 0 | |
Com_show_master_status 0 | |
Com_show_open_tables 0 | |
Com_show_plugins 0 | |
Com_show_privileges 0 | |
Com_show_procedure_code 0 | |
Com_show_procedure_status 1 | |
Com_show_processlist 0 | |
Com_show_profile 0 | |
Com_show_profiles 0 | |
Com_show_relaylog_events 0 | |
Com_show_slave_hosts 0 | |
Com_show_slave_status 0 | |
Com_show_status 4 | |
Com_show_storage_engines 1 | |
Com_show_table_status 0 | |
Com_show_tables 1 | |
Com_show_triggers 0 | |
Com_show_variables 12 | |
Com_show_warnings 0 | |
Com_show_create_user 0 | |
Com_shutdown 0 | |
Com_slave_start 0 | |
Com_slave_stop 0 | |
Com_group_replication_start 0 | |
Com_group_replication_stop 0 | |
Com_stmt_execute 0 | |
Com_stmt_close 0 | |
Com_stmt_fetch 0 | |
Com_stmt_prepare 0 | |
Com_stmt_reset 0 | |
Com_stmt_send_long_data 0 | |
Com_truncate 0 | |
Com_uninstall_plugin 0 | |
Com_unlock_tables 0 | |
Com_update 57 | |
Com_update_multi 0 | |
Com_xa_commit 0 | |
Com_xa_end 0 | |
Com_xa_prepare 0 | |
Com_xa_recover 0 | |
Com_xa_rollback 0 | |
Com_xa_start 0 | |
Com_stmt_reprepare 0 | |
Connection_errors_accept 0 | |
Connection_errors_internal 0 | |
Connection_errors_max_connections 0 | |
Connection_errors_peer_address 0 | |
Connection_errors_select 0 | |
Connection_errors_tcpwrap 0 | |
Connections 231 | |
Created_tmp_disk_tables 133 | |
Created_tmp_files 6 | |
Created_tmp_tables 173 | |
Delayed_errors 0 | |
Delayed_insert_threads 0 | |
Delayed_writes 0 | |
Flush_commands 1 | |
Handler_commit 178 | |
Handler_delete 0 | |
Handler_discover 0 | |
Handler_external_lock 833 | |
Handler_mrr_init 0 | |
Handler_prepare 0 | |
Handler_read_first 256 | |
Handler_read_key 541 | |
Handler_read_last 172 | |
Handler_read_next 150 | |
Handler_read_prev 6 | |
Handler_read_rnd 0 | |
Handler_read_rnd_next 17311 | |
Handler_rollback 0 | |
Handler_savepoint 0 | |
Handler_savepoint_rollback 0 | |
Handler_update 115 | |
Handler_write 8311 | |
Innodb_buffer_pool_dump_status Dumping of buffer pool not started | |
Innodb_buffer_pool_load_status Buffer pool(s) load completed at 200120 10:50:41 | |
Innodb_buffer_pool_resize_status | |
Innodb_buffer_pool_pages_data 1393 | |
Innodb_buffer_pool_bytes_data 22822912 | |
Innodb_buffer_pool_pages_dirty 0 | |
Innodb_buffer_pool_bytes_dirty 0 | |
Innodb_buffer_pool_pages_flushed 290 | |
Innodb_buffer_pool_pages_free 129654 | |
Innodb_buffer_pool_pages_misc 9 | |
Innodb_buffer_pool_pages_total 131056 | |
Innodb_buffer_pool_read_ahead_rnd 0 | |
Innodb_buffer_pool_read_ahead 0 | |
Innodb_buffer_pool_read_ahead_evicted 0 | |
Innodb_buffer_pool_read_requests 14837 | |
Innodb_buffer_pool_reads 1342 | |
Innodb_buffer_pool_wait_free 0 | |
Innodb_buffer_pool_write_requests 3847 | |
Innodb_data_fsyncs 582 | |
Innodb_data_pending_fsyncs 0 | |
Innodb_data_pending_reads 0 | |
Innodb_data_pending_writes 0 | |
Innodb_data_read 22057472 | |
Innodb_data_reads 1446 | |
Innodb_data_writes 724 | |
Innodb_data_written 8836096 | |
Innodb_dblwr_pages_written 238 | |
Innodb_dblwr_writes 128 | |
Innodb_log_waits 0 | |
Innodb_log_write_requests 40 | |
Innodb_log_writes 176 | |
Innodb_os_log_fsyncs 294 | |
Innodb_os_log_pending_fsyncs 0 | |
Innodb_os_log_pending_writes 0 | |
Innodb_os_log_written 124928 | |
Innodb_page_size 16384 | |
Innodb_pages_created 52 | |
Innodb_pages_read 1341 | |
Innodb_pages_written 290 | |
Innodb_row_lock_current_waits 0 | |
Innodb_row_lock_time 0 | |
Innodb_row_lock_time_avg 0 | |
Innodb_row_lock_time_max 0 | |
Innodb_row_lock_waits 0 | |
Innodb_rows_deleted 0 | |
Innodb_rows_inserted 1358 | |
Innodb_rows_read 1543 | |
Innodb_rows_updated 57 | |
Innodb_num_open_files 96 | |
Innodb_truncated_status_writes 0 | |
Innodb_available_undo_logs 128 | |
Key_blocks_not_flushed 0 | |
Key_blocks_unused 6689 | |
Key_blocks_used 11 | |
Key_read_requests 278 | |
Key_reads 15 | |
Key_write_requests 0 | |
Key_writes 0 | |
Locked_connects 0 | |
Max_execution_time_exceeded 0 | |
Max_execution_time_set 0 | |
Max_execution_time_set_failed 0 | |
Max_used_connections 4 | |
Max_used_connections_time 2020-01-20 10:56:13 | |
Not_flushed_delayed_rows 0 | |
Ongoing_anonymous_transaction_count 0 | |
Open_files 28 | |
Open_streams 0 | |
Open_table_definitions 235 | |
Open_tables 267 | |
Opened_files 437 | |
Opened_table_definitions 235 | |
Opened_tables 289 | |
Performance_schema_accounts_lost 0 | |
Performance_schema_cond_classes_lost 0 | |
Performance_schema_cond_instances_lost 0 | |
Performance_schema_digest_lost 0 | |
Performance_schema_file_classes_lost 0 | |
Performance_schema_file_handles_lost 0 | |
Performance_schema_file_instances_lost 0 | |
Performance_schema_hosts_lost 0 | |
Performance_schema_index_stat_lost 0 | |
Performance_schema_locker_lost 0 | |
Performance_schema_memory_classes_lost 0 | |
Performance_schema_metadata_lock_lost 0 | |
Performance_schema_mutex_classes_lost 0 | |
Performance_schema_mutex_instances_lost 0 | |
Performance_schema_nested_statement_lost 0 | |
Performance_schema_prepared_statements_lost 0 | |
Performance_schema_program_lost 0 | |
Performance_schema_rwlock_classes_lost 0 | |
Performance_schema_rwlock_instances_lost 0 | |
Performance_schema_session_connect_attrs_lost 0 | |
Performance_schema_socket_classes_lost 0 | |
Performance_schema_socket_instances_lost 0 | |
Performance_schema_stage_classes_lost 0 | |
Performance_schema_statement_classes_lost 0 | |
Performance_schema_table_handles_lost 0 | |
Performance_schema_table_instances_lost 0 | |
Performance_schema_table_lock_stat_lost 0 | |
Performance_schema_thread_classes_lost 0 | |
Performance_schema_thread_instances_lost 0 | |
Performance_schema_users_lost 0 | |
Prepared_stmt_count 0 | |
Qcache_free_blocks 1 | |
Qcache_free_memory 16760152 | |
Qcache_hits 0 | |
Qcache_inserts 0 | |
Qcache_lowmem_prunes 0 | |
Qcache_not_cached 9 | |
Qcache_queries_in_cache 0 | |
Qcache_total_blocks 1 | |
Queries 667 | |
Questions 177 | |
Select_full_join 0 | |
Select_full_range_join 0 | |
Select_range 0 | |
Select_range_check 0 | |
Select_scan 286 | |
Slave_open_temp_tables 0 | |
Slow_launch_threads 0 | |
Slow_queries 0 | |
Sort_merge_passes 0 | |
Sort_range 0 | |
Sort_rows 0 | |
Sort_scan 0 | |
Ssl_accept_renegotiates 0 | |
Ssl_accepts 2 | |
Ssl_client_connects 0 | |
Ssl_connect_renegotiates 0 | |
Ssl_ctx_verify_depth 18446744073709551615 | |
Ssl_ctx_verify_mode 5 | |
Ssl_default_timeout 7200 | |
Ssl_finished_accepts 2 | |
Ssl_finished_connects 0 | |
Ssl_server_not_after Jan 11 16:23:21 2030 GMT | |
Ssl_server_not_before Jan 14 16:23:21 2020 GMT | |
Ssl_session_cache_hits 0 | |
Ssl_session_cache_misses 0 | |
Ssl_session_cache_mode SERVER | |
Ssl_session_cache_overflows 0 | |
Ssl_session_cache_size 128 | |
Ssl_session_cache_timeouts 0 | |
Ssl_sessions_reused 0 | |
Ssl_used_session_cache_entries 2 | |
Ssl_verify_depth 18446744073709551615 | |
Ssl_verify_mode 5 | |
Ssl_version TLSv1.1 | |
Table_locks_immediate 233 | |
Table_locks_waited 1 | |
Table_open_cache_hits 302 | |
Table_open_cache_misses 289 | |
Table_open_cache_overflows 15 | |
Tc_log_max_pages_used 0 | |
Tc_log_page_size 0 | |
Tc_log_page_waits 0 | |
Threads_cached 1 | |
Threads_connected 3 | |
Threads_created 4 | |
Threads_running 2 | |
Uptime 343 | |
Uptime_since_flush_status 343 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment