#mysql mysql 'SHOW GLOBAL STATUS'
Variable_name	Value
Aborted_clients	331939
Aborted_connects	2072
Access_denied_errors	318
Acl_column_grants	0
Acl_database_grants	64
Acl_function_grants	0
Acl_procedure_grants	0
Acl_package_spec_grants	0
Acl_package_body_grants	0
Acl_proxy_users	1
Acl_role_grants	0
Acl_roles	0
Acl_table_grants	0
Acl_users	30
Aria_pagecache_blocks_not_flushed	14
Aria_pagecache_blocks_unused	15691
Aria_pagecache_blocks_used	8995
Aria_pagecache_read_requests	3719654892
Aria_pagecache_reads	36041123
Aria_pagecache_write_requests	500801800
Aria_pagecache_writes	77718600
Aria_transaction_log_syncs	46630
Binlog_commits	58705395
Binlog_group_commits	58700087
Binlog_group_commit_trigger_count	0
Binlog_group_commit_trigger_lock_wait	0
Binlog_group_commit_trigger_timeout	0
Binlog_snapshot_file	binlog.000082
Binlog_snapshot_position	374472902
Binlog_bytes_written	87387457695
Binlog_cache_disk_use	11
Binlog_cache_use	2831498
Binlog_stmt_cache_disk_use	103972
Binlog_stmt_cache_use	55873892
Busy_time	0.000000
Bytes_received	704281601408
Bytes_sent	4897877105230
Column_compressions	0
Column_decompressions	0
Com_admin_commands	4
Com_alter_db	0
Com_alter_db_upgrade	0
Com_alter_event	0
Com_alter_function	0
Com_alter_procedure	0
Com_alter_server	0
Com_alter_sequence	0
Com_alter_table	6351
Com_alter_tablespace	0
Com_alter_user	0
Com_analyze	0
Com_assign_to_keycache	0
Com_begin	2
Com_binlog	0
Com_call_procedure	0
Com_change_db	154764
Com_change_master	0
Com_check	0
Com_checksum	0
Com_commit	0
Com_compound_sql	2
Com_create_db	30
Com_create_event	0
Com_create_function	0
Com_create_index	0
Com_create_package	0
Com_create_package_body	0
Com_create_procedure	0
Com_create_role	0
Com_create_sequence	0
Com_create_server	0
Com_create_table	1399802
Com_create_temporary_table	12086
Com_create_trigger	0
Com_create_udf	0
Com_create_user	6
Com_create_view	9
Com_dealloc_sql	0
Com_delete	2171679
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_package	0
Com_drop_package_body	0
Com_drop_role	0
Com_drop_server	0
Com_drop_sequence	0
Com_drop_table	3318
Com_drop_temporary_table	1388
Com_drop_trigger	0
Com_drop_user	0
Com_drop_view	19
Com_empty_query	0
Com_execute_immediate	0
Com_execute_sql	0
Com_flush	329
Com_get_diagnostics	0
Com_grant	71
Com_grant_role	0
Com_ha_close	0
Com_ha_open	0
Com_ha_read	0
Com_help	0
Com_insert	31824518
Com_insert_select	602628
Com_install_plugin	0
Com_kill	73
Com_load	10
Com_lock_tables	3996
Com_multi	0
Com_optimize	580
Com_preload_keys	0
Com_prepare_sql	0
Com_purge	0
Com_purge_before_date	0
Com_release_savepoint	0
Com_rename_table	1
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_revoke_role	0
Com_rollback	0
Com_rollback_to_savepoint	0
Com_savepoint	0
Com_select	7396204562
Com_set_option	95965596
Com_show_authors	0
Com_show_binlog_events	0
Com_show_binlogs	0
Com_show_charsets	0
Com_show_collations	20543512
Com_show_contributors	0
Com_show_create_db	0
Com_show_create_event	0
Com_show_create_func	0
Com_show_create_package	0
Com_show_create_package_body	0
Com_show_create_proc	0
Com_show_create_table	161249
Com_show_create_trigger	0
Com_show_create_user	0
Com_show_databases	826
Com_show_engine_logs	0
Com_show_engine_mutex	0
Com_show_engine_status	1
Com_show_errors	0
Com_show_events	0
Com_show_explain	0
Com_show_fields	25317566
Com_show_function_status	0
Com_show_generic	0
Com_show_grants	8
Com_show_keys	3
Com_show_master_status	0
Com_show_open_tables	0
Com_show_package_status	0
Com_show_package_body_status	0
Com_show_plugins	0
Com_show_privileges	0
Com_show_procedure_status	0
Com_show_processlist	378
Com_show_profile	0
Com_show_profiles	0
Com_show_relaylog_events	0
Com_show_slave_hosts	4
Com_show_slave_status	4
Com_show_status	55
Com_show_storage_engines	4
Com_show_table_status	6521994
Com_show_tables	16088330
Com_show_triggers	0
Com_show_variables	20543589
Com_show_warnings	10
Com_shutdown	0
Com_signal	0
Com_start_all_slaves	0
Com_start_slave	0
Com_stmt_close	0
Com_stmt_execute	0
Com_stmt_fetch	0
Com_stmt_prepare	0
Com_stmt_reprepare	0
Com_stmt_reset	0
Com_stmt_send_long_data	0
Com_stop_all_slaves	0
Com_stop_slave	0
Com_truncate	70
Com_uninstall_plugin	0
Com_unlock_tables	4005
Com_update	48732293
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
Compression	OFF
Connection_errors_accept	0
Connection_errors_internal	1191
Connection_errors_max_connections	1191
Connection_errors_peer_address	0
Connection_errors_select	0
Connection_errors_tcpwrap	0
Connections	31875579
Cpu_time	0.000000
Created_tmp_disk_tables	37282606
Created_tmp_files	252692
Created_tmp_tables	199503136
Delayed_errors	0
Delayed_insert_threads	0
Delayed_writes	0
Delete_scan	1634555
Empty_queries	5053233858
Executed_events	0
Executed_triggers	0
Feature_check_constraint	0
Feature_custom_aggregate_functions	0
Feature_delay_key_write	0
Feature_dynamic_columns	0
Feature_fulltext	0
Feature_gis	0
Feature_invisible_columns	0
Feature_json	0
Feature_locale	0
Feature_subquery	142538464
Feature_system_versioning	0
Feature_timezone	5488402
Feature_trigger	0
Feature_window_functions	0
Feature_xml	0
Flush_commands	1
Handler_commit	73635779
Handler_delete	19259002
Handler_discover	624
Handler_external_lock	0
Handler_icp_attempts	141881090697
Handler_icp_match	52096793824
Handler_mrr_init	0
Handler_mrr_key_refills	0
Handler_mrr_rowid_refills	0
Handler_prepare	4904092
Handler_read_first	7098146
Handler_read_key	42671951841
Handler_read_last	1541334
Handler_read_next	157789760607
Handler_read_prev	3210021525
Handler_read_retry	0
Handler_read_rnd	6460642474
Handler_read_rnd_deleted	88218729
Handler_read_rnd_next	198080945941
Handler_rollback	82
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_tmp_delete	0
Handler_tmp_update	1535814306
Handler_tmp_write	11926427639
Handler_update	84332150
Handler_write	394138123
Innodb_buffer_pool_dump_status
Innodb_buffer_pool_load_status	Buffer pool(s) load completed at 200314 19:05:48
Innodb_buffer_pool_resize_status	Completed resizing buffer pool at 200602 12:58:59.
Innodb_buffer_pool_load_incomplete	OFF
Innodb_buffer_pool_pages_data	558
Innodb_buffer_pool_bytes_data	9142272
Innodb_buffer_pool_pages_dirty	4
Innodb_buffer_pool_bytes_dirty	65536
Innodb_buffer_pool_pages_flushed	14560754
Innodb_buffer_pool_pages_free	7628
Innodb_buffer_pool_pages_misc	6
Innodb_buffer_pool_pages_total	8192
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	272977792
Innodb_buffer_pool_reads	177
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	39762719
Innodb_data_fsyncs	12525646
Innodb_data_pending_fsyncs	0
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	2968064
Innodb_data_reads	192
Innodb_data_writes	23473529
Innodb_data_written	484977283584
Innodb_dblwr_pages_written	14560631
Innodb_dblwr_writes	1810124
Innodb_log_waits	0
Innodb_log_write_requests	4393893
Innodb_log_writes	5809970
Innodb_os_log_fsyncs	7092858
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	7195751936
Innodb_page_size	16384
Innodb_pages_created	382
Innodb_pages_read	176
Innodb_pages0_read	5
Innodb_pages_written	14560762
Innodb_row_lock_current_waits	0
Innodb_row_lock_time	381808
Innodb_row_lock_time_avg	53
Innodb_row_lock_time_max	2350
Innodb_row_lock_waits	7118
Innodb_rows_deleted	4912
Innodb_rows_inserted	16982
Innodb_rows_read	202129393
Innodb_rows_updated	2437937
Innodb_system_rows_deleted	0
Innodb_system_rows_inserted	0
Innodb_system_rows_read	0
Innodb_system_rows_updated	0
Innodb_num_open_files	18
Innodb_truncated_status_writes	0
Innodb_available_undo_logs	128
Innodb_undo_truncations	0
Innodb_page_compression_saved	0
Innodb_num_index_pages_written	0
Innodb_num_non_index_pages_written	0
Innodb_num_pages_page_compressed	0
Innodb_num_page_compressed_trim_op	0
Innodb_num_pages_page_decompressed	0
Innodb_num_pages_page_compression_error	0
Innodb_num_pages_encrypted	0
Innodb_num_pages_decrypted	0
Innodb_have_lz4	ON
Innodb_have_lzo	OFF
Innodb_have_lzma	OFF
Innodb_have_bzip2	OFF
Innodb_have_snappy	ON
Innodb_have_punch_hole	ON
Innodb_defragment_compression_failures	0
Innodb_defragment_failures	0
Innodb_defragment_count	0
Innodb_instant_alter_column	0
Innodb_onlineddl_rowlog_rows	0
Innodb_onlineddl_rowlog_pct_used	0
Innodb_onlineddl_pct_progress	0
Innodb_secondary_index_triggered_cluster_reads	13468607
Innodb_secondary_index_triggered_cluster_reads_avoided	0
Innodb_encryption_rotation_pages_read_from_cache	0
Innodb_encryption_rotation_pages_read_from_disk	0
Innodb_encryption_rotation_pages_modified	0
Innodb_encryption_rotation_pages_flushed	0
Innodb_encryption_rotation_estimated_iops	0
Innodb_encryption_key_rotation_list_length	0
Innodb_encryption_n_merge_blocks_encrypted	0
Innodb_encryption_n_merge_blocks_decrypted	0
Innodb_encryption_n_rowlog_blocks_encrypted	0
Innodb_encryption_n_rowlog_blocks_decrypted	0
Innodb_encryption_n_temp_blocks_encrypted	0
Innodb_encryption_n_temp_blocks_decrypted	0
Innodb_scrub_background_page_reorganizations	0
Innodb_scrub_background_page_splits	0
Innodb_scrub_background_page_split_failures_underflow	0
Innodb_scrub_background_page_split_failures_out_of_filespace	0
Innodb_scrub_background_page_split_failures_missing_index	0
Innodb_scrub_background_page_split_failures_unknown	0
Innodb_scrub_log	0
Innodb_encryption_num_key_requests	0
Key_blocks_not_flushed	0
Key_blocks_unused	0
Key_blocks_used	107163
Key_blocks_warm	85395
Key_read_requests	149110879885
Key_reads	135175673
Key_write_requests	721023365
Key_writes	190846370
Last_query_cost	0.000000
Master_gtid_wait_count	0
Master_gtid_wait_time	0
Master_gtid_wait_timeouts	0
Max_statement_time_exceeded	0
Max_used_connections	262
Memory_used	410728448
Memory_used_initial	289441536
Not_flushed_delayed_rows	0
Open_files	3400
Open_streams	0
Open_table_definitions	1419
Open_tables	2000
Opened_files	152800304
Opened_plugin_libraries	0
Opened_table_definitions	369010
Opened_tables	599153
Opened_views	20939
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_locker_lost	0
Performance_schema_mutex_classes_lost	0
Performance_schema_mutex_instances_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_thread_classes_lost	0
Performance_schema_thread_instances_lost	0
Performance_schema_users_lost	0
Prepared_stmt_count	0
Qcache_free_blocks	1257
Qcache_free_memory	2679248
Qcache_hits	6545612470
Qcache_inserts	678294115
Qcache_lowmem_prunes	489955864
Qcache_not_cached	168141481
Qcache_queries_in_cache	10220
Qcache_total_blocks	22312
Queries	7697802646
Questions	7697802644
Rows_read	366767483473
Rows_sent	19417164653
Rows_tmp_read	12297966899
Rpl_semi_sync_master_clients	0
Rpl_semi_sync_master_get_ack	0
Rpl_semi_sync_master_net_avg_wait_time	0
Rpl_semi_sync_master_net_wait_time	0
Rpl_semi_sync_master_net_waits	0
Rpl_semi_sync_master_no_times	0
Rpl_semi_sync_master_no_tx	0
Rpl_semi_sync_master_request_ack	0
Rpl_semi_sync_master_status	OFF
Rpl_semi_sync_master_timefunc_failures	0
Rpl_semi_sync_master_tx_avg_wait_time	0
Rpl_semi_sync_master_tx_wait_time	0
Rpl_semi_sync_master_tx_waits	0
Rpl_semi_sync_master_wait_pos_backtraverse	0
Rpl_semi_sync_master_wait_sessions	0
Rpl_semi_sync_master_yes_tx	0
Rpl_semi_sync_slave_send_ack	0
Rpl_semi_sync_slave_status	OFF
Rpl_status	AUTH_MASTER
Rpl_transactions_multi_engine	0
Select_full_join	4416216
Select_full_range_join	5063
Select_range	60529623
Select_range_check	1676
Select_scan	131194635
Slave_connections	0
Slave_heartbeat_period	0.000
Slave_open_temp_tables	0
Slave_received_heartbeats	0
Slave_retried_transactions	0
Slave_running	OFF
Slave_skipped_errors	0
Slaves_connected	0
Slaves_running	0
Slow_launch_threads	0
Slow_queries	1482
Sort_merge_passes	104128
Sort_priority_queue_sorts	342435617
Sort_range	383800235
Sort_rows	8591550106
Sort_scan	30048295
Ssl_accept_renegotiates	0
Ssl_accepts	0
Ssl_callback_cache_hits	0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	0
Ssl_ctx_verify_mode	0
Ssl_default_timeout	0
Ssl_finished_accepts	0
Ssl_finished_connects	0
Ssl_server_not_after
Ssl_server_not_before
Ssl_session_cache_hits	0
Ssl_session_cache_misses	0
Ssl_session_cache_mode	NONE
Ssl_session_cache_overflows	0
Ssl_session_cache_size	0
Ssl_session_cache_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	0
Ssl_verify_depth	0
Ssl_verify_mode	0
Ssl_version
Subquery_cache_hit	2109649795
Subquery_cache_miss	2666994460
Syncs	101629
Table_locks_immediate	1141834619
Table_locks_waited	130996
Table_open_cache_active_instances	1
Table_open_cache_hits	1229819265
Table_open_cache_misses	3888758
Table_open_cache_overflows	579350
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threadpool_idle_threads	0
Threadpool_threads	0
Threads_cached	38
Threads_connected	133
Threads_created	1001
Threads_running	7
Transactions_gtid_foreign_engine	0
Transactions_multi_engine	0
Update_scan	43513
Uptime	7149137
Uptime_since_flush_status	7149137
wsrep_applier_thread_count	0
wsrep_cluster_conf_id	18446744073709551615
wsrep_cluster_size	0
wsrep_cluster_state_uuid
wsrep_cluster_status	Disconnected
wsrep_connected	OFF
wsrep_local_bf_aborts	0
wsrep_local_index	18446744073709551615
wsrep_provider_name
wsrep_provider_vendor
wsrep_provider_version
wsrep_ready	OFF
wsrep_rollbacker_thread_count	0
wsrep_thread_count	0