Bug #80770 Compression of row-based event
Submitted: 16 Mar 2016 20:51 Modified: 3 Aug 2016 5:29
Reporter: Davi Arnaut (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S4 (Feature request)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: binlog, compression, row
Triage: Needs Triage: D5 (Feature request)

[16 Mar 2016 20:51] Davi Arnaut
Description:
In row-based-replication, row events usually contain full copies of
the columns being modified. Although it is possible to omit columns
which are not being changed, the full image of changed columns is
still logged no matter how much of the data changed. If only a small
portion of the data in a column is changed, much space might be
wasted.

How to repeat:
For example, modify a small part of a large blob column.

Suggested fix:
In order to reduce the size of such row events, it would be nice to
have the the ability to compress the row data part of row events.
[16 Mar 2016 20:53] Davi Arnaut
Compression of row-based events

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: Compression-of-row-based-events.patch (application/octet-stream, text), 39.96 KiB.

[3 Aug 2016 5:29] Umesh Shastry
Hello Davi,

Thank you for the feature request and contribution!

Thanks,
Umesh