Galera Cluster Status Variables
You are viewing an old version of this article. View
the current version here.
Contents
- Viewing Galera Cluster Status variables
- List of Galera Cluster Status variables
- wsrep_apply_oooe
- wsrep_apply_oool
- wsrep_cert_deps_distance
- wsrep_cluster_size
- wsrep_cluster_state_uuid
- wsrep_cluster_status
- wsrep_connected
- wsrep_flow_control_paused
- wsrep_flow_control_recv
- wsrep_flow_control_sent
- wsrep_last_committed
- wsrep_local_bf_aborts
- wsrep_local_cert_failures
- wsrep_local_commits
- wsrep_local_index
- wsrep_local_recv_queue
- wsrep_local_recv_queue_avg
- wsrep_local_replays
- wsrep_local_send_queue
- wsrep_local_send_queue_avg
- 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_thread_count
Viewing Galera Cluster Status variables
Galera Status variables can be viewed with the SHOW STATUS statement.
SHOW STATUS LIKE 'wsrep%';
See also the Full list of MariaDB options, system and status variables.
List of Galera Cluster Status variables
MariaDB Galera Cluster has the following status variables:
wsrep_apply_oooe
- Description: How often writesets have been applied out of order, an indicators of parallelization efficiency.
wsrep_apply_oool
- Description: How often writesets with a higher sequence number were applied before ones with a lower sequence number, implying slow writesets.
wsrep_cert_deps_distance
- Description: Average distance between the highest and the lowest sequence numbers that can possibly be applied in parallel, or the potential degree of parallelization.
wsrep_cluster_size
- Description: Number of nodes currently in the cluster.
wsrep_cluster_state_uuid
- Description: UUID state of the cluster. If it matches the value in wsrep_local_state_uuid, the local and cluster nodes are in sync.
wsrep_cluster_status
- Description: Cluster component status. Possible values are
PRIMARY
,NON_PRIMARY
orDISCONNECTED
.
wsrep_connected
- Description: Whether or not MariaDB is connected to the wsrep provider. Possible values are
ON
orOFF
.
wsrep_flow_control_paused
- Description: Time since the most recent status query that was paused due to flow control
wsrep_flow_control_recv
- Description: Number of FC_PAUSE events received as well as sent since the most recent status query.
wsrep_flow_control_sent
- Description: Number of FC_PAUSE events sent since the most recent status query
wsrep_last_committed
- Description: Sequence number of the most recently committed transaction.
wsrep_local_bf_aborts
- Description: Total number of local transactions aborted by slave transactions while being executed
wsrep_local_cert_failures
- Description: Total number of local transactions that failed the certification test.
wsrep_local_commits
- Description: Total number of local transactions committed on the node.
wsrep_local_index
- Description: The node's index in the cluster. The index is zero-based.
wsrep_local_recv_queue
- Description: Current length of the receive queue, which is the number of writesets waiting to be applied.
wsrep_local_recv_queue_avg
- Description: Average length of the receive queue since the most recent status query. If this value is noticeably larger than zero, the node is likely to be overloaded, and cannot apply the writesets as quickly as they arrive, resulting in replication throttling.
wsrep_local_replays
- Description: Total number of transaction replays due to asymmetric lock granularity.
wsrep_local_send_queue
- Description: Current length of the send queue, which is the number of writesets waiting to be sent.
wsrep_local_send_queue_avg
- Description: Average length of the send queue since the most recent status query. If this value is noticeably larger than zero, there is most likely network throughput or replication throttling issues.
wsrep_local_state_uuid
- Description: The node's UUID state. If it matches the value in wsrep_cluster_state_uuid, the local and cluster nodes are in sync.
wsrep_protocol_version
- Description: The wsrep protocol version being used.
wsrep_provider_name
- Description: The name of the provider. The default is "Galera".
wsrep_provider_vendor
- Description: The vendor string.
wsrep_provider_version
- Description: The version number of the Galera wsrep provider
wsrep_ready
- Description: Whether or not the Galera wsrep provider is ready. Possible values are
ON
orOFF
wsrep_received
- Description: Total number of writesets received from other nodes.
wsrep_received_bytes
- Description: Total size in bytes of all writesets received from other nodes.
wsrep_replicated
- Description: Total number of writesets replicated to other nodes.
wsrep_replicated_bytes
- Description: Total size in bytes of all writesets replicated to other nodes.
wsrep_thread_count
- Description: Total number of wsrep (applier/rollbacker) threads.
- Introduced:
MariaDB Galera Cluster 5.5.38
MariaDB Galera Cluster 10.0.11
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.