[MDEV-13947] Got lots of Compression failed for space: xxxx Created: 2017-09-29  Updated: 2017-10-02  Resolved: 2017-10-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Michael Xu Assignee: Jan Lindström (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

CentOS 7.x x86_64



 Description   

2017-09-29  9:05:29 140321115916032 [Warning] InnoDB: Compression failed for space: 2390 name: mydb/t1 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-09-29  9:05:30 140321132701440 [Warning] InnoDB: Compression failed for space: 2372 name: mydb/t2 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-09-29  9:05:31 140321124308736 [Warning] InnoDB: Compression failed for space: 2382 name: mydb/t3 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-09-29  9:05:37 140321090737920 [Warning] InnoDB: Compression failed for space: 2446 name: mydb/t4 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-09-29  9:05:38 140321115916032 [Warning] InnoDB: Compression failed for space: 2437 name: mydb/t5 len: 16384 err: 0 write_size: 0 compression method: LZMA.
2017-09-29  9:06:08 140321132701440 [Warning] InnoDB: Compression failed for space: 2284 name: mydb/t6 len: 16384 err: 0 write_size: 0 compression method: LZMA.

What does it mean, how can I fix these warning messages? Thanks.



 Comments   
Comment by Jan Lindström (Inactive) [ 2017-10-02 ]

This means that data on these tables is not easily compressible using LZMA method. Personally, I have noticed that lz4 is clearly better than lzma on both compression and decompression speed and compression results are better.

Comment by Jan Lindström (Inactive) [ 2017-10-02 ]

This is intended behavior. If page compression fails for a tablespace there should be a message about that. This message is written only once per tablespace as long as server is up.

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