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.
| Attribute | Description |
|---|---|
| Type | Enum |
| Default value | FULL |
| Value range | |
| Applicable scope | |
| Involved in message serialization | Yes |
| SQL plan generation affected | Yes |
Note
A modification that is made 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.