tx_isolation

Default transaction isolation level

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

USAGE

The tx_isolation system variable can have its default value configured via the tx_isolation option in SkySQL Configuration Manager.

DETAILS

The tx_isolation system variable displays the current transaction isolation in different contexts:

  • The global value displays the transaction isolation for new connections.

  • The session value displays the transaction isolation for the current connection.

  • The value can also refer to the transaction isolation of the next transaction in a special context. After the next transaction completes, the transaction isolation is reset to the session value.

PARAMETERS

Dynamic

Yes

Scope

Global, Session

Data Type

ENUM (READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

Default Value

REPEATABLE-READ

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

AWS

HA (Primary/Replica)

10.5

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

AWS

Transactional Standalone

10.4

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

AWS

Transactional Standalone

10.5

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

AWS

Distributed Transactions

10.5

REPEATABLE-READ (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

ColumnStore

10.5

REPEATABLE-READ (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

ColumnStore Multi

10.5

REPEATABLE-READ (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

Galera

10.4

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

Galera

10.5

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

HA (Primary/Replica)

10.4

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

HA (Primary/Replica)

10.5

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

HTAP

10.5

REPEATABLE-READ (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

Transactional Standalone

10.4

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

Transactional Standalone

10.5

READ-COMMITTED (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

GCP

Distributed Transactions

10.5

REPEATABLE-READ (choices: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE)

PRIVILEGES

The tx_isolation system variable requires the SUPER privilege to dynamically set its global value at runtime.

The tx_isolation system variable does not require any special privilege to dynamically set its session value at runtime.

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES