mysql> show global status like 'wsrep%'; +----------------------------------+----------------------------------------------------+ | Variable_name | Value | +----------------------------------+----------------------------------------------------+ | wsrep_local_state_uuid | 5c018094-5273-11e7-9d82-6a3ed29232e8 | | wsrep_protocol_version | 7 | | wsrep_last_committed | 334670600 | | wsrep_replicated | 1179227 | | wsrep_replicated_bytes | 698270839 | | wsrep_repl_keys | 4480593 | | wsrep_repl_keys_bytes | 62966970 | | wsrep_repl_data_bytes | 559833341 | | wsrep_repl_other_bytes | 0 | | wsrep_received | 17969 | | wsrep_received_bytes | 143974 | | wsrep_local_commits | 1179227 | | wsrep_local_cert_failures | 0 | | wsrep_local_replays | 0 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_max | 14 | | wsrep_local_send_queue_min | 0 | | wsrep_local_send_queue_avg | 0.006466 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_max | 2 | | wsrep_local_recv_queue_min | 0 | | wsrep_local_recv_queue_avg | 0.000223 | | wsrep_local_cached_downto | 333491374 | | wsrep_flow_control_paused_ns | 0 | | wsrep_flow_control_paused | 0.000000 | | wsrep_flow_control_sent | 0 | | wsrep_flow_control_recv | 0 | | wsrep_flow_control_interval | [ 141, 141 ] | | wsrep_flow_control_interval_low | 141 | | wsrep_flow_control_interval_high | 141 | | wsrep_flow_control_status | OFF | | wsrep_cert_deps_distance | 56.274508 | | wsrep_apply_oooe | 0.156662 | | wsrep_apply_oool | 0.002982 | | wsrep_apply_window | 1.189010 | | wsrep_commit_oooe | 0.000000 | | wsrep_commit_oool | 0.000000 | | wsrep_commit_window | 1.001159 | | wsrep_local_state | 4 | | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 117 | | wsrep_cert_bucket_count | 420 | | wsrep_gcache_pool_size | 745441453 | | wsrep_causal_reads | 0 | | wsrep_cert_interval | 0.100975 | | wsrep_ist_receive_status | | | wsrep_ist_receive_seqno_start | 0 | | wsrep_ist_receive_seqno_current | 0 | | wsrep_ist_receive_seqno_end | 0 | | wsrep_incoming_addresses | 10.103.30.113:3306,10.103.30.112:3306 | | wsrep_desync_count | 0 | | wsrep_evs_delayed | | | wsrep_evs_evict_list | | | wsrep_evs_repl_latency | 0.000263536/0.000508095/0.00229247/0.00023323/1214 | | wsrep_evs_state | OPERATIONAL | | wsrep_gcomm_uuid | aa3eb25f-65e0-11e7-971a-b2649293b4b0 | | wsrep_cluster_conf_id | 27 | | wsrep_cluster_size | 2 | | wsrep_cluster_state_uuid | 5c018094-5273-11e7-9d82-6a3ed29232e8 | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 1 | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy <email address hidden> | | wsrep_provider_version | 3.20(r7e383f7) | | wsrep_ready | ON | +----------------------------------+----------------------------------------------------+ 67 rows in set (0.01 sec)
mysql> show global status like 'wsrep%'; ------- ------- ------- ------- +------ ------- ------- ------- ------- ------- ------- ----+ ------- ------- ------- ------- +------ ------- ------- ------- ------- ------- ------- ----+ state_uuid | 5c018094- 5273-11e7- 9d82-6a3ed29232 e8 | version | 7 | committed | 334670600 | d_bytes | 698270839 | keys_bytes | 62966970 | data_bytes | 559833341 | other_bytes | 0 | bytes | 143974 | cert_failures | 0 | send_queue | 0 | send_queue_ max | 14 | send_queue_ min | 0 | send_queue_ avg | 0.006466 | recv_queue | 0 | recv_queue_ max | 2 | recv_queue_ min | 0 | recv_queue_ avg | 0.000223 | cached_ downto | 333491374 | control_ paused_ ns | 0 | control_ paused | 0.000000 | control_ sent | 0 | control_ recv | 0 | control_ interval | [ 141, 141 ] | control_ interval_ low | 141 | control_ interval_ high | 141 | control_ status | OFF | deps_distance | 56.274508 | state_comment | Synced | index_size | 117 | bucket_ count | 420 | pool_size | 745441453 | receive_ status | | receive_ seqno_start | 0 | receive_ seqno_current | 0 | receive_ seqno_end | 0 | addresses | 10.103. 30.113: 3306,10. 103.30. 112:3306 | evict_list | | repl_latency | 0.000263536/ 0.000508095/ 0.00229247/ 0.00023323/ 1214 | 65e0-11e7- 971a-b2649293b4 b0 | conf_id | 27 | state_uuid | 5c018094- 5273-11e7- 9d82-6a3ed29232 e8 | status | Primary | bf_aborts | 0 | vendor | Codership Oy <email address hidden> | version | 3.20(r7e383f7) | ------- ------- ------- ------- +------ ------- ------- ------- ------- ------- ------- ----+
+------
| Variable_name | Value |
+------
| wsrep_local_
| wsrep_protocol_
| wsrep_last_
| wsrep_replicated | 1179227 |
| wsrep_replicate
| wsrep_repl_keys | 4480593 |
| wsrep_repl_
| wsrep_repl_
| wsrep_repl_
| wsrep_received | 17969 |
| wsrep_received_
| wsrep_local_commits | 1179227 |
| wsrep_local_
| wsrep_local_replays | 0 |
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_cert_
| wsrep_apply_oooe | 0.156662 |
| wsrep_apply_oool | 0.002982 |
| wsrep_apply_window | 1.189010 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 1.001159 |
| wsrep_local_state | 4 |
| wsrep_local_
| wsrep_cert_
| wsrep_cert_
| wsrep_gcache_
| wsrep_causal_reads | 0 |
| wsrep_cert_interval | 0.100975 |
| wsrep_ist_
| wsrep_ist_
| wsrep_ist_
| wsrep_ist_
| wsrep_incoming_
| wsrep_desync_count | 0 |
| wsrep_evs_delayed | |
| wsrep_evs_
| wsrep_evs_
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | aa3eb25f-
| wsrep_cluster_
| wsrep_cluster_size | 2 |
| wsrep_cluster_
| wsrep_cluster_
| wsrep_connected | ON |
| wsrep_local_
| wsrep_local_index | 1 |
| wsrep_provider_name | Galera |
| wsrep_provider_
| wsrep_provider_
| wsrep_ready | ON |
+------
67 rows in set (0.01 sec)