binlog_row_image specifies whether to enable full column logging.
Full column logging and non-full column logging are defined as follows:
For DML statements such as UPDATE and DELETE, full logging indicates that the OBServer node logs the new values and old values of all columns, and non-full logging indicates that the OBServer node logs only the new values.
| Attribute | Description |
|---|---|
| Type | ENUM |
| Default value | FULL |
| Value range | FULL: logs all columns.MINIMAL: logs only the columns that are modified by the DML operation to improve the leader-follower replication throughput, reduce the binlog size, and reduce required network resources and server memory.NOBLOB: not supported at present. |
| Applicable scope | |
| Involved in message serialization | Yes |
| SQL plan generation affected | Yes |
Note
Modification to this variable by running the SET GLOBAL binlog_row_image= 'xxx' command does not take effect on established sessions, including the session that initiates the modification.