[MDEV-11838] Innodb-compression-algorithm default should be != none Created: 2017-01-19  Updated: 2017-01-19  Resolved: 2017-01-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 10.1
Fix Version/s: 10.1.22

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

This default change effects only if create table contains PAGE_COMPRESSED=YES table option and naturally in that case compression is desired. Default should be zlib.

 Comments   
Comment by Jan Lindström (Inactive) [ 2017-01-19 ]

http://lists.askmonty.org/pipermail/commits/2017-January/010467.html

Comment by Marko Mäkelä [ 2017-01-19 ]

Looks good.
Please add a test that uses CREATE TABLE…page_compression=1 without setting the algorithm.

Comment by Jan Lindström (Inactive) [ 2017-01-19 ]

commit 8a4d605500ae487d3dc515305662769645bb092f
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Thu Jan 19 12:20:54 2017 +0200

MDEV-11838: Innodb-compression-algorithm default should be != none

Change default to zlib, this has effect only if user has
explicitly requested page compression and then user
naturally expects that pages are really compressed
if they can be compressed.

Generated at Thu Feb 08 07:53:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.