Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Aborted_clients 332
- Aborted_connects 0
- Binlog_snapshot_file mysql-bin.000522
- Binlog_snapshot_position 834487251
- Binlog_cache_disk_use 6857
- Binlog_cache_use 7016808
- Binlog_stmt_cache_disk_use 0
- Binlog_stmt_cache_use 730
- Bytes_received 234605332831
- Bytes_sent 1034113061157
- Com_admin_commands 854889
- Com_assign_to_keycache 0
- 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_table 0
- Com_alter_tablespace 0
- Com_alter_user 0
- Com_analyze 0
- Com_begin 8197769
- Com_binlog 0
- Com_call_procedure 106414
- Com_change_db 137
- Com_change_master 0
- Com_check 0
- Com_checksum 0
- Com_commit 5878741
- 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 155
- Com_create_trigger 0
- Com_create_udf 0
- Com_create_user 0
- Com_create_view 0
- Com_dealloc_sql 0
- Com_delete 413037
- Com_delete_multi 137592
- 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 309
- Com_drop_trigger 0
- Com_drop_user 0
- Com_drop_view 0
- Com_empty_query 0
- Com_execute_sql 0
- Com_flush 4
- Com_get_diagnostics 0
- Com_grant 0
- Com_ha_close 0
- Com_ha_open 0
- Com_ha_read 0
- Com_help 0
- Com_insert 15287078
- Com_insert_select 2317
- Com_install_plugin 0
- Com_kill 14
- Com_load 0
- Com_lock_tables 1
- Com_lock_tables_for_backup 0
- Com_lock_binlog_for_backup 0
- Com_optimize 0
- Com_preload_keys 0
- Com_prepare_sql 0
- Com_purge 0
- Com_purge_before_date 0
- Com_purge_archived 0
- Com_purge_archived_before_date 0
- Com_release_savepoint 0
- Com_rename_table 155
- Com_rename_user 0
- Com_repair 0
- Com_replace 2417207
- Com_replace_select 0
- Com_reset 0
- Com_resignal 0
- Com_revoke 0
- Com_revoke_all 0
- Com_rollback 2211653
- Com_rollback_to_savepoint 0
- Com_savepoint 0
- Com_select 182457623
- Com_set_option 3953188
- Com_signal 0
- Com_show_binlog_events 0
- Com_show_binlogs 487
- Com_show_charsets 0
- Com_show_client_statistics 0
- Com_show_collations 7
- Com_show_create_db 0
- Com_show_create_event 0
- Com_show_create_func 0
- Com_show_create_proc 0
- Com_show_create_table 38
- Com_show_create_trigger 0
- Com_show_databases 15
- Com_show_engine_logs 0
- Com_show_engine_mutex 0
- Com_show_engine_status 143038
- Com_show_events 0
- Com_show_errors 0
- Com_show_fields 18354
- Com_show_function_code 0
- Com_show_function_status 0
- Com_show_grants 6
- Com_show_index_statistics 0
- Com_show_keys 10486
- Com_show_master_status 23
- 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 142969
- Com_show_profile 0
- Com_show_profiles 0
- Com_show_relaylog_events 0
- Com_show_slave_hosts 3
- Com_show_slave_status 499
- Com_show_slave_status_nolock 962
- Com_show_status 169473
- Com_show_storage_engines 484
- Com_show_table_statistics 0
- Com_show_table_status 75
- Com_show_tables 301
- Com_show_thread_statistics 0
- Com_show_triggers 0
- Com_show_user_statistics 0
- Com_show_variables 15628
- Com_show_warnings 60
- Com_slave_start 0
- Com_slave_stop 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_truncate 156
- Com_uninstall_plugin 0
- Com_unlock_binlog 0
- Com_unlock_tables 0
- Com_update 40196282
- Com_update_multi 118467
- 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 ON
- 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 4437295
- Created_tmp_disk_tables 4880505
- Created_tmp_files 12406
- Created_tmp_tables 17211890
- Delayed_errors 0
- Delayed_insert_threads 0
- Delayed_writes 0
- Flush_commands 1
- Handler_commit 499627209
- Handler_delete 3871744
- Handler_discover 0
- Handler_external_lock 605215501
- Handler_mrr_init 0
- Handler_prepare 54834359
- Handler_read_first 3685341
- Handler_read_key 17934122025
- Handler_read_last 311454
- Handler_read_next 349105456767
- Handler_read_prev 5353040744
- Handler_read_rnd 9541975516
- Handler_read_rnd_next 139481940329
- Handler_rollback 4550132
- Handler_savepoint 0
- Handler_savepoint_rollback 0
- Handler_update 281955816
- Handler_write 1205782949
- Innodb_buffer_pool_dump_status not started
- Innodb_buffer_pool_load_status not started
- Innodb_background_log_sync 143383
- Innodb_buffer_pool_pages_data 1939113
- Innodb_buffer_pool_bytes_data 31770427392
- Innodb_buffer_pool_pages_dirty 95455
- Innodb_buffer_pool_bytes_dirty 1563934720
- Innodb_buffer_pool_pages_flushed 5637805
- Innodb_buffer_pool_pages_LRU_flushed 0
- Innodb_buffer_pool_pages_free 8141
- Innodb_buffer_pool_pages_made_not_young 1615065178
- Innodb_buffer_pool_pages_made_young 46727289
- Innodb_buffer_pool_pages_misc 149890
- Innodb_buffer_pool_pages_old 715665
- Innodb_buffer_pool_pages_total 2097144
- Innodb_buffer_pool_read_ahead_rnd 0
- Innodb_buffer_pool_read_ahead 2451696
- Innodb_buffer_pool_read_ahead_evicted 0
- Innodb_buffer_pool_read_requests 362171746540
- Innodb_buffer_pool_reads 49797223
- Innodb_buffer_pool_wait_free 0
- Innodb_buffer_pool_write_requests 227123752
- Innodb_checkpoint_age 206826629
- Innodb_checkpoint_max_age 1738750649
- Innodb_data_fsyncs 3306449
- Innodb_data_pending_fsyncs 0
- Innodb_data_pending_reads 0
- Innodb_data_pending_writes 0
- Innodb_data_read 876819353600
- Innodb_data_reads 53518405
- Innodb_data_writes 13784399
- Innodb_data_written 200876429312
- Innodb_dblwr_pages_written 5637805
- Innodb_dblwr_writes 714833
- Innodb_deadlocks 1
- Innodb_have_atomic_builtins ON
- Innodb_history_list_length 1159
- Innodb_ibuf_discarded_delete_marks 0
- Innodb_ibuf_discarded_deletes 0
- Innodb_ibuf_discarded_inserts 0
- Innodb_ibuf_free_list 156712
- Innodb_ibuf_merged_delete_marks 1514242
- Innodb_ibuf_merged_deletes 235543
- Innodb_ibuf_merged_inserts 2225283
- Innodb_ibuf_merges 1602974
- Innodb_ibuf_segment_size 156845
- Innodb_ibuf_size 132
- Innodb_log_waits 0
- Innodb_log_write_requests 27593654
- Innodb_log_writes 7403188
- Innodb_lsn_current 15619570205091
- Innodb_lsn_flushed 15619570187208
- Innodb_lsn_last_checkpoint 15619363378462
- Innodb_master_thread_active_loops 143378
- Innodb_master_thread_idle_loops 5
- Innodb_max_trx_id 82151113959
- Innodb_mem_adaptive_hash 3061339392
- Innodb_mem_dictionary 148873095
- Innodb_mem_total 35165044736
- Innodb_mutex_os_waits 486650
- Innodb_mutex_spin_rounds 38036780
- Innodb_mutex_spin_waits 23422622
- Innodb_oldest_view_low_limit_trx_id 82151113115
- Innodb_os_log_fsyncs 171993
- Innodb_os_log_pending_fsyncs 0
- Innodb_os_log_pending_writes 0
- Innodb_os_log_written 16127200768
- Innodb_page_size 16384
- Innodb_pages_created 220035
- Innodb_pages_read 53517294
- Innodb_pages_written 5637805
- Innodb_purge_trx_id 82151113204
- Innodb_purge_undo_no 0
- Innodb_row_lock_current_waits 0
- Innodb_current_row_locks 0
- Innodb_row_lock_time 2574934
- Innodb_row_lock_time_avg 122
- Innodb_row_lock_time_max 51625
- Innodb_row_lock_waits 20978
- Innodb_rows_deleted 3871852
- Innodb_rows_inserted 13465273
- Innodb_rows_read 505375436121
- Innodb_rows_updated 5843568
- Innodb_num_open_files 1023
- Innodb_read_views_memory 7440
- Innodb_descriptors_memory 8000
- Innodb_s_lock_os_waits 4139131
- Innodb_s_lock_spin_rounds 520838387
- Innodb_s_lock_spin_waits 163327438
- Innodb_truncated_status_writes 0
- Innodb_available_undo_logs 128
- Innodb_x_lock_os_waits 454080
- Innodb_x_lock_spin_rounds 249616249
- Innodb_x_lock_spin_waits 11976424
- Key_blocks_not_flushed 0
- Key_blocks_unused 19963
- Key_blocks_used 2660
- Key_read_requests 130213371
- Key_reads 340
- Key_write_requests 47865496
- Key_writes 0
- Last_query_cost 0.000000
- Last_query_partial_plans 0
- Max_statement_time_exceeded 0
- Max_statement_time_set 0
- Max_statement_time_set_failed 0
- Max_used_connections 197
- Not_flushed_delayed_rows 0
- Open_files 8
- Open_streams 0
- Open_table_definitions 911
- Open_tables 1024
- Opened_files 19744600
- Opened_table_definitions 112734
- Opened_tables 61910
- 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 7289
- Qcache_free_memory 24496808
- Qcache_hits 366846302
- Qcache_inserts 141879824
- Qcache_lowmem_prunes 80501088
- Qcache_not_cached 40419444
- Qcache_queries_in_cache 16616
- Qcache_total_blocks 42031
- Queries 634675672
- Questions 632680020
- Rsa_public_key
- Select_full_join 1238385
- Select_full_range_join 2432389
- Select_range 14582049
- Select_range_check 369822
- Select_scan 10971747
- Slave_heartbeat_period 0.000
- Slave_last_heartbeat
- Slave_open_temp_tables 0
- Slave_received_heartbeats 0
- Slave_retried_transactions 0
- Slave_running OFF
- Slow_launch_threads 0
- Slow_queries 1704
- Sort_merge_passes 5166
- Sort_range 21950087
- Sort_rows 2246585958
- Sort_scan 9337969
- 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
- Table_locks_immediate 299979543
- Table_locks_waited 0
- Table_open_cache_hits 300038995
- Table_open_cache_misses 61910
- Table_open_cache_overflows 60328
- 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 127
- Threads_connected 70
- Threads_created 206
- Threads_running 4
- Uptime 144497
- Uptime_since_flush_status 144497
- wsrep_local_state_uuid 62bc5e72-204b-11e8-b276-b7cabab93304
- wsrep_protocol_version 7
- wsrep_last_committed 2429991725
- wsrep_replicated 7017198
- wsrep_replicated_bytes 5701282293
- wsrep_repl_keys 58533552
- wsrep_repl_keys_bytes 629976448
- wsrep_repl_data_bytes 4622205173
- wsrep_repl_other_bytes 0
- wsrep_received 225288
- wsrep_received_bytes 18897440
- wsrep_local_commits 7016370
- wsrep_local_cert_failures 56
- wsrep_local_replays 0
- wsrep_local_send_queue 0
- wsrep_local_send_queue_max 22
- wsrep_local_send_queue_min 0
- wsrep_local_send_queue_avg 0.004206
- wsrep_local_recv_queue 0
- wsrep_local_recv_queue_max 2980
- wsrep_local_recv_queue_min 0
- wsrep_local_recv_queue_avg 20.168407
- wsrep_local_cached_downto 2423708730
- wsrep_flow_control_paused_ns 4896531203
- wsrep_flow_control_paused 0.000034
- wsrep_flow_control_sent 0
- wsrep_flow_control_recv 6
- wsrep_cert_deps_distance 104.425597
- wsrep_apply_oooe 0.102356
- wsrep_apply_oool 0.000050
- wsrep_apply_window 1.195600
- wsrep_commit_oooe 0.000000
- wsrep_commit_oool 0.000007
- wsrep_commit_window 1.068046
- wsrep_local_state 4
- wsrep_local_state_comment Synced
- wsrep_cert_index_size 354
- wsrep_cert_bucket_count 520252
- wsrep_gcache_pool_size 5368710137
- wsrep_causal_reads 0
- wsrep_cert_interval 1.610215
- wsrep_evs_delayed
- wsrep_evs_evict_list
- wsrep_evs_repl_latency 0.0257/0.0319855/0.0491972/0.00780016/549
- wsrep_evs_state OPERATIONAL
- wsrep_gcomm_uuid bbd26159-623b-11ea-94c0-97d10bb3f3ad
- wsrep_cluster_conf_id 575
- wsrep_cluster_size 6
- wsrep_cluster_state_uuid 62bc5e72-204b-11e8-b276-b7cabab93304
- wsrep_cluster_status Primary
- wsrep_connected ON
- wsrep_local_bf_aborts 1
- wsrep_local_index 4
- wsrep_provider_name Galera
- wsrep_provider_vendor Codership Oy <info@codership.com>
- wsrep_provider_version 3.14(r53b88eb)
- wsrep_ready ON
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement