Bug #108604 Suggest to use zstd for innodb page compression
Submitted: 24 Sep 2022 10:00 Modified: 26 Sep 2022 11:59
Reporter: dennis GAO (OCA) 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

[24 Sep 2022 10:00] dennis GAO 
Description:
Currently innodb page compression only support zlib and lz4, while the zstd algorithm may provide similar(or little better)  compress ratio and much better speed for both compression and decompression.

And for zstd, mysql 8.0 has already used this algorithm for binlog compression, it could be safe to use zstd for page compression.

The zstd-1.5.0 has already been placed in the mysql source folder "extra/zstd" , so it is easy to enable page compression to use zstd algorithm.

The attached patch is a suggestion implementation.

How to repeat:
none

Suggested fix:
allow innodb page compression to use zstd algorithm
[24 Sep 2022 10:02] dennis GAO 
adding the patch as contribution

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: compress_zstd.diff (text/x-patch), 8.01 KiB.
[26 Sep 2022 11:59] MySQL Verification Team 
Hi Mr. GAO,

Thank you for your bug report.

However, this is not a bug report, but a feature request.

Also, thanks a lot for your contribution.

This is now a verified feature request.