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