This variable shows parallelization efficiency, how often writests have been applied out of order.
This variable shows how often a writeset with a higher sequence number was applied before one with a lower sequence number.
Average distance between highest and lowest concurrently applied sequence numbers.
Shows the number of writesets processed while the variable
wsrep_causal_reads was set to
This variable, implemented in
5.6.24-25.11, shows the number of cells in the certification index hash-table.
Average distance between highest and lowest sequence number that can be possibly applied in parallel.
Number of entries in the certification index.
Number of cluster membership changes that have taken place.
Current number of nodes in the cluster.
Primary- Node has a quorum,
Non-Primary- Node has lost a quorum (for example 2 out 4 nodes get partitioned and see each other but don’t have a quorum),
Disconnected- Node is unable to connect to other nodes/cluster.
This variable shows how often a transaction was committed out of order.
This variable currently has no meaning.
Average distance between highest and lowest concurrently committed sequence number.
This variable shows if the node is connected to the cluster. If the value is
OFF, the node has not yet connected to any of the cluster components. This may be due to misconfiguration.
Number of desync operations currently in progress on the node.
This status variable increments every time a node is desynced from the cluster
(for example, when
wsrep_desync is enabled).
The node can only sync to the cluster when the value is
meaning that there are no operations running on the node
that require the node to desync.
Comma separated list of nodes that are considered delayed. The node format is
<count> is the number of entries on delayed list for that node.
List of UUIDs of the evicted nodes.
This status variable provides information regarding group communication replication latency. This latency is measured in seconds from when a message is sent out to when a message is received.
The format of the output is
Internal EVS protocol state.
Time since the last status query that was paused due to flow control.
Total time spent in a paused state measured in nanoseconds.
FC_PAUSE events received since the last status query.
FC_PAUSE events sent since the last status query.
This variable, implemented in
5.6.24-25.11, shows the size of the page pool and dynamic memory allocated for GCache (in bytes).
This status variable exposes UUIDs in
gvwstate.dat, which are Galera view IDs (thus unrelated to cluster state UUIDs). This UUID is unique for each node. You will need to know this value when using manual eviction feature.
Shows the comma-separated list of incoming node addresses in the cluster.
Sequence number of the last committed transaction.
Number of local transactions that were aborted by slave transactions while being executed.
The lowest sequence number in GCache. This information can be helpful with determining IST and SST. If the value is
0, then it means there are no writesets in GCache (usual for a single node).
Number of writesets that failed the certification test.
Number of writesets commited on the node.
Node’s index in the cluster.
Current length of the receive queue (that is, the number of writesets waiting to be applied).
Average length of the receive queue since the last status query. When this number is bigger than
0 this means node can’t apply writesets as fast as they are received. This could be a sign that the node is overloaded and it may cause replication throttling.
Number of transaction replays due to asymmetric lock granularity.
Current length of the send queue (that is, the number of writesets waiting to be sent).
Average length of the send queue since the last status query. When cluster experiences network throughput issues or replication throttling, this value will be significantly bigger than
Internal number and the corresponding human-readable comment of the node’s state. Possible values are:
|1||Joining||Node is joining the cluster|
|2||Donor/Desynced||Node is the donor to the node joining the cluster|
|3||Joined||Node has joined the cluster|
|4||Synced||Node is synced with the cluster|
The UUID of the state stored on the node.
Version of the wsrep protocol used.
Name of the wsrep provider (usually
Name of the wsrep provider vendor (usually
Current version of the wsrep provider.
This variable shows if node is ready to accept queries. If status is
OFF, almost all queries will fail with
ERROR 1047 (08S01) Unknown Command error (unless the
wsrep_on variable is set to
Total number of writesets received from other nodes.
Total size (in bytes) of writesets received from other nodes.
Total size (in bytes) of data replicated.
Total number of keys replicated.
Total size (in bytes) of keys replicated.
Total size of other bits replicated.
Total number of writesets sent to other nodes.
Total size (in bytes) of writesets sent to other nodes.
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.