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:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any

[12 Aug 2014 8:50] Alexey Kopytov
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().
[13 Aug 2014 8:48] Marko Mäkelä
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.
[13 Aug 2014 9:06] MySQL Verification Team
Hello Alexey,

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