binlog_row_image specifies whether to enable full column logging.
Full column logging and non-full column logging are defined as follows:
For data manipulation language (DML) statements such as UPDATE and DELETE, in full logging, OBServer logs the new values and old values of all columns; and in non-full logging, OBServer logs only the new values without the old values.
| Property | Description |
|---|---|
| Parameter type | Enum |
| Default value | FULL |
| Value range | * FULL: Log all columns. * MINIMAL: Log 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. |
| Effective scope | * GLOBAL * SESSION |
| Involved in message serialization | Yes |
| SQL plan generation affected | Yes |
Note
Modification of 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.