There might be a problem with fixing this in 10.2 as changing package dependencies in a stable version may create problems. In this case, let's compile/link/depend on ZStandard in 10.3.

Centos/RHEL 7 - there is an EPEL package for libzstd-devel: https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/

Lack of zstd support in MyRocks for MariaDB was called out in a recent blog post and I have also wished to use this library for InnoDB page compression, so I voted on this issue.

Please add zstd support!

I see that in the changelog for 10233 and 10324 this was added, and the linked commit mentions also that 10414 and 1055 corrected the makefile problem.

Quick test seems to show that zstd works in 10.4.14:

MariaDB [test2]> select   @@version, SP.sst_name, SP.compression_algo from   information_schema.rocksdb_sst_props SP,   information_schema.rocksdb_ddl D,   information_schema.rocksdb_index_file_map IFM where   D.table_schema='test2' and D.table_name='myrockst1' and   D.index_number= IFM.index_number and   IFM.sst_name=SP.sst_name;

+---------------------+------------+------------------+

| @@version           | sst_name   | compression_algo |

+---------------------+------------+------------------+

| 10.4.14-MariaDB-log | 000096.sst | ZSTD             |

+---------------------+------------+------------------+

1 row in set (0.001 sec)

Sadly this fix being for storage/rocksdb/build_rocksdb.cmake and the libzstd dependency coming with MariaDB-rocksdb-engine means that innodb_compression_algorithm was unaffected.

I suspect that the folks at MariaDB can now close this bug.

Thanks mg for confirming

MDEV-12933 is there to unify the provision of compression across engines