Debian Codegraph @

mysql-test/suite/wsrep/r/variables.result

raw
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