columnstore_compression_type

In 10.6 ES:

Controls compression algorithm for create tables. Possible values are: NO_COMPRESSION segment files aren't compressed; SNAPPY segment files are Snappy compressed (default);LZ4 segment files are LZ4 compressed;

In 10.5 ES, 10.4 ES:

Controls compression algorithm for create tables. Possible values are: NO_COMPRESSION segment files aren't compressed; SNAPPY segment files are Snappy compressed (default);

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

USAGE

The columnstore_compression_type system variable can be set in a configuration file:

[mariadb]
columnstore_compression_type=LZ4

The global value of the columnstore_compression_type system variable can also be set dynamically at runtime by executing SET GLOBAL:

SET GLOBAL columnstore_compression_type='LZ4'

The session value of the columnstore_compression_type system variable can also be set dynamically at runtime by executing SET SESSION:

SET SESSION columnstore_compression_type='LZ4';

When the columnstore_compression_type system variable is set dynamically at runtime, its value will be reset the next time the server restarts. To make the value persist on restart, set it in a configuration file too.

DETAILS

The columnstore_compression_type system variable configures the compression algorithm used by new ColumnStore tables:

Value

Description

LZ4

LZ4 compression is used for new ColumnStore tables. LZ4 compression is supported in MariaDB Enterprise ColumnStore 6.

NO_COMPRESSION

New ColumnStore tables are not compressed. Compression is mandatory in MariaDB Enterprise ColumnStore 6, so NO_COMPRESSION is not supported in that version.

SNAPPY

Snappy compression is used for new ColumnStore tables. Snappy compression is the default in all versions of MariaDB Enterprise ColumnStore.

PARAMETERS

Dynamic

Yes

Scope

Global, Session

Data Type

ENUM (SNAPPY, SNAPPY, SNAPPY, LZ4)

Default Value

SNAPPY

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

Not present

AWS

HA (Primary/Replica)

10.5

Not present

AWS

Transactional Standalone

10.4

Not present

AWS

Transactional Standalone

10.5

Not present

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

SNAPPY

GCP

ColumnStore Multi

10.5

SNAPPY

GCP

Galera

10.4

Not present

GCP

Galera

10.5

Not present

GCP

HA (Primary/Replica)

10.4

Not present

GCP

HA (Primary/Replica)

10.5

Not present

GCP

HTAP

10.5

SNAPPY

GCP

Transactional Standalone

10.4

Not present

GCP

Transactional Standalone

10.5

Not present

GCP

Distributed Transactions

10.5

Not present

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Removed in MariaDB Enterprise Server 10.5.3-1.

  • Added in MariaDB Enterprise Server 10.5.4-2.

10.4 Enterprise

  • Added in MariaDB Enterprise Server 10.4.11-5.

EXTERNAL REFERENCES