wsrep_sync_wait
INFO
Rule IDs: pxc_007
Overview
- Purpose
- Galera Cluster / Percona XtraDB Cluster:
wsrep_*names usually refer to status or wsrep-related configuration documented for MariaDB Galera Cluster or Percona XtraDB Cluster, not standard standalone MySQL 8.4 dynamic variables in the Oracle reference. - Dynamic (MySQL 8.4 reference)
- Consult MariaDB Galera and Percona XtraDB Cluster documentation for the exact item (status vs
SET/wsrep_provider_options). - Default value
- See cluster vendor docs.
- Version and product notes
- Not covered by the MySQL 8.4 server variable summary table shipped in
scripts/data/. - Documentation
- Primary reference depends on product (MySQL, MariaDB, Percona, or OS documentation).
- Vendor documentation
What is checked
Rules that reference this variable, with their severity and what each rule detects:
- INFO
pxc_007: Set wsrep_sync_wait globally to 0. Use SET SESSION wsrep_sync_wait=... only for queries that require strict consistency.
Tuning guidance
- Recommended actions:
- Set wsrep_sync_wait globally to 0. Use SET SESSION wsrep_sync_wait=... only for queries that require strict consistency.
- Trade-offs: Galera cluster settings affect write throughput, consistency, and failover behavior. Flow control protects slow nodes but can stall the entire cluster. SST method choice affects donor impact during node joins.
Example
Follow Percona / MariaDB cluster administration guides.