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 | |
| Applicable scope | |
| Involved in message serialization | Yes |
| SQL plan generation affected | Yes |
Note
The modification to this variable by running theSET GLOBAL binlog_row_image= 'xxx'command does not take effect on established sessions, including the session that initiates the modification.