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_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 wsrep_local_state_uuid, 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_connected

  • Description: Whether or not MariaDB is connected to the wsrep provider. Possible values are ON or OFF.

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_gcomm_uuid

  • Description: The UUID assigned to the node.

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 or OFF

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...