wsrep_sync_wait

Overview

Bitmask to configure synchronization waits for causality checks on the cluster.

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS

DETAILS

Cluster Nodes can perform causality checks in response to certain types of SQL statements.

When an SQL statement triggers a causality check, the node waits for synchronization before executing the query. During synchronization, the node applies any outstanding write-sets from the cluster up to the point where it received the statement. It then executes the statement and returns the result-set.

Enabling causality checks ensures that certain types of queries always execute against the most up to date database state, at the expense of query performance.

This system variable specifies the types of statements that trigger causality checks:

Bitmask

Statement Type

Description

0

None

Disables causality checks.

1

  • Read

Performs causality checks for read operations, such as SELECT and BEGIN statements.

2

  • Update

Performs causality checks on update operations, such as UPDATE and DELETE statements.

3

  • Read

  • Update

Performs causality checks on read and update operations, such as SELECT, UPDATE, and DELETE statements.

4

  • Insert

Performs causality checks on insert operations, such as INSERT and REPLACE statements.

5

  • Read

  • Insert

Performs causality checks on read and insert operations, such as SELECT, INSERT, and UPDATE statements.

6

  • Update

  • Insert

Performs causality checks on update and insert operations, such as UPDATE, DELETE, INSERT, and REPLACE statements.

7

  • Read

  • Update

  • Insert

Performs causality checks on read, update, and insert operations, such as SELECT, UPDATE, DELETE, INSERT, and REPLACE statements.

8

  • Show

Performs causality checks on show operations, such as SHOW TABLES statements.

9

  • Read

  • Show

Performs causality checks on read and show operations, such as SELECT and SHOW TABLES statements.

10

  • Update

  • Show

Performs causality checks on update and show operations, such as UPDATE, DELETE SHOW TABLES statements.

11

  • Read

  • Update

  • Show

Performs causality checks on read, update, and show operations, such as SELECT, UPDATE, DELETE, and SHOW TABLES statements.

12

  • Show

  • Insert

Performs causality checks on insert and show operations, such as INSERT, REPLACE, and SHOW TABLES statements.

13

  • Read

  • Insert

  • Show

Performs causality checks on read, insert, and show operations, such as SELECT, INSERT, REPLACE, and SHOW TABLES statements.

14

  • Update

  • Insert

  • Show

Performs causality checks on update, insert, and show operations, such as UPDATE, DELETE, INSERT, REPLACE, and SHOW TABLES statements.

15

  • Read

  • Update

  • Insert

  • Show

Performs causality checks on show operations, such as SELECT, UPDATE, DELETE, INSERT, REPLACE, and SHOW TABLES statements.

PARAMETERS

Command-line

--wsrep_sync_wait[=#]

Configuration file

Supported

Dynamic

Yes

Scope

Global, Session

Data Type

INT UNSIGNED

Minimum Value

0

Maximum Value

15

Default Value

0

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

  • Maximum value changed in MariaDB Community Server 10.3.2 from 7 to 15

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

  • Maximum value changed in MariaDB Community Server 10.2.9 from 7 to 15

EXTERNAL REFERENCES