columnstore_compression_type

Overview

In 23.08 ES, 23.07 ES, 10.6 ES, 10.6 CS:

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

In 23.08 ES, 23.07 ES, 10.6 ES:

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

In 10.5 ES, 10.5 CS, 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);

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);

In 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:

Not present

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.

SYNONYMS

SCHEMA

PARAMETERS

Command-line

--columnstore_compression_type={SNAPPY|SNAPPY|SNAPPY|LZ4}

Configuration file

Supported

Dynamic

Yes

Scope

Global, Session

Data Type

ENUM (SNAPPY, SNAPPY, SNAPPY, LZ4)

Product Default Value

SNAPPY

SKYSQL

Cloud

SkySQL Topology

ES Ver

Service Default

AWS

Multi-Node Analytics

10.6

LZ4

Single Node Analytics

10.6

LZ4

Replicated Transactions

10.4

Not present

10.5

Not present

10.6

Not present

Single Node Transactions

10.4

Not present

10.5

Not present

10.6

Not present

GCP

Multi-Node Analytics

10.6

LZ4

Single Node Analytics

10.6

LZ4

Replicated Transactions

10.4

Not present

10.5

Not present

10.6

Not present

Single Node Transactions

10.4

Not present

10.5

Not present

10.6

Not present

Cloud

SkySQL Topology

ES Ver

Service Default

AWS

ColumnStore Data Warehouse

10.6

LZ4

Enterprise Server With Replica(s)

10.4

Not present

10.5

Not present

10.6

Not present

Enterprise Server Single Node

10.4

Not present

10.5

Not present

10.6

Not present

GCP

ColumnStore Data Warehouse

10.6

LZ4

Enterprise Server With Replica(s)

10.4

Not present

10.5

Not present

10.6

Not present

Enterprise Server Single Node

10.4

Not present

10.5

Not present

10.6

Not present

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Removed in MariaDB Community Server 10.6.0.

  • Added in MariaDB Community Server 10.6.1.

10.5 Enterprise

  • Removed in MariaDB Enterprise Server 10.5.3-1.

  • Added in MariaDB Enterprise Server 10.5.4-2.

10.5 Community

  • Added in MariaDB Community Server 10.5.4.

10.4 Enterprise

  • Added in MariaDB Enterprise Server 10.4.11-5.

  • Removed in MariaDB Enterprise Server 10.4.24-15.

10.4 Community

  • Not present.

10.3 Enterprise

  • Not present.

10.3 Community

  • Not present.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

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.

  • Removed in MariaDB Enterprise Server 10.4.24-15.

EXTERNAL REFERENCES