mirror of
https://github.com/MariaDB/server.git
synced 2025-02-13 17:05:35 +01:00
122 lines
4.4 KiB
Text
122 lines
4.4 KiB
Text
SELECT COUNT(*) = 43 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'wsrep_%';
|
|
COUNT(*) = 43
|
|
1
|
|
SELECT VARIABLE_NAME, VARIABLE_VALUE
|
|
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
|
|
WHERE VARIABLE_NAME LIKE 'wsrep_%'
|
|
AND VARIABLE_NAME NOT IN (
|
|
'WSREP_PROVIDER_OPTIONS',
|
|
'WSREP_SST_RECEIVE_ADDRESS',
|
|
'WSREP_NODE_ADDRESS',
|
|
'WSREP_NODE_NAME',
|
|
'WSREP_PROVIDER',
|
|
'WSREP_DATA_HOME_DIR',
|
|
'WSREP_NODE_INCOMING_ADDRESS',
|
|
'WSREP_START_POSITION',
|
|
'WSREP_PATCH_VERSION'
|
|
)
|
|
ORDER BY VARIABLE_NAME;
|
|
VARIABLE_NAME VARIABLE_VALUE
|
|
WSREP_AUTO_INCREMENT_CONTROL ON
|
|
WSREP_CAUSAL_READS ON
|
|
WSREP_CERTIFY_NONPK ON
|
|
WSREP_CLUSTER_ADDRESS gcomm://
|
|
WSREP_CLUSTER_NAME my_wsrep_cluster
|
|
WSREP_CONVERT_LOCK_TO_TRX OFF
|
|
WSREP_DBUG_OPTION
|
|
WSREP_DEBUG OFF
|
|
WSREP_DESYNC OFF
|
|
WSREP_DIRTY_READS OFF
|
|
WSREP_DRUPAL_282555_WORKAROUND OFF
|
|
WSREP_FORCED_BINLOG_FORMAT NONE
|
|
WSREP_GTID_DOMAIN_ID 0
|
|
WSREP_GTID_MODE OFF
|
|
WSREP_LOAD_DATA_SPLITTING ON
|
|
WSREP_LOG_CONFLICTS OFF
|
|
WSREP_MAX_WS_ROWS 0
|
|
WSREP_MAX_WS_SIZE 2147483647
|
|
WSREP_MYSQL_REPLICATION_BUNDLE 0
|
|
WSREP_NOTIFY_CMD
|
|
WSREP_ON ON
|
|
WSREP_OSU_METHOD TOI
|
|
WSREP_RECOVER OFF
|
|
WSREP_REPLICATE_MYISAM OFF
|
|
WSREP_RESTART_SLAVE OFF
|
|
WSREP_RETRY_AUTOCOMMIT 1
|
|
WSREP_SLAVE_FK_CHECKS ON
|
|
WSREP_SLAVE_THREADS 1
|
|
WSREP_SLAVE_UK_CHECKS OFF
|
|
WSREP_SST_AUTH
|
|
WSREP_SST_DONOR
|
|
WSREP_SST_DONOR_REJECTS_QUERIES OFF
|
|
WSREP_SST_METHOD rsync
|
|
WSREP_SYNC_WAIT 7
|
|
<BASE_DIR>; <BASE_HOST>; <BASE_PORT>; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT10S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = P1D; <GCACHE_DIR>; gcache.keep_pages_size = 0; gcache.mem_size = 0; <GCACHE_NAME>; gcache.page_size = 128M; gcache.recover = no; gcache.size = 10M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; <GCS_RECV_Q_HARD_LIMIT>; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; <GMCAST_LISTEN_ADDR>; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; <IST_RECV_ADDR>; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT90S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 7; socket.checksum = 2; socket.recv_buf_size = 212992;
|
|
SELECT COUNT(*) FROM INFORMATION_SCHEMA.GLOBAL_STATUS
|
|
WHERE VARIABLE_NAME LIKE 'wsrep_%'
|
|
AND VARIABLE_NAME != 'wsrep_debug_sync_waiters';
|
|
COUNT(*)
|
|
58
|
|
SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.GLOBAL_STATUS
|
|
WHERE VARIABLE_NAME LIKE 'wsrep_%'
|
|
AND VARIABLE_NAME != 'wsrep_debug_sync_waiters'
|
|
ORDER BY VARIABLE_NAME;
|
|
VARIABLE_NAME
|
|
WSREP_APPLY_OOOE
|
|
WSREP_APPLY_OOOL
|
|
WSREP_APPLY_WINDOW
|
|
WSREP_CAUSAL_READS
|
|
WSREP_CERT_DEPS_DISTANCE
|
|
WSREP_CERT_INDEX_SIZE
|
|
WSREP_CERT_INTERVAL
|
|
WSREP_CLUSTER_CONF_ID
|
|
WSREP_CLUSTER_SIZE
|
|
WSREP_CLUSTER_STATE_UUID
|
|
WSREP_CLUSTER_STATUS
|
|
WSREP_COMMIT_OOOE
|
|
WSREP_COMMIT_OOOL
|
|
WSREP_COMMIT_WINDOW
|
|
WSREP_CONNECTED
|
|
WSREP_DESYNC_COUNT
|
|
WSREP_EVS_DELAYED
|
|
WSREP_EVS_EVICT_LIST
|
|
WSREP_EVS_REPL_LATENCY
|
|
WSREP_EVS_STATE
|
|
WSREP_FLOW_CONTROL_PAUSED
|
|
WSREP_FLOW_CONTROL_PAUSED_NS
|
|
WSREP_FLOW_CONTROL_RECV
|
|
WSREP_FLOW_CONTROL_SENT
|
|
WSREP_GCOMM_UUID
|
|
WSREP_INCOMING_ADDRESSES
|
|
WSREP_LAST_COMMITTED
|
|
WSREP_LOCAL_BF_ABORTS
|
|
WSREP_LOCAL_CACHED_DOWNTO
|
|
WSREP_LOCAL_CERT_FAILURES
|
|
WSREP_LOCAL_COMMITS
|
|
WSREP_LOCAL_INDEX
|
|
WSREP_LOCAL_RECV_QUEUE
|
|
WSREP_LOCAL_RECV_QUEUE_AVG
|
|
WSREP_LOCAL_RECV_QUEUE_MAX
|
|
WSREP_LOCAL_RECV_QUEUE_MIN
|
|
WSREP_LOCAL_REPLAYS
|
|
WSREP_LOCAL_SEND_QUEUE
|
|
WSREP_LOCAL_SEND_QUEUE_AVG
|
|
WSREP_LOCAL_SEND_QUEUE_MAX
|
|
WSREP_LOCAL_SEND_QUEUE_MIN
|
|
WSREP_LOCAL_STATE
|
|
WSREP_LOCAL_STATE_COMMENT
|
|
WSREP_LOCAL_STATE_UUID
|
|
WSREP_PROTOCOL_VERSION
|
|
WSREP_PROVIDER_NAME
|
|
WSREP_PROVIDER_VENDOR
|
|
WSREP_PROVIDER_VERSION
|
|
WSREP_READY
|
|
WSREP_RECEIVED
|
|
WSREP_RECEIVED_BYTES
|
|
WSREP_REPLICATED
|
|
WSREP_REPLICATED_BYTES
|
|
WSREP_REPL_DATA_BYTES
|
|
WSREP_REPL_KEYS
|
|
WSREP_REPL_KEYS_BYTES
|
|
WSREP_REPL_OTHER_BYTES
|
|
WSREP_THREAD_COUNT
|