This is a command-line option for the
mysqld commands (arg: Required).
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.2 ES, 10.2 CS: