Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SHOW GLOBAL STATUS;
- Variable_name
- Value
- Aborted_clients
- 0
- Aborted_connects
- 0
- Binlog_cache_disk_use
- 181
- Binlog_cache_use
- 50942
- Binlog_stmt_cache_disk_use
- 0
- Binlog_stmt_cache_use
- 16
- Bytes_received
- 945512244
- Bytes_sent
- 27166489390
- Com_admin_commands
- 0
- 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
- 43211
- 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
- 178
- 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
- 49151
- Com_insert_select
- 0
- Com_install_plugin
- 0
- Com_kill
- 0
- Com_load
- 128
- Com_lock_tables
- 84
- 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
- 4228647
- Com_set_option
- 134216
- Com_signal
- 0
- Com_show_binlog_events
- 0
- Com_show_binlogs
- 1
- Com_show_charsets
- 0
- Com_show_collations
- 0
- Com_show_create_db
- 0
- Com_show_create_event
- 0
- Com_show_create_func
- 0
- Com_show_create_proc
- 0
- Variable_name
- Value
- Com_show_create_table
- 2246
- Com_show_create_trigger
- 0
- Com_show_databases
- 1
- Com_show_engine_logs
- 0
- Com_show_engine_mutex
- 0
- Com_show_engine_status
- 1
- Com_show_events
- 0
- Com_show_errors
- 0
- Com_show_fields
- 4492
- Com_show_function_code
- 0
- Com_show_function_status
- 0
- 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
- 0
- Com_show_processlist
- 24
- 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
- 2
- Com_show_storage_engines
- 0
- Com_show_table_status
- 2246
- Com_show_tables
- 84
- Com_show_triggers
- 2246
- Com_show_variables
- 288
- Com_show_warnings
- 26
- 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
- 4356428
- Com_stmt_close
- 4356427
- Com_stmt_fetch
- 0
- Com_stmt_prepare
- 4356428
- Com_stmt_reset
- 0
- Com_stmt_send_long_data
- 0
- Com_truncate
- 16
- Com_uninstall_plugin
- 0
- Com_unlock_tables
- 84
- Com_update
- 1619
- 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
- 1
- 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
- 41161
- Created_tmp_disk_tables
- 6906
- Created_tmp_files
- 198
- Created_tmp_tables
- 18358
- Delayed_errors
- 0
- Delayed_insert_threads
- 0
- Delayed_writes
- 0
- Flush_commands
- 1
- Handler_commit
- 4328269
- Handler_delete
- 289895
- Handler_discover
- 0
- Handler_external_lock
- 9103523
- Handler_mrr_init
- 0
- Handler_prepare
- 101884
- Handler_read_first
- 3102652
- Handler_read_key
- 27583695
- Handler_read_last
- 0
- Handler_read_next
- 2074195
- Handler_read_prev
- 0
- Handler_read_rnd
- 22904990
- Handler_read_rnd_next
- 4114074059
- Handler_rollback
- 0
- Handler_savepoint
- 0
- Handler_savepoint_rollback
- 0
- Handler_update
- 1512
- Handler_write
- 1143585
- Innodb_buffer_pool_dump_status
- Dumping of buffer pool not started
- Innodb_buffer_pool_load_status
- Buffer pool(s) load completed at 200421 21:11:28
- Innodb_buffer_pool_resize_status
- Innodb_buffer_pool_pages_data
- 256
- Innodb_buffer_pool_bytes_data
- 4194304
- Innodb_buffer_pool_pages_dirty
- 0
- Innodb_buffer_pool_bytes_dirty
- 0
- Innodb_buffer_pool_pages_flushed
- 72409
- Innodb_buffer_pool_pages_free
- 374
- Innodb_buffer_pool_pages_misc
- 10
- Innodb_buffer_pool_pages_total
- 640
- Innodb_buffer_pool_read_ahead_rnd
- 0
- Variable_name
- Value
- Innodb_buffer_pool_read_ahead
- 1247717
- Innodb_buffer_pool_read_ahead_evicted
- 269668
- Innodb_buffer_pool_read_requests
- 1424193774
- Innodb_buffer_pool_reads
- 3069973
- Innodb_buffer_pool_wait_free
- 317
- Innodb_buffer_pool_write_requests
- 2019108
- Innodb_data_fsyncs
- 73875
- Innodb_data_pending_fsyncs
- 0
- Innodb_data_pending_reads
- 0
- Innodb_data_pending_writes
- 0
- Innodb_data_read
- 70742774272
- Innodb_data_reads
- 4322331
- Innodb_data_writes
- 137869
- Innodb_data_written
- 2668980224
- Innodb_dblwr_pages_written
- 72216
- Innodb_dblwr_writes
- 4924
- Innodb_log_waits
- 0
- Innodb_log_write_requests
- 564316
- Innodb_log_writes
- 57496
- Innodb_os_log_fsyncs
- 59316
- Innodb_os_log_pending_fsyncs
- 0
- Innodb_os_log_pending_writes
- 0
- Innodb_os_log_written
- 294125056
- Innodb_page_size
- 16384
- Innodb_pages_created
- 5227
- Innodb_pages_read
- 4317689
- Innodb_pages_written
- 72677
- 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
- 289895
- Innodb_rows_inserted
- 473611
- Innodb_rows_read
- 4138750389
- Innodb_rows_updated
- 1512
- Innodb_num_open_files
- 400
- Innodb_truncated_status_writes
- 0
- Innodb_available_undo_logs
- 128
- Key_blocks_not_flushed
- 0
- Key_blocks_unused
- 107171
- Key_blocks_used
- 3
- Key_read_requests
- 8
- Key_reads
- 5
- 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
- 62
- Max_used_connections_time
- 2020-04-21 21:57:37
- Not_flushed_delayed_rows
- 0
- Ongoing_anonymous_transaction_count
- 0
- Open_files
- 2
- Open_streams
- 0
- Open_table_definitions
- 600
- Open_tables
- 400
- Opened_files
- 4000
- Opened_table_definitions
- 3551
- Opened_tables
- 102048
- Performance_schema_accounts_lost
- 0
- Performance_schema_cond_classes_lost
- 0
- Performance_schema_cond_instances_lost
- 0
- Performance_schema_digest_lost
- 10266
- 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
- 67091584
- Qcache_hits
- 0
- Qcache_inserts
- 0
- Qcache_lowmem_prunes
- 0
- Qcache_not_cached
- 4224154
- Qcache_queries_in_cache
- 0
- Qcache_total_blocks
- 1
- Variable_name
- Value
- Queries
- 13223054
- Questions
- 4510199
- Rsa_public_key
- -----BEGIN PUBLIC KEY-----
- MIIBIjANBgkqhkiG9w0BAQE...
- Select_full_join
- 4471
- Select_full_range_join
- 0
- Select_range
- 18898
- Select_range_check
- 0
- Select_scan
- 3090085
- Slave_open_temp_tables
- 0
- Slow_launch_threads
- 0
- Slow_queries
- 0
- Sort_merge_passes
- 50
- Sort_range
- 7952
- Sort_rows
- 55652781
- Sort_scan
- 766726
- 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
- 18446744073709551615
- Ssl_ctx_verify_mode
- 5
- Ssl_default_timeout
- 0
- Ssl_finished_accepts
- 0
- Ssl_finished_connects
- 0
- Ssl_server_not_after
- Dec 24 16:51:37 2029 GMT
- Ssl_server_not_before
- Dec 27 16:51:37 2019 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
- 0
- Ssl_verify_depth
- 0
- Ssl_verify_mode
- 0
- Ssl_version
- Table_locks_immediate
- 389
- Table_locks_waited
- 0
- Table_open_cache_hits
- 9009786
- Table_open_cache_misses
- 102048
- Table_open_cache_overflows
- 101603
- Tc_log_max_pages_used
- 0
- Tc_log_page_size
- 0
- Tc_log_page_waits
- 0
- Threads_cached
- 60
- Threads_connected
- 2
- Threads_created
- 62
- Threads_running
- 1
- Uptime
- 47874
- Uptime_since_flush_status
- 47874
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement