Monday , May 20 2024

MariaDB Column Compression 10.3


MariaDB support different type of compression before 10.3.x .
Most of them need external packages (lz4,lzo,lzma,bzip2,snappy) to be installed before using them .
Default compression in zlib

zlibPages are compressed with bundled zlib compression method.
lz4Extremely fast compression lz4 is lossless compression algorithm, providing compression speed at 400MB/s per core.
lzoPortable loseless data compression . Offers pretty fast compression and *extremely* fast decompression.
lzmaIs a general compression Method of 7z format in the 7-Zip program.
bzip2It is high-quality compressor. It will compress files upto 10% to 15% of the best available techniques.
snappySnappy does not for maximum compression .It is aimed for very high speeds and reasonable compression .

Column compression was introduced in 10.3.2.
It allows you to compress data based on dataype instead of complete table .


syntax :


About Pavithra Kumar

Leave a Reply

Your email address will not be published. Required fields are marked *