binlog_row_image
Controls whether rows should be logged in 'FULL', 'NOBLOB' or 'MINIMAL' formats. 'FULL', means that all columns in the before and after image are logged. 'NOBLOB', means that mysqld avoids logging blob columns whenever possible (e.g., blob column was not changed or is not part of primary key). 'MINIMAL', means that a PK equivalent (PK columns or full row if there is no PK in the table) is logged in the before image, and only changed columns are logged in the after image. (Default: FULL).
See also: System Variables in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
PARAMETERS
Command-line |
--binlog_row_image={MINIMAL| |
Configuration file |
Supported |
Dynamic |
Yes |
Scope |
Global, Session |
Data Type |
ENUM (MINIMAL, NOBLOB, FULL) |
Default Value |
FULL |
SKYSQL
Cloud |
SkySQL Topology |
ES Ver |
Default |
---|---|---|---|
AWS |
HA (Primary/Replica) |
10.4 |
MINIMAL |
AWS |
HA (Primary/Replica) |
10.5 |
MINIMAL |
AWS |
Transactional Standalone |
10.4 |
MINIMAL |
AWS |
Transactional Standalone |
10.5 |
MINIMAL |
AWS |
Distributed Transactions |
10.5 |
MINIMAL |
GCP |
ColumnStore |
10.5 |
FULL |
GCP |
ColumnStore Multi |
10.5 |
FULL |
GCP |
Galera |
10.4 |
MINIMAL |
GCP |
Galera |
10.5 |
MINIMAL |
GCP |
HA (Primary/Replica) |
10.4 |
MINIMAL |
GCP |
HA (Primary/Replica) |
10.5 |
MINIMAL |
GCP |
HTAP |
10.5 |
FULL |
GCP |
Transactional Standalone |
10.4 |
MINIMAL |
GCP |
Transactional Standalone |
10.5 |
MINIMAL |
GCP |
Distributed Transactions |
10.5 |
MINIMAL |
See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.
CHANGE HISTORY
Release Series |
History |
---|---|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the binlog_row_image page in the SkySQL Documentation.