MySQL Bugs: #105962: Add zstd as supported algorithm for InnoDB Page Compression

Bug #105962	Add zstd as supported algorithm for InnoDB Page Compression
Submitted:	22 Dec 2021 20:35	Modified:	23 Dec 2021 5:01
Reporter:	Przemyslaw Malkowski	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	compression algorithms, zstd

Description:
Currently, only Zlib and LZ4 algorithms are available for https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html.

Zstd compression is already widely used in various aspects of MySQL Server and tools.

As it provides a greatly superior compression rate and speed compared to Zlib and LZ4, I wonder why it wasn't enabled for page compression yet. I think it would be a great improvement.

How to repeat:
mysql > alter table sbtest2 COMPRESSION="zstd";
ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'COMPRESSION'

mysql > alter table sbtest2 COMPRESSION="lz4";
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Suggested fix:
Add zstd to the list of supported compression algorithms in Transparent Page Compression.

Hello Przemyslaw,

Thank you for the feature request.

regards,
Umesh

Can you please give an update about the progress of this issue.

We would love to use 'zstd' for compressing InnoDB pages.