| 1 |
# Correct Galera library found |
| 2 |
SHOW GLOBAL STATUS LIKE 'wsrep%'; |
| 3 |
Variable_name Value |
| 4 |
wsrep_local_state_uuid # |
| 5 |
wsrep_protocol_version # |
| 6 |
wsrep_protocol_application # |
| 7 |
wsrep_protocol_replicator # |
| 8 |
wsrep_protocol_gcs # |
| 9 |
wsrep_last_committed # |
| 10 |
wsrep_replicated # |
| 11 |
wsrep_replicated_bytes # |
| 12 |
wsrep_repl_keys # |
| 13 |
wsrep_repl_keys_bytes # |
| 14 |
wsrep_repl_data_bytes # |
| 15 |
wsrep_repl_other_bytes # |
| 16 |
wsrep_received # |
| 17 |
wsrep_received_bytes # |
| 18 |
wsrep_local_commits # |
| 19 |
wsrep_local_cert_failures # |
| 20 |
wsrep_local_replays # |
| 21 |
wsrep_local_send_queue # |
| 22 |
wsrep_local_send_queue_max # |
| 23 |
wsrep_local_send_queue_min # |
| 24 |
wsrep_local_send_queue_avg # |
| 25 |
wsrep_local_recv_queue # |
| 26 |
wsrep_local_recv_queue_max # |
| 27 |
wsrep_local_recv_queue_min # |
| 28 |
wsrep_local_recv_queue_avg # |
| 29 |
wsrep_local_cached_downto # |
| 30 |
wsrep_flow_control_paused_ns # |
| 31 |
wsrep_flow_control_paused # |
| 32 |
wsrep_flow_control_sent # |
| 33 |
wsrep_flow_control_recv # |
| 34 |
wsrep_flow_control_active # |
| 35 |
wsrep_flow_control_requested # |
| 36 |
wsrep_cert_deps_distance # |
| 37 |
wsrep_apply_oooe # |
| 38 |
wsrep_apply_oool # |
| 39 |
wsrep_apply_window # |
| 40 |
wsrep_apply_waits # |
| 41 |
wsrep_commit_oooe # |
| 42 |
wsrep_commit_oool # |
| 43 |
wsrep_commit_window # |
| 44 |
wsrep_local_state # |
| 45 |
wsrep_local_state_comment # |
| 46 |
wsrep_cert_index_size # |
| 47 |
wsrep_causal_reads # |
| 48 |
wsrep_cert_interval # |
| 49 |
wsrep_open_transactions # |
| 50 |
wsrep_open_connections # |
| 51 |
wsrep_incoming_addresses # |
| 52 |
wsrep_cluster_weight # |
| 53 |
wsrep_desync_count # |
| 54 |
wsrep_evs_delayed # |
| 55 |
wsrep_evs_evict_list # |
| 56 |
wsrep_evs_repl_latency # |
| 57 |
wsrep_evs_state # |
| 58 |
wsrep_gcomm_uuid # |
| 59 |
wsrep_gmcast_segment # |
| 60 |
wsrep_checkpoint_position # |
| 61 |
wsrep_se_checkpoint # |
| 62 |
wsrep_applier_thread_count # |
| 63 |
wsrep_cluster_capabilities # |
| 64 |
wsrep_cluster_conf_id # |
| 65 |
wsrep_cluster_size # |
| 66 |
wsrep_cluster_state_uuid # |
| 67 |
wsrep_cluster_status # |
| 68 |
wsrep_connected # |
| 69 |
wsrep_local_bf_aborts # |
| 70 |
wsrep_local_index # |
| 71 |
wsrep_provider_capabilities # |
| 72 |
wsrep_provider_name # |
| 73 |
wsrep_provider_vendor # |
| 74 |
wsrep_provider_version # |
| 75 |
wsrep_ready # |
| 76 |
wsrep_rollbacker_thread_count # |
| 77 |
wsrep_thread_count # |
| 78 |
# Should show nothing. |
| 79 |
SHOW STATUS LIKE 'x'; |
| 80 |
Variable_name Value |
| 81 |
SELECT @@global.wsrep_cluster_address; |
| 82 |
@@global.wsrep_cluster_address |
| 83 |
gcomm:// |
| 84 |
SELECT @@global.wsrep_on; |
| 85 |
@@global.wsrep_on |
| 86 |
1 |
| 87 |
SHOW STATUS LIKE 'threads_connected'; |
| 88 |
Variable_name Value |
| 89 |
Threads_connected 1 |
| 90 |
SHOW STATUS LIKE 'wsrep_thread_count'; |
| 91 |
Variable_name Value |
| 92 |
wsrep_thread_count 2 |
| 93 |
# variables |
| 94 |
SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep%" ORDER BY VARIABLE_NAME; |
| 95 |
VARIABLE_NAME |
| 96 |
WSREP_ALLOWLIST |
| 97 |
WSREP_AUTO_INCREMENT_CONTROL |
| 98 |
WSREP_CERTIFICATION_RULES |
| 99 |
WSREP_CERTIFY_NONPK |
| 100 |
WSREP_CLUSTER_ADDRESS |
| 101 |
WSREP_CLUSTER_NAME |
| 102 |
WSREP_CONVERT_LOCK_TO_TRX |
| 103 |
WSREP_DATA_HOME_DIR |
| 104 |
WSREP_DBUG_OPTION |
| 105 |
WSREP_DEBUG |
| 106 |
WSREP_DESYNC |
| 107 |
WSREP_DIRTY_READS |
| 108 |
WSREP_DRUPAL_282555_WORKAROUND |
| 109 |
WSREP_FORCED_BINLOG_FORMAT |
| 110 |
WSREP_GTID_DOMAIN_ID |
| 111 |
WSREP_GTID_MODE |
| 112 |
WSREP_GTID_SEQ_NO |
| 113 |
WSREP_IGNORE_APPLY_ERRORS |
| 114 |
WSREP_LOG_CONFLICTS |
| 115 |
WSREP_MAX_WS_ROWS |
| 116 |
WSREP_MAX_WS_SIZE |
| 117 |
WSREP_MODE |
| 118 |
WSREP_MYSQL_REPLICATION_BUNDLE |
| 119 |
WSREP_NODE_ADDRESS |
| 120 |
WSREP_NODE_INCOMING_ADDRESS |
| 121 |
WSREP_NODE_NAME |
| 122 |
WSREP_NOTIFY_CMD |
| 123 |
WSREP_ON |
| 124 |
WSREP_OSU_METHOD |
| 125 |
WSREP_PATCH_VERSION |
| 126 |
WSREP_PROVIDER |
| 127 |
WSREP_PROVIDER_OPTIONS |
| 128 |
WSREP_RECOVER |
| 129 |
WSREP_REJECT_QUERIES |
| 130 |
WSREP_RESTART_SLAVE |
| 131 |
WSREP_RETRY_AUTOCOMMIT |
| 132 |
WSREP_SLAVE_FK_CHECKS |
| 133 |
WSREP_SLAVE_THREADS |
| 134 |
WSREP_SLAVE_UK_CHECKS |
| 135 |
WSREP_SR_STORE |
| 136 |
WSREP_SST_AUTH |
| 137 |
WSREP_SST_DONOR |
| 138 |
WSREP_SST_DONOR_REJECTS_QUERIES |
| 139 |
WSREP_SST_METHOD |
| 140 |
WSREP_SST_RECEIVE_ADDRESS |
| 141 |
WSREP_START_POSITION |
| 142 |
WSREP_STATUS_FILE |
| 143 |
WSREP_SYNC_WAIT |
| 144 |
WSREP_TRX_FRAGMENT_SIZE |
| 145 |
WSREP_TRX_FRAGMENT_UNIT |