Binary Log Expiration
SHOW VARIABLES LIKE 'binlog_expire_logs_seconds';
SHOW VARIABLES LIKE 'expire_logs_days';
expire_logs_days = 0 means binary logs are never automatically deleted based on age.
Check replication format
SHOW VARIABLES LIKE 'binlog_format';
| Value | Meaning |
|---|---|
STATEMENT | Uses SQL statements in the binary log. |
ROW | Logs each changed row explicitly. |
MIXED | MySQL chooses STATEMENT or ROW automatically based on the context. |