column_compression_zlib_strategy

Overview

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS:

The strategy parameter is used to tune the compression algorithm. Use the value DEFAULT_STRATEGY for normal data, FILTERED for data produced by a filter (or predictor), HUFFMAN_ONLY to force Huffman encoding only (no string match), or RLE to limit match distances to one (run-length encoding). Filtered data consists mostly of small values with a somewhat random distribution. In this case, the compression algorithm is tuned to compress them better. The effect of FILTERED is to force more Huffman coding and less string matching; it is somewhat intermediate between DEFAULT_STRATEGY and HUFFMAN_ONLY. RLE is designed to be almost as fast as HUFFMAN_ONLY, but give better compression for PNG image data. The strategy parameter only affects the compression ratio but not the correctness of the compressed output even if it is not set appropriately. FIXED prevents the use of dynamic Huffman codes, allowing for a simpler decoder for special applications.

In 10.6 ES, 10.5 ES, 10.4 ES:

The strategy parameter is used to tune the compression algorithm. Use the value DEFAULT_STRATEGY for normal data, FILTERED for data produced by a filter (or predictor), HUFFMAN_ONLY to force Huffman encoding only (no string match), or RLE to limit match distances to one (run-length encoding). Filtered data consists mostly of small values with a somewhat random distribution. In this case, the compression algorithm is tuned to compress them better. The effect of FILTERED is to force more Huffman coding and less string matching; it is somewhat intermediate between DEFAULT_STRATEGY and HUFFMAN_ONLY. RLE is designed to be almost as fast as HUFFMAN_ONLY, but give better compression for PNG image data. The strategy parameter only affects the compression ratio but not the correctness of the compressed output even if it is not set appropriately. FIXED prevents the use of dynamic Huffman codes, allowing for a simpler decoder for special applications.

In 10.2 ES, 10.2 CS:

Not present

DETAILS

PARAMETERS

Command-line

--column_compression_zlib_strategy={DEFAULT_STRATEGY|FILTERED|HUFFMAN_ONLY|RLE|FIXED}

Configuration file

Supported

Dynamic

Yes

Scope

Global, Session

Data Type

ENUM (DEFAULT_STRATEGY, FILTERED, HUFFMAN_ONLY, RLE, FIXED)

Default Value

DEFAULT_STRATEGY

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

Multi-Node Analytics

10.6

DEFAULT_STRATEGY

Single Node Analytics

10.6

DEFAULT_STRATEGY

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

Single Node Transactions

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

GCP

Multi-Node Analytics

10.6

DEFAULT_STRATEGY

Single Node Analytics

10.6

DEFAULT_STRATEGY

Distributed Transactions

10.5

Not present

10.6

Not present

Replicated Transactions

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

Single Node Transactions

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

Cloud

SkySQL Topology

ES Ver

Default

AWS

ColumnStore Data Warehouse

10.6

DEFAULT_STRATEGY

Xpand Distributed SQL

10.5

Not present

10.6

Not present

Enterprise Server With Replica(s)

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

Enterprise Server Single Node

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

GCP

ColumnStore Data Warehouse

10.6

DEFAULT_STRATEGY

Xpand Distributed SQL

10.5

Not present

10.6

Not present

Enterprise Server With Replica(s)

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

Enterprise Server Single Node

10.4

DEFAULT_STRATEGY

10.5

DEFAULT_STRATEGY

10.6

DEFAULT_STRATEGY

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Added in MariaDB Community Server 10.3.2.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

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