columnstore_compression_type
This page is part of MariaDB's Documentation.
The parent of this page is: System Variables for MariaDB Enterprise Server
Topics on this page:
Overview
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 compression is used for new ColumnStore tables. LZ4 compression is supported in MariaDB Enterprise ColumnStore 6. |
| New ColumnStore tables are not compressed. Compression is mandatory in MariaDB Enterprise ColumnStore 6, so |
| Snappy compression is used for new ColumnStore tables. Snappy compression is the default in all versions of MariaDB Enterprise ColumnStore. |
PARAMETERS
Command-line | --columnstore_compression_type={SNAPPY| |
Configuration file | Supported |
Dynamic | Yes |
Scope | Global, Session |
Data Type | ENUM (SNAPPY, SNAPPY, SNAPPY, LZ4) |
Product Default Value | SNAPPY |