Quote:
Originally Posted by Clarity
Is there a good way to make it keep binary logs only for the last 24 hours?
We have them going back a month and a half. At 1g every 36 hours or so, it adds up.
|
I'm not a SQL expert by any stretch, but I'm guessing there has to be a way to truncate the bin logs so that it isn't eating up your disk space as much.
I found this link which seems to indicate there is a way within SQL to get the logs to expire automatically (and it's configurable too)
Patterns ? Blog Archive ? MySQL: Purge binary logs
Hope that helps you C-dawg.