alter_algorithm

Configures the server to use specific algorithms for ALTER TABLE operations.

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

DETAILS

This system variable can configure the server to use specific algorithms for ALTER TABLE operations:

Alter Algorithm

Description

DEFAULT

In this mode, the server uses the most efficient algorithm for a given operation.

COPY

In this mode, the server will only use the COPY algorithm for any operation. This algorithm is very slow and inefficient, so it is not generally desirable to set this value.

INPLACE

In this mode, the server will only use the INPLACE, NOCOPY, or INSTANT algorithms. Operations that only support the COPY algorithm will be rejected.

NOCOPY

In this mode, the server will only use the NOCOPY or INSTANT algorithms. Operations that only support the COPY or INPLACE algorithms will be rejected.

INSTANT

In this mode, the server will only use the INSTANT algorithm. Operations that only support the COPY, INPLACE, or NOCOPY algorithms will be rejected.

PARAMETERS

Dynamic

Yes

Scope

Global, Session

Data Type

ENUM (DEFAULT, COPY, INPLACE, NOCOPY, INSTANT)

Default Value

DEFAULT

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

DEFAULT

AWS

HA (Primary/Replica)

10.5

DEFAULT

AWS

Transactional Standalone

10.4

DEFAULT

AWS

Transactional Standalone

10.5

DEFAULT

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

DEFAULT

GCP

ColumnStore Multi

10.5

DEFAULT

GCP

Galera

10.4

DEFAULT

GCP

Galera

10.5

DEFAULT

GCP

HA (Primary/Replica)

10.4

DEFAULT

GCP

HA (Primary/Replica)

10.5

DEFAULT

GCP

HTAP

10.5

DEFAULT

GCP

Transactional Standalone

10.4

DEFAULT

GCP

Transactional Standalone

10.5

DEFAULT

GCP

Distributed Transactions

10.5

Not present

PRIVILEGES

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

The alter_algorithm 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