[MDEV-22533] Documentation for Column Compression Created: 2020-05-12  Updated: 2020-05-22  Resolved: 2020-05-22

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Documentation - Support, Server
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Nuno Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

A few things:

1) The Command Line for this entry is incorrect:
https://mariadb.com/kb/en/storage-engine-independent-column-compression/

{{column_compression_zlib_level
Commandline: --column-compression-threshold=#}}

Needs to say "zlib-level" (I suppose).

2) Could it be added to the documentation of that page, or at least clarified here,
whether does it make sense to do Column-level Compression, if PAGE_COMPRESSED=1 on that Table?

Meaning, use "PAGE_COMPRESSED=1" and "COMPRESSED" on a blob column, at the same time on the same table, does that make sense, or would PAGE_COMPRESSED=1 be enough?

3) A big advantage of using PAGE_COMPRESSED is that the compressed data won't be cached in the buffer pool. What's the case for Column COMPRESSED?
(would be nice to have that in the documentation too)

Thank you very much.



 Comments   
Comment by Ian Gilfillan [ 2020-05-22 ]

https://mariadb.com/kb/en/storage-engine-independent-column-compression/#comparison-with-innodb-page-compression should answer your questions.

Regarding 3), the compression is independent of the storage engine (and hence the InnoDB buffer pool), so treated as a regular blob, for example.

Comment by Nuno [ 2020-05-22 ]

Thank you. Absolutely great.
Have a great day.

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