From owner-freebsd-questions@FreeBSD.ORG Wed Oct 8 06:08:11 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1403B106569D for ; Wed, 8 Oct 2008 06:08:11 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from QMTA06.westchester.pa.mail.comcast.net (qmta06.westchester.pa.mail.comcast.net [76.96.62.56]) by mx1.freebsd.org (Postfix) with ESMTP id B1FE58FC13 for ; Wed, 8 Oct 2008 06:08:10 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from OMTA06.westchester.pa.mail.comcast.net ([76.96.62.51]) by QMTA06.westchester.pa.mail.comcast.net with comcast id Q64o1a00B16LCl056688xK; Wed, 08 Oct 2008 06:08:08 +0000 Received: from koitsu.dyndns.org ([69.181.141.110]) by OMTA06.westchester.pa.mail.comcast.net with comcast id Q6881a0062P6wsM3S689ZT; Wed, 08 Oct 2008 06:08:09 +0000 X-Authority-Analysis: v=1.0 c=1 a=QM_noPh8wYgA:10 a=QycZ5dHgAAAA:8 a=EtHEQm7vWax7w2Z5yBQA:9 a=FtwH5opMyvIskvoMPRUA:7 a=aUDv2FhD2Y_50Q8vlKwck_B_z-gA:4 a=EoioJ0NPDVgA:10 a=LY0hPdMaydYA:10 Received: by icarus.home.lan (Postfix, from userid 1000) id 73F8BC9419; Tue, 7 Oct 2008 23:08:08 -0700 (PDT) Date: Tue, 7 Oct 2008 23:08:08 -0700 From: Jeremy Chadwick To: Zbigniew Szalbot Message-ID: <20081008060808.GA68413@icarus.home.lan> References: <94136a2c0810072248t7143c6am7b5740a7d770317d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <94136a2c0810072248t7143c6am7b5740a7d770317d@mail.gmail.com> User-Agent: Mutt/1.5.18 (2008-05-17) Cc: freebsd-questions Subject: Re: mysql binlogs and their expiry times X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 08 Oct 2008 06:08:11 -0000 On Wed, Oct 08, 2008 at 07:48:47AM +0200, Zbigniew Szalbot wrote: > Hi there, > > I hope someone can help. Due to they way my HD has been sliced I had > to move mysql database to /usr/local/mysql. All works fine. Last week > I added this entry > > #expire bin logs > expire_logs_days = 7 > > to /usr/local/mysql/my.cnf > > I restarted the MySQL server and now I have been waiting for the > binlogs to automatically expire but this is not happening: > > $ ls -l /usr/local/mysql > > -r--r--r-- 1 mysql mysql 4954 Oct 1 07:30 my.cnf > drwx------ 2 mysql mysql 1536 Sep 27 07:10 mysql > -rw-rw---- 1 mysql mysql 1073745213 Sep 2 04:07 mysql-bin.000047 > -rw-rw---- 1 mysql mysql 1073746878 Sep 7 03:48 mysql-bin.000048 > -rw-rw---- 1 mysql mysql 1073745707 Sep 11 20:07 mysql-bin.000049 > -rw-rw---- 1 mysql mysql 175527890 Sep 12 08:32 mysql-bin.000050 > -rw-rw---- 1 mysql mysql 128272 Sep 12 08:40 mysql-bin.000051 > -rw-rw---- 1 mysql mysql 1073745119 Sep 17 04:35 mysql-bin.000052 > -rw-rw---- 1 mysql mysql 1073747657 Sep 22 04:26 mysql-bin.000053 > -rw-rw---- 1 mysql mysql 1073744456 Sep 27 03:28 mysql-bin.000054 > -rw-rw---- 1 mysql mysql 986782722 Oct 1 07:32 mysql-bin.000055 > -rw-rw---- 1 mysql mysql 1073742442 Oct 6 04:18 mysql-bin.000056 > -rw-rw---- 1 mysql mysql 536487381 Oct 8 07:45 mysql-bin.000057 > -rw-r----- 1 mysql mysql 209 Oct 6 04:18 mysql-bin.index > > Do you have any idea why? Or if /usr/local/mysql/ is a correct > location for my.cnf file? Perhaphs it should go to /usr/local/etc/ ? > > If it matters, I use > $ pkg_info -Ix mysql-s > mysql-server-5.0.67 Multithreaded SQL database (server) > from ports. Shouldn't this question be going to the MySQL people and not FreeBSD? -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |