global_variables

Variable_name
Value
Aborted_clients
4282
Aborted_connects
2
Binlog_cache_disk_use
0
Binlog_cache_use
0
Binlog_stmt_cache_disk_use
0
Binlog_stmt_cache_use
0
Bytes_received
171405217
Bytes_sent
677742461
Com_admin_commands
6
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
4294
Com_change_db
212976
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
1
Com_create_function
0
Com_create_index
0
Com_create_procedure
7
Com_create_server
0
Com_create_table
4305
Com_create_trigger
0
Com_create_udf
0
Com_create_user
0
Com_create_view
0
Com_dealloc_sql
0
Com_delete
282
Com_delete_multi
0
Com_do
0
Com_drop_db
0
Com_drop_event
1
Com_drop_function
0
Com_drop_index
0
Com_drop_procedure
7
Com_drop_server
0
Com_drop_table
8382
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
178435
Com_insert_select
180691
Com_install_plugin
0
Com_kill
1
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
877123
Com_set_option
897688
Com_signal
0
Com_show_binlog_events
0
Com_show_binlogs
2
Com_show_charsets
0
Com_show_collations
0
Com_show_create_db
0
Com_show_create_event
9
Com_show_create_func
4
Com_show_create_proc
99
Variable_name
Value

Com_show_create_table
159
Com_show_create_trigger
0
Com_show_databases
6
Com_show_engine_logs
0
Com_show_engine_mutex
0
Com_show_engine_status
12
Com_show_events
0
Com_show_errors
0
Com_show_fields
2207
Com_show_function_code
0
Com_show_function_status
2
Com_show_grants
2
Com_show_keys
2010
Com_show_master_status
202
Com_show_open_tables
0
Com_show_plugins
1
Com_show_privileges
0
Com_show_procedure_code
0
Com_show_procedure_status
2
Com_show_processlist
209
Com_show_profile
0
Com_show_profiles
0
Com_show_relaylog_events
0
Com_show_slave_hosts
3
Com_show_slave_status
205
Com_show_status
244
Com_show_storage_engines
3
Com_show_table_status
68
Com_show_tables
711
Com_show_triggers
0
Com_show_variables
671
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
14368
Com_update_multi
466
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
215287
Created_tmp_disk_tables
3481
Created_tmp_files
56
Created_tmp_tables
28237
Delayed_errors
0
Delayed_insert_threads
0
Delayed_writes
0
Flush_commands
1
Handler_commit
718178
Handler_delete
235247
Handler_discover
0
Handler_external_lock
2755963
Handler_mrr_init
0
Handler_prepare
0
Handler_read_first
72929
Handler_read_key
61814878
Handler_read_last
166531
Handler_read_next
936864796
Handler_read_prev
249228641
Handler_read_rnd
49362449
Handler_read_rnd_next
173172089
Handler_rollback
2671
Handler_savepoint
0
Handler_savepoint_rollback
0
Handler_update
10874623
Handler_write
3375434
Innodb_buffer_pool_dump_status
Dumping of buffer pool not started
Innodb_buffer_pool_load_status
Buffer pool(s) load completed at 181008 15:19:24
Innodb_buffer_pool_resize_status
Completed resizing buffer pool at 181008 16:55:20.
Innodb_buffer_pool_pages_data
23904
Innodb_buffer_pool_bytes_data
391643136
Innodb_buffer_pool_pages_dirty
0
Innodb_buffer_pool_bytes_dirty
0
Innodb_buffer_pool_pages_flushed
29733
Innodb_buffer_pool_pages_free
41136
Innodb_buffer_pool_pages_misc
488
Innodb_buffer_pool_pages_total
65528
Innodb_buffer_pool_read_ahead_rnd
0
Variable_name
Value

Innodb_buffer_pool_read_ahead
5955
Innodb_buffer_pool_read_ahead_evicted
0
Innodb_buffer_pool_read_requests
884966485
Innodb_buffer_pool_reads
13598
Innodb_buffer_pool_wait_free
0
Innodb_buffer_pool_write_requests
5118973
Innodb_data_fsyncs
142096
Innodb_data_pending_fsyncs
0
Innodb_data_pending_reads
0
Innodb_data_pending_writes
0
Innodb_data_read
327078400
Innodb_data_reads
20037
Innodb_data_writes
165576
Innodb_data_written
1257664000
Innodb_dblwr_pages_written
28052
Innodb_dblwr_writes
3599
Innodb_log_waits
0
Innodb_log_write_requests
368403
Innodb_log_writes
131567
Innodb_os_log_fsyncs
132266
Innodb_os_log_pending_fsyncs
0
Innodb_os_log_pending_writes
0
Innodb_os_log_written
310645248
Innodb_page_size
16384
Innodb_pages_created
3946
Innodb_pages_read
19958
Innodb_pages_written
29733
Innodb_row_lock_current_waits
0
Innodb_row_lock_time
32711
Innodb_row_lock_time_avg
13
Innodb_row_lock_time_max
2610
Innodb_row_lock_waits
2461
Innodb_rows_deleted
235239
Innodb_rows_inserted
426593
Innodb_rows_read
1407125111
Innodb_rows_updated
18015
Innodb_num_open_files
70
Innodb_truncated_status_writes
0
Innodb_available_undo_logs
128
Key_blocks_not_flushed
0
Key_blocks_unused
107152
Key_blocks_used
19
Key_read_requests
25940
Key_reads
19
Key_write_requests
70
Key_writes
50
Locked_connects
0
Max_execution_time_exceeded
0
Max_execution_time_set
0
Max_execution_time_set_failed
0
Max_used_connections
137
Max_used_connections_time
2018-10-08 16:52:41
Not_flushed_delayed_rows
0
Ongoing_anonymous_transaction_count
0
Open_files
249
Open_streams
0
Open_table_definitions
272
Open_tables
2610
Opened_files
13824
Opened_table_definitions
8882
Opened_tables
6922
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
523240
Qcache_queries_in_cache
0
Qcache_total_blocks
1
Variable_name
Value

Queries
5463810
Questions
1954844
Select_full_join
5649
Select_full_range_join
0
Select_range
54662
Select_range_check
0
Select_scan
245085
Slave_open_temp_tables
0
Slow_launch_threads
0
Slow_queries
8014
Sort_merge_passes
25
Sort_range
144
Sort_rows
627086
Sort_scan
7145
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
Jul 19 13:42:05 2028 GMT
Ssl_server_not_before
Jul 22 13:42:05 2018 GMT
Ssl_session_cache_hits
0
Ssl_session_cache_misses
0
Ssl_session_cache_mode
Unknown
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
Table_locks_immediate
6319
Table_locks_waited
0
Table_open_cache_hits
1223380
Table_open_cache_misses
2617
Table_open_cache_overflows
0
Tc_log_max_pages_used
0
Tc_log_page_size
0
Tc_log_page_waits
0
Threads_cached
10
Threads_connected
2
Threads_created
2789
Threads_running
2
Uptime
11811
Uptime_since_flush_status
11811