MySQL Bugs: #73548: Backport fix for bug #16267120 to MySQL 5.5

Bug #73548	Backport fix for bug #16267120 to MySQL 5.5
Submitted:	12 Aug 2014 8:50	Modified:	13 Aug 2014 9:06
Reporter:	Alexey Kopytov	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.5	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The Oracle internal bug 16267120 has only been fixed in 5.6. The problem with not fixing it in 5.5 (or even 5.1) is that backup tools such as MEB or Percona XtraBackup are more likely to be affected by zlib version mismatch on recovery (as backup prepare is usually performed either on another host, or much later after taking a backup, after a system upgrade).

This is a request to backport the fix for bug 16267120 to MySQL 5.5, so that compressed page images are always logged on page reorganize.

How to repeat:
Analyze the fix for bug #16267120 in 5.6. Check the 5.5 code in btr_page_reorganize_low().

Thanks, Alexey. You are right that this would be good to fix in MySQL 5.5.

Because the fix in MySQL 5.6 depends on the configuration parameter innodb_log_compressed_pages, which is new in MySQL 5.6, the backport to MySQL 5.5 should done in a way that "hard-wires" innodb_log_compressed_pages=ON.

Hello Alexey,

Thank you for the valid request.
Thank you Marko for the explanation, verifying based on last note.

Thanks,
Umesh