Re: MySQL purge logs
- Date: Mon, 12 May 2008 11:58:42 -0400
- From: "Augusto Bott" <augusto@xxxxxxxxxxx>
- Subject: Re: MySQL purge logs
You could also do:
SET GLOBAL expire_log_days=n;
BTW - this same hint is on the the very same manual page you mentioned
at the beginning of this thread.
--
Augusto Bott
On Mon, May 12, 2008 at 11:11 AM, Rick James <rjames@xxxxxxxxxxxxx> wrote:
> RESET is not a good idea -- PURGE to some point is better.
>
>
>
>
>
> > -----Original Message-----
> > From: Dennis Yu [mailto:service@xxxxxxxxxxxxxxx]
> > Sent: Sunday, May 11, 2008 6:10 PM
> > To: Kaushal Shriyan
> > Cc: mysql@xxxxxxxxxxxxxxx; replication@xxxxxxxxxxxxxxx
> > Subject: Re: MySQL purge logs
> >
> > login MySQL with "root" and use:
> > RESET MASTER
> > that's all you need to do.
> >
> >
> > Kaushal Shriyan wrote:
> > > Hi
> > >
> > > I am referring to
> > > http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
> > >
> > > whats the exact syntax to purge this MySQL Binary Logs
> > >
> > > -rw-rw---- 1 mysql 701 1.1G May 5 07:39 host1-bin.000681
> > > -rw-rw---- 1 mysql 701 1.1G May 5 09:09 host1-bin.000682
> > > -rw-rw---- 1 mysql 701 1.1G May 5 10:49 host1-bin.000683
> > > -rw-rw---- 1 mysql 701 1.1G May 5 20:24 host1-bin.000684
> > > -rw-rw---- 1 mysql 701 1.1G May 5 21:47 host1-bin.000685
> > > -rw-rw---- 1 mysql 701 1.1G May 5 23:31 host1-bin.000686
> > > -rw-rw---- 1 mysql 701 1.1G May 6 01:40 host1-bin.000687
> > > -rw-rw---- 1 mysql 701 1.1G May 6 04:26 host1-bin.000688
> > > -rw-rw---- 1 mysql 701 1.1G May 6 07:00 host1-bin.000689
> > > -rw-rw---- 1 mysql 701 1.1G May 6 08:58 host1-bin.000690
> > > -rw-rw---- 1 mysql 701 1.1G May 6 17:54 host1-bin.000691
> > > -rw-rw---- 1 mysql 701 1.1G May 6 21:01 host1-bin.000692
> > > -rw-rw---- 1 mysql 701 1.1G May 6 22:46 host1-bin.000693
> > > -rw-rw---- 1 mysql 701 1.1G May 7 00:56 host1-bin.000694
> > > -rw-rw---- 1 mysql 701 1.1G May 7 02:52 host1-bin.000695
> > > -rw-rw---- 1 mysql 701 1.1G May 7 05:44 host1-bin.000696
> > > -rw-rw---- 1 mysql 701 1.1G May 7 07:28 host1-bin.000697
> > > -rw-rw---- 1 mysql 701 1.1G May 7 09:09 host1-bin.000698
> > > -rw-rw---- 1 mysql 701 1.1G May 7 18:40 host1-bin.000699
> > > -rw-rw---- 1 mysql 701 1.1G May 7 21:00 host1-bin.000700
> > > -rw-rw---- 1 mysql 701 1.1G May 7 22:35 host1-bin.000701
> > > -rw-rw---- 1 mysql 701 1.1G May 8 00:40 host1-bin.000702
> > > -rw-rw---- 1 mysql 701 1.1G May 8 03:20 host1-bin.000703
> > > -rw-rw---- 1 mysql 701 1.1G May 8 05:53 host1-bin.000704
> > > -rw-rw---- 1 mysql 701 1.1G May 8 07:59 host1-bin.000705
> > > -rw-rw---- 1 mysql 701 1.1G May 8 09:24 host1-bin.000706
> > > -rw-rw---- 1 mysql 701 1.1G May 8 18:36 host1-bin.000707
> > > -rw-rw---- 1 mysql 701 1.1G May 8 21:21 host1-bin.000708
> > > -rw-rw---- 1 mysql 701 1.1G May 8 22:57 host1-bin.000709
> > > -rw-rw---- 1 mysql 701 1.1G May 9 01:25 host1-bin.000710
> > > -rw-rw---- 1 mysql 701 1.1G May 9 03:41 host1-bin.000711
> > > -rw-rw---- 1 mysql 701 1.1G May 9 06:05 host1-bin.000712
> > > -rw-rw---- 1 mysql 701 1.1G May 9 07:50 host1-bin.000713
> > > -rw-rw---- 1 mysql 701 1.1G May 9 09:29 host1-bin.000714
> > > -rw-rw---- 1 mysql 701 1.1G May 9 19:20 host1-bin.000715
> > > -rw-rw---- 1 mysql 701 1.1G May 9 21:46 host1-bin.000716
> > >
> > > Thanks and Regards
> > >
> > > Kaushal
> > >
> > >
> >
> >
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=rjames@xxxxxxxxxxxxx
>
>
> >
> >
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=augusto.bott@xxxxxxxxx
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx