Status: Open (View Workflow)
Fix Version/s: None
Server support zlib library for compression.
Facebook zstd (open-source dual BSD and GPLv2 license) argue to have better compression and decompression speed for better ratio.
Compression_algorithm : The name of the compression algorithm in use for the current connection to the server
Compression_level: The compression level in use for the current connection to the server
protocol_compression_algorithms: List the compression algorithms that the server permits for incoming connections.
New capability CLIENT_ZSTD_COMPRESSION_ALGORITHM (1UL << 26) indicate supporting zstd algorithm. (enable when global variable protocol-compression-algorithms contains zstd).
Handshake Response Packet has a new "compress_level" value
No dictionnary is used in MySQL implementation, but dictionary with zstd benchmarks generally improve encryption/decryption time drastically for small amount of data. Some verification might be done to see if that this can be applicable to MariaDB exchanges