Binary Logging

Support
,
1

@pandabrand @ben.turner @Nick-B

Instead of turning off the binary logging entirely in MySQL 8 with disable-log-bin you can also set the max_binlog_size and binlog_expire_logs_seconds variables to some minimal values to reduce the binary log size significantly but still keep some data integrity and recovery operations.

max_binlog_size = 4096
binlog_expire_logs_seconds = 60

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_max_binlog_size

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_expire_logs_seconds

1 Like
2

A post was merged into an existing topic: How can I turn off Binary Logging?