Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
From the MySQL command line, will this be ok?
Steve.
-Original
Yes, your settings will be fine. If you were already supporting
slaves which might remain dis-connected for extended periods of time,
you would have to take that into account when setting the purge
interval.
You don't need current binary logs for future slaves. You new slave
will start with a
To: mysql@lists.mysql.com
Subject: RE: Binary Logging
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
From the MySQL command