Re: mysql-bin log file

2010-04-19 Thread Johan De Meersman
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,

Re: mysql-bin log file

2010-04-19 Thread Rob Wultsch
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

Re: mysql-bin log file

2010-04-19 Thread Johan De Meersman
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

Re: mysql-bin log file

2010-04-18 Thread Rob Wultsch
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. >

Re: mysql-bin log file

2010-04-18 Thread Prabhat Kumar
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.mirr

Re: mysql-bin log file

2010-04-18 Thread Rob Wultsch
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

mysql-bin log file

2010-04-18 Thread Angelina Paul
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