Binary Log Options and Variables

System variables for controlling binary logging.

Name	Cmd-Line	Option file	System Var	Status Var	Var Scope	Dynamic
binlog_rows_table_metadata_events	Yes	Yes	Yes	Yes	Global, Session	Yes
expire_logs_days	Yes	Yes	Yes	Yes	Global	Yes
binlog_write_user_info	Yes	Yes	Yes	Yes	Global	Yes

binlog_rows_table_metadata_events

Write Table_metadata events to the binary log.

Command-Line Format	--binlog_rows_table_metadata_events
Option-File Format	binlog_rows_table_metadata_events
Option Sets Variable	Yes, binlog_rows_table_metadata_events
Variable Name	binlog_rows_table_metadata_events
Variable Scope	Global, Session
Dynamic Variable	No
Type	boolean
Default	OFF
Valid Values	ON

expire_logs_days

The number of days for automatic binary log file removal. The value can be specified to a fraction of one day. For example, 12 hours can be expressed as 0.5 day.

Command-Line Format	--expire_logs_days
Option-File Format	expire_logs_days
Option Sets Variable	Yes, expire_logs_days
Variable Name	expire_logs_days
Variable Scope	Global
Dynamic Variable	Yes
Type	Decimal
Default	0
Valid Values	[0, 99]

binlog_write_user_info

Emit user@host information when writing an event to binlog. This will be read by mysqlbinlog.

Command-Line Format	--binlog_write_user_info
Option-File Format	binlog_write_user_info
Option Sets Variable	Yes, binlog_write_user_info
Variable Name	binlog_write_user_info
Variable Scope	Global
Dynamic Variable	Yes
Type	boolean
Default	OFF
Valid Values	ON