[MDEV-20670] Add status variable that lists supported page compression algorithms Created: 2019-09-25  Updated: 2019-09-26  Resolved: 2019-09-26

Status: Closed
Project: MariaDB Server
Component/s: Configuration, Storage Engine - InnoDB
Affects Version/s: 10.2.27, 10.1.41, 10.3.18, 10.4.8
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Marko Mäkelä
Resolution: Not a Bug Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-20672 Usage message for innodb_compression_... Closed
relates to MDEV-18586 Clarify benefits of compression metho... Closed

 Description   

InnoDB page compression is a bit awkward, because it supports a bunch of different page compression algorithms, but every build doesn't support every compression algorithm.

There is not really a great way to check which page compression algorithms a specific build supports.

https://mariadb.com/kb/en/library/compression/#checking-which-page-compression-algorithms-are-supported

Maybe we should add a status variable that contains a list of supported page compression algorithms?



 Comments   
Comment by Geoff Montee (Inactive) [ 2019-09-26 ]

There are actually already individual status variables for each compression algorithm:

SHOW GLOBAL STATUS WHERE Variable_name IN ('Innodb_have_lz4', 'Innodb_have_lzo', 'Innodb_have_lzma', 'Innodb_have_bzip2', 'Innodb_have_snappy');
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| Innodb_have_lz4    | OFF   |
| Innodb_have_lzo    | OFF   |
| Innodb_have_lzma   | ON    |
| Innodb_have_bzip2  | OFF   |
| Innodb_have_snappy | OFF   |
+--------------------+-------+
5 rows in set (0.001 sec)

Generated at Thu Feb 08 09:01:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.