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

[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] MySQL Verification Team
Hello Davi,

Thank you for the feature request and contribution!

Thanks,
Umesh

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.