Sample Header Ad - 728x90

What compression should be used in MariaDB?

3 votes
1 answer
126 views
MariaDB offers multiple compression methods : bzip2, lz4, lzma, lzo and snappy. Why are there so many? Which one is recommended to use? Why isn't zstd and option? If one compression method is adopted with e.g. SET GLOBAL innodb_compression_algorithm = lz4; and it turns out some other method would be better, is there any way to migrate to another method in-place or does it require a full logical dump-and-restore cycle?
Asked by Otto (469 rep)
Jun 4, 2025, 11:16 AM
Last activity: Jun 10, 2025, 03:40 AM