On Mon, Apr 19, 2010 at 12:16 PM, Rob Wultsch wrote:
> One way or another this
> should be a conscious decision, not a copy and paste from a mailing
> list.
>
As is the case with most settings :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt,
On Mon, Apr 19, 2010 at 1:07 AM, Johan De Meersman wrote:
> On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote:
>>
>> And if your slave's IO lags badly enough this will hose you. Further
>
> True, but if you remove logs that haven't been transferred, yet, you lose
> your slave.
>
> Transfer of lo
On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote:
>
> And if your slave's IO lags badly enough this will hose you. Further
>
True, but if you remove logs that haven't been transferred, yet, you lose
your slave.
Transfer of logs shouldn't be lagging that much, really, unless you're
replicating
On Sun, Apr 18, 2010 at 9:40 PM, Prabhat Kumar wrote:
> You can add a expire_logs_days Variable in my.cnf during the configuration
> of replication server.
>
> # expire_logs_days = 7
>
> It will purged binary logs older than 7 days.The old logs will be purged
> during the next bin-log swittch.
>
You can add a *expire_logs_days* Variable in my.cnf during the
configuration of replication server.
#* expire_logs_days = 7*
It will purged binary logs older than 7 days.The old logs will be purged
during the next bin-log switch.
Or, You can also delete bin-log manually using command :
PURGE B
On Sun, Apr 18, 2010 at 8:58 PM, Angelina Paul wrote:
> How can I remove old mysql-bin log file in log directory? A mysql full
> backup will clear the old mysql bin log file or not?
>
> Thanks,
> Arshu Paul
>
You probably want
http://mysql2.mirrors-r-us.net/doc/refman/5.1/en/purge-master-logs.ht
