Enable LZ4&Snappy for InnoDB and LZ4&Snappy&ZSTD for RocksDB

autopkgtest/smoke results:

autopkgtest [05:34:09]: test smoke: [-----------------------
+ which systemctl
+ /etc/init.d/mysql status
MariaDB is stopped..
+ echo Did not find systemctl and deamon was not running, starting it..
+ /etc/init.d/mysql start
Did not find systemctl and deamon was not running, starting it..
Starting MariaDB database server: mysqld.
+ mysql
+ mysql testdatabase
+ echo+  SELECT bar+1 FROM foo;
mysql --batch --skip-column-names --user=testuser --password=testpassword testdatabase
+ result=42
+ [ 42 != 42 ]
+ mysql --user=testuser --password=testpassword testdatabase
+ mysql
+ mysql
+ dpkg-architecture -qDEB_HOST_ARCH_BITS
+ [ 64 != 32 ]
+ grep -qE kLZ4(Compression)? supported: 1 /var/lib/mysql/#rocksdb/LOG
+ grep -qE kSnappy(Compression)? supported: 1 /var/lib/mysql/#rocksdb/LOG
+ grep -qE kZlib(Compression)? supported: 1 /var/lib/mysql/#rocksdb/LOG
+ grep -qE kZSTD(Compression)? supported: 1 /var/lib/mysql/#rocksdb/LOG
autopkgtest [05:34:10]: test smoke: -----------------------]
autopkgtest [05:34:10]: test smoke:  - - - - - - - - - - results - - - - - - - - - -
smoke                PASS