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
|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 .
create table_1 (column_name data_type compressed=<type>)
example : create emp (name TEXT compressed=zlib)