Skip to content
logo
Percona XtraDB Cluster
Index of wsrep status variables
Initializing search
    percona/pxc-docs
    percona/pxc-docs
    • Home
      • About Percona XtraDB Cluster
      • Percona XtraDB Cluster limitations
      • Understand version numbers
      • Quick start guide for Percona XtraDB Cluster
      • Install Percona XtraDB Cluster
      • Configure nodes for write-set replication
      • Bootstrap the first node
      • Add nodes to cluster
      • Verify replication
      • High availability
      • PXC strict mode
      • Online schema upgrade
      • Non-Blocking Operations (NBO) method for Online Scheme Upgrades (OSU)
      • Security basics
      • Secure the network
      • Encrypt PXC traffic
      • Enable AppArmor
      • Enable SELinux
      • State snapshot transfer
      • Percona XtraBackup SST configuration
      • Restart the cluster nodes
      • Cluster failover
      • Monitor the cluster
      • Certification in Percona XtraDB Cluster
      • Percona XtraDB Cluster threading model
      • Understand GCache and Record-Set cache
      • GCache encryption and Write-Set cache encryption
      • Perfomance Schema instrumentation
      • Data at Rest Encryption
      • Upgrade Percona XtraDB Cluster
      • Crash recovery
      • Configure Percona XtraDB Cluster on CentOS
      • Configure Percona XtraDB Cluster on Ubuntu
      • Set up Galera arbitrator
      • How to set up a three-node cluster on a single box
      • How to set up a three-node cluster in EC2 environment
      • Load balancing with HAProxy
      • Load balancing with ProxySQL
      • ProxySQL admin utilities
      • Setting up a testing environment with ProxySQL
      • Release notes index
      • Percona XtraDB Cluster 8.0.31-23 (2023-03-14)
      • Percona XtraDB Cluster 8.0.30-22.md (2022-12-28)
      • Percona XtraDB Cluster 8.0.29-21 (2022-09-12)
      • Percona XtraDB Cluster 8.0.28-19.1 (2022-07-19)
      • Percona XtraDB Cluster 8.0.27-18.1
      • Percona XtraDB Cluster 8.0.26-16.1
      • Percona XtraDB Cluster 8.0.25-15.1
      • Percona XtraDB Cluster 8.0.23-14.1
      • Percona XtraDB Cluster 8.0.22-13.1
      • Percona XtraDB Cluster 8.0.21-12.1
      • Percona XtraDB Cluster 8.0.20-11
      • Percona XtraDB Cluster 8.0.20-11.3
      • Percona XtraDB Cluster 8.0.20-11.2
      • Percona XtraDB Cluster 8.0.19-10
      • Percona XtraDB Cluster 8.0.18-9.3
      • Index of wsrep status variables
        • wsrep_apply_oooe
        • wsrep_apply_oool
        • wsrep_apply_window
        • wsrep_causal_reads
        • wsrep_cert_bucket_count
        • 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_evs_delayed
        • wsrep_evs_evict_list
        • wsrep_evs_repl_latency
        • wsrep_evs_state
        • wsrep_flow_control_interval
        • wsrep_flow_control_interval_high
        • wsrep_flow_control_interval_low
        • wsrep_flow_control_paused
        • wsrep_flow_control_paused_ns
        • wsrep_flow_control_recv
        • wsrep_flow_control_sent
        • wsrep_flow_control_status
        • wsrep_gcache_pool_size
        • wsrep_gcomm_uuid
        • wsrep_incoming_addresses
        • wsrep_ist_receive_status
        • wsrep_ist_receive_seqno_end
        • wsrep_ist_receive_seqno_current
        • wsrep_ist_receive_seqno_start
        • wsrep_last_applied
        • 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_replays
        • wsrep_local_send_queue
        • wsrep_local_send_queue_avg
        • wsrep_local_state
        • wsrep_local_state_comment
        • wsrep_local_state_uuid
        • wsrep_monitor_status
        • wsrep_protocol_version
        • wsrep_provider_name
        • wsrep_provider_vendor
        • wsrep_provider_version
        • wsrep_ready
        • wsrep_received
        • wsrep_received_bytes
        • wsrep_repl_data_bytes
        • wsrep_repl_keys
        • wsrep_repl_keys_bytes
        • wsrep_repl_other_bytes
        • wsrep_replicated
        • wsrep_replicated_bytes
      • Index of wsrep system variables
      • Index of wsrep_provider options
      • Index of files created by PXC
      • Frequently asked questions
      • Glossary
      • Copyright and licensing information
      • Trademark policy

    • wsrep_apply_oooe
    • wsrep_apply_oool
    • wsrep_apply_window
    • wsrep_causal_reads
    • wsrep_cert_bucket_count
    • 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_evs_delayed
    • wsrep_evs_evict_list
    • wsrep_evs_repl_latency
    • wsrep_evs_state
    • wsrep_flow_control_interval
    • wsrep_flow_control_interval_high
    • wsrep_flow_control_interval_low
    • wsrep_flow_control_paused
    • wsrep_flow_control_paused_ns
    • wsrep_flow_control_recv
    • wsrep_flow_control_sent
    • wsrep_flow_control_status
    • wsrep_gcache_pool_size
    • wsrep_gcomm_uuid
    • wsrep_incoming_addresses
    • wsrep_ist_receive_status
    • wsrep_ist_receive_seqno_end
    • wsrep_ist_receive_seqno_current
    • wsrep_ist_receive_seqno_start
    • wsrep_last_applied
    • 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_replays
    • wsrep_local_send_queue
    • wsrep_local_send_queue_avg
    • wsrep_local_state
    • wsrep_local_state_comment
    • wsrep_local_state_uuid
    • wsrep_monitor_status
    • wsrep_protocol_version
    • wsrep_provider_name
    • wsrep_provider_vendor
    • wsrep_provider_version
    • wsrep_ready
    • wsrep_received
    • wsrep_received_bytes
    • wsrep_repl_data_bytes
    • wsrep_repl_keys
    • wsrep_repl_keys_bytes
    • wsrep_repl_other_bytes
    • wsrep_replicated
    • wsrep_replicated_bytes

    Index of wsrep status variables¶

    wsrep_apply_oooe¶

    This variable shows parallelization efficiency, how often writests have been applied out of order.

    See also

    Galera status variable: wsrep_apply_oooe

    wsrep_apply_oool¶

    This variable shows how often a writeset with a higher sequence number was applied before one with a lower sequence number.

    See also

    Galera status variable: wsrep_apply_oool

    wsrep_apply_window¶

    Average distance between highest and lowest concurrently applied sequence numbers.

    See also

    Galera status variable: wsrep_apply_window

    wsrep_causal_reads¶

    Shows the number of writesets processed while the variable wsrep_causal_reads was set to ON.

    See also

    MySQL wsrep options: wsrep_causal_reads

    wsrep_cert_bucket_count¶

    This variable, shows the number of cells in the certification index hash-table.

    wsrep_cert_deps_distance¶

    Average distance between highest and lowest sequence number that can be possibly applied in parallel.

    See also

    Galera status variable: wsrep_cert_deps_distance

    wsrep_cert_index_size¶

    Number of entries in the certification index.

    See also

    Galera status variable: wsrep_cert_index_size

    wsrep_cert_interval¶

    Average number of write-sets received while a transaction replicates.

    See also

    Galera status variable: wsrep_cert_interval

    wsrep_cluster_conf_id¶

    Number of cluster membership changes that have taken place.

    See also

    Galera status variable: wsrep_cluster_conf_id

    wsrep_cluster_size¶

    Current number of nodes in the cluster.

    See also

    Galera status variable: wsrep_cluster_size

    wsrep_cluster_state_uuid¶

    This variable contains UUID state of the cluster. When this value is the same as the one in wsrep_local_state_uuid, node is synced with the cluster.

    See also

    Galera status variable: wsrep_cluster_state_uuid

    wsrep_cluster_status¶

    Status of the cluster component. Possible values are:

    • Primary

    • Non-Primary

    • Disconnected

    See also

    Galera status variable: wsrep_cluster_status

    wsrep_commit_oooe¶

    This variable shows how often a transaction was committed out of order.

    See also

    Galera status variable: wsrep_commit_oooe

    wsrep_commit_oool¶

    This variable currently has no meaning.

    See also

    Galera status variable: wsrep_commit_oool

    wsrep_commit_window¶

    Average distance between highest and lowest concurrently committed sequence number.

    See also

    Galera status variable: wsrep_commit_window

    wsrep_connected¶

    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.

    See also

    Galera status variable: wsrep_connected

    wsrep_evs_delayed¶

    Comma separated list of nodes that are considered delayed. The node format is <uuid>:<address>:<count>, where <count> is the number of entries on delayed list for that node.

    See also

    Galera status variable: wsrep_evs_delayed

    wsrep_evs_evict_list¶

    List of UUIDs of the evicted nodes.

    See also

    Galera status variable: wsrep_evs_evict_list

    wsrep_evs_repl_latency¶

    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 <min>/<avg>/<max>/<std_dev>/<sample_size>.

    See also

    Galera status variable: wsrep_evs_repl_latency

    wsrep_evs_state¶

    Internal EVS protocol state.

    See also

    Galera status variable: wsrep_evs_state

    wsrep_flow_control_interval¶

    This variable shows the lower and upper limits for Galera flow control. The upper limit is the maximum allowed number of requests in the queue. If the queue reaches the upper limit, new requests are denied. As existing requests get processed, the queue decreases, and once it reaches the lower limit, new requests will be allowed again.

    wsrep_flow_control_interval_high¶

    Shows the upper limit for flow control to trigger.

    wsrep_flow_control_interval_low¶

    Shows the lower limit for flow control to stop.

    wsrep_flow_control_paused¶

    Time since the last status query that was paused due to flow control.

    See also

    Galera status variable: wsrep_flow_control_paused

    wsrep_flow_control_paused_ns¶

    Total time spent in a paused state measured in nanoseconds.

    See also

    Galera status variable: wsrep_flow_control_paused_ns

    wsrep_flow_control_recv¶

    The number of FC_PAUSE events received since the last status query. Unlike most status variables, this counter does not reset each time you run the query. This counter is reset when the server restarts.

    See also

    Galera status variable: wsrep_flow_control_recv

    wsrep_flow_control_sent¶

    The number of FC_PAUSE events sent since the last status query. Unlike most status variables, this counter does not reset each time you run the query. This counter is reset when the server restarts.

    See also

    Galera status variable: wsrep_flow_control_sent

    wsrep_flow_control_status¶

    This variable shows whether a node has flow control enabled for normal traffic. It does not indicate the status of flow control during SST.

    wsrep_gcache_pool_size¶

    This variable shows the size of the page pool and dynamic memory allocated for GCache (in bytes).

    wsrep_gcomm_uuid¶

    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.

    See also

    Galera status variable: wsrep_gcomm_uuid

    wsrep_incoming_addresses¶

    Shows the comma-separated list of incoming node addresses in the cluster.

    See also

    Galera status variable: wsrep_incoming_addresses

    wsrep_ist_receive_status¶

    This variable displays the progress of IST for joiner node. If IST is not running, the value is blank. If IST is running, the value is the percentage of transfer completed.

    wsrep_ist_receive_seqno_end¶

    The sequence number of the last transaction in IST.

    wsrep_ist_receive_seqno_current¶

    The sequence number of the current transaction in IST.

    wsrep_ist_receive_seqno_start¶

    The sequence number of the first transaction in IST.

    wsrep_last_applied¶

    Sequence number of the last applied transaction.

    wsrep_last_committed¶

    Sequence number of the last committed transaction.

    wsrep_local_bf_aborts¶

    Number of local transactions that were aborted by replica transactions while being executed.

    See also

    Galera status variable: wsrep_local_bf_aborts

    wsrep_local_cached_downto¶

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

    See also

    Galera status variable: wsrep_local_cached_downto

    wsrep_local_cert_failures¶

    Number of writesets that failed the certification test.

    See also

    Galera status variable: wsrep_local_cert_failures

    wsrep_local_commits¶

    Number of writesets commited on the node.

    See also

    Galera status variable: wsrep_local_commits

    wsrep_local_index¶

    Node’s index in the cluster.

    See also

    Galera status variable: wsrep_local_index

    wsrep_local_recv_queue¶

    Current length of the receive queue (that is, the number of writesets waiting to be applied).

    See also

    Galera status variable: wsrep_local_recv_queue

    wsrep_local_recv_queue_avg¶

    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.

    See also

    Galera status variable: wsrep_local_recv_queue_avg

    wsrep_local_replays¶

    Number of transaction replays due to asymmetric lock granularity.

    See also

    Galera status variable: wsrep_local_replays

    wsrep_local_send_queue¶

    Current length of the send queue (that is, the number of writesets waiting to be sent).

    See also

    Galera status variable: wsrep_local_send_queue

    wsrep_local_send_queue_avg¶

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

    See also

    Galera status variable: wsrep_local_send_queue_avg

    wsrep_local_state¶

    Internal Galera cluster FSM state number.

    See also

    Galera status variable: wsrep_local_state

    wsrep_local_state_comment¶

    Internal number and the corresponding human-readable comment of the node’s state. Possible values are:

    Num Comment Description
    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

    See also

    Galera status variable: wsrep_local_state_comment

    wsrep_local_state_uuid¶

    The UUID of the state stored on the node.

    See also

    Galera status variable: wsrep_local_state_uuid

    wsrep_monitor_status¶

    The status of the local monitor (local and replicating actions), apply monitor (apply actions of write-set), and commit monitor (commit actions of write sets). In the value of this variable, each monitor (L: Local, A: Apply, C: Commit) is represented as a last_entered, and last_left pair:

    wsrep_monitor_status (L/A/C)    [ ( 7, 5), (2, 2), ( 2, 2) ]
    

    last_entered

    Shows which transaction or write-set has recently entered the queue.

    last_left

    Shows which last transaction or write-set has been executed and left the queue.

    According to the Galera protocol, transactions can be applied in parallel but must be committed in a given order. This rule implies that there can be multiple transactions in the apply state at a given point of time but transactions are committed sequentially.

    See also

    Galera Documentation: Database replication

    wsrep_protocol_version¶

    Version of the wsrep protocol used.

    See also

    Galera status variable: wsrep_protocol_version

    wsrep_provider_name¶

    Name of the wsrep provider (usually Galera).

    See also

    Galera status variable: wsrep_provider_name

    wsrep_provider_vendor¶

    Name of the wsrep provider vendor (usually Codership Oy)

    See also

    Galera status variable: wsrep_provider_vendor

    wsrep_provider_version¶

    Current version of the wsrep provider.

    See also

    Galera status variable: wsrep_provider_version

    wsrep_ready¶

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

    See also

    Galera status variable: wsrep_ready

    wsrep_received¶

    Total number of writesets received from other nodes.

    See also

    Galera status variable: wsrep_received

    wsrep_received_bytes¶

    Total size (in bytes) of writesets received from other nodes.

    wsrep_repl_data_bytes¶

    Total size (in bytes) of data replicated.

    wsrep_repl_keys¶

    Total number of keys replicated.

    wsrep_repl_keys_bytes¶

    Total size (in bytes) of keys replicated.

    wsrep_repl_other_bytes¶

    Total size of other bits replicated.

    wsrep_replicated¶

    Total number of writesets sent to other nodes.

    See also

    Galera status variable: wsrep_replicated

    wsrep_replicated_bytes¶

    Total size of replicated writesets. To compute the actual size of bytes sent over network to cluster peers, multiply the value of this variable by the number of cluster peers in the given network segment.

    See also

    Galera status variable: wsrep_replicated_bytes

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2023-01-20
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.