Site icon Database Tutorials

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

Option Description
zlib Pages are compressed with bundled zlib compression method.
lz4 Extremely fast compression lz4 is lossless compression algorithm, providing compression speed at 400MB/s per core.
lzo Portable loseless data compression . Offers pretty fast compression and *extremely* fast decompression.
lzma Is a general compression Method of 7z format in the 7-Zip program.
bzip2 It is high-quality compressor. It will compress files upto 10% to 15% of the best available techniques.
snappy Snappy 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 :

Exit mobile version