Reference for MariaDB Galera Cluster status variables exposed via SHOW STATUS LIKE 'wsrep%', covering applier threads, certification, flow control, replication queues, and node state.
Viewing Galera Cluster Status Variables
Galera status variables can be viewed with the statement.
SHOW STATUS LIKE 'wsrep%';
See also the .
List of Galera Cluster status variables
MariaDB Galera Cluster has the following status variables:
wsrep_applier_thread_count
Description: Stores the current number of applier threads to make clear how many slave threads of this type there are.
wsrep_apply_oooe
Description: How often write sets have been applied out of order, an indicator of parallelization efficiency.
wsrep_apply_oool
Description: How often write sets with a higher sequence number were applied before ones with a lower sequence number, implying slow write sets.
wsrep_apply_waits
Description: Number of times the applier had to wait for an earlier transaction (lower seqno) to be applied before it could apply the next write set.
wsrep_apply_window
Description: Average distance between highest and lowest concurrently applied seqno.
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_cert_index_size
Description: The number of entries in the certification index.
wsrep_cert_interval
Description: Average number of transactions received while a transaction replicates.
wsrep_cluster_capabilities
Description:
wsrep_cluster_conf_id
Description: Total number of cluster membership changes that have taken place.
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 , the local and cluster nodes are in sync.
wsrep_cluster_status
Description: Cluster component status. Possible values are PRIMARY (primary group configuration, quorum present), NON_PRIMARY (non-primary group configuration, quorum lost), or DISCONNECTED (not connected to group, retrying).
wsrep_cluster_weight
Description: The total weight of the current members in the cluster. The value is counted as a sum of pc.weight of the nodes in the current primary component.
wsrep_commit_oooe
Description: How often a transaction was committed out of order.
wsrep_commit_oool
Description: No meaning.
wsrep_commit_window
Description: Average distance between highest and lowest concurrently committed seqno.
wsrep_connected
Description: Whether or not MariaDB is connected to the wsrep provider. Possible values are ON or OFF.
wsrep_desync_count
Description: Returns the number of operations in progress that require the node to temporarily desync from the cluster.
wsrep_evs_delayed
Description: Provides a comma separated list of all the nodes this node has registered on its delayed list.
wsrep_evs_evict_list
Description: Lists the UUID’s of all nodes evicted from the cluster. Evicted nodes cannot rejoin the cluster until you restart their mysqld processes.
wsrep_evs_repl_latency
Description: This status variable provides figures for the replication latency on group communication. It measures latency (in seconds) from the time point when a message is sent out to the time point when a message is received. As replication is a group operation, this essentially gives you the slowest ACK and longest RTT in the cluster. The format is min/avg/​max/stddev
wsrep_evs_state
Description: Shows the internal state of the EVS protocol.
wsrep_flow_control_paused
Description: The fraction of time since the last FLUSH STATUS command that replication was paused due to flow control.
wsrep_flow_control_paused_ns
Description: The total time spent in a paused state measured in nanoseconds.
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_gcomm_uuid
Description: The UUID assigned to the node.
wsrep_incoming_addresses
Description: Comma-separated list of incoming server addresses in the cluster component.
wsrep_last_committed
Description: Sequence number of the most recently committed transaction.
wsrep_local_bf_aborts
Description: Total number of high-priority local transactions aborts caused by replication applier threads.
wsrep_local_cached_downto
Description: The lowest sequence number, or seqno, in the write-set cache (GCache).
wsrep_local_cert_failures
Description: Total number of local transactions that failed the certification test and consequently issued a voluntary rollback.
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 write sets 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 write sets as quickly as they arrive, resulting in replication throttling.
wsrep_local_recv_queue_max
Description: The maximum length of the recv queue since the last FLUSH STATUS command.
wsrep_local_recv_queue_min
Description: The minimum length of the recv queue since the last FLUSH STATUS command.
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 write sets 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 are most likely network throughput or replication throttling issues.
wsrep_local_send_queue_max
Description: The maximum length of the send queue since the last FLUSH STATUS command.
wsrep_local_send_queue_min
Description: The minimum length of the send queue since the last FLUSH STATUS command.
wsrep_local_state
Description: Internal Galera Cluster FSM state number.
wsrep_local_state_comment
Description: Human-readable explanation of the state.
wsrep_local_state_uuid
Description: The node's UUID state. If it matches the value in , the local and cluster nodes are in sync.
wsrep_open_connections
Description: The number of open connection objects inside the wsrep provider.
wsrep_open_transactions
Description: The number of locally running transactions that have been registered inside the wsrep provider. This means transactions that have made operations that have caused write set population to happen. Transactions that are read-only are not counted.
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 or OFF
wsrep_received
Description: Total number of write sets received from other nodes.
wsrep_received_bytes
Description: Total size in bytes of all write sets received from other nodes.
wsrep_repl_data_bytes
Description: Total size of data replicated.
wsrep_repl_keys
Description: Total number of keys replicated.
wsrep_repl_keys_bytes
Description: Total size of keys replicated.
wsrep_repl_other_bytes
Description: Total size of other bits replicated.
wsrep_replicated
Description: Total number of write sets replicated to other nodes.
wsrep_replicated_bytes
Description: Total size in bytes of all write sets replicated to other nodes.
wsrep_rollbacker_thread_count
Description: Stores the current number of rollbacker threads to make clear how many slave threads of this type there are.
wsrep_thread_count
Description: Total number of wsrep (applier/rollbacker) threads.