binlog_row_image

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: System Variables for MariaDB Enterprise Server

Topics on this page:

• Overview

• DETAILS

  • PARAMETERS

  • SKYSQL

• CHANGE HISTORY

• EXTERNAL REFERENCES

Overview

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).