https://www.percona.com/blog/optimize-sst-in-percona-xtradb-cluster-with-zstd-compression/ Thu, 03 Feb 2022 20:47:32 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/optimize-sst-in-percona-xtradb-cluster-with-zstd-compression/#comment-10973526 Thu, 03 Feb 2022 20:47:32 +0000 https://www.percona.com/blog/?p=79994#comment-10973526 By 3% better you mean only that much faster right? Interesting, I wonder if you have tried low compression levels as well, since I saw some bad behavior when using zstd with level 4+ where it was much slower than level 1-2 while not actually giving smaller result files at all. Of course a lot depends on actual data, but often level of 1 already gives comparable compression ratio to gzip while being a lot lot faster.
When it comes to column compression (https://www.percona.com/doc/percona-server/LATEST/flexibility/compressed_columns.html), you may always file a feature request (https://www.percona.com/blog/2019/06/12/report-bugs-improvements-new-feature-requests-for-percona-products/).
I already did for page compression: https://bugs.mysql.com/bug.php?id=105962

]]> https://www.percona.com/blog/optimize-sst-in-percona-xtradb-cluster-with-zstd-compression/#comment-10973525 Thu, 03 Feb 2022 19:41:34 +0000 https://www.percona.com/blog/?p=79994#comment-10973525 i fond only 3% better compression using zstd vs gzip. but i mainly use it with dovecot where it is much faster than gzip to decompress the same data many times, and compression speed doesnt matter much. i would think using it for column compression would be good.

]]>