-
Notifications
You must be signed in to change notification settings - Fork 446
Binary Log Options and Variables
Liang Guo edited this page Mar 14, 2014
·
7 revisions
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 |
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 |
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] |
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 |