From owner-freebsd-questions@FreeBSD.ORG Wed Oct 8 05:48:49 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 0A3B01065688 for ; Wed, 8 Oct 2008 05:48:49 +0000 (UTC) (envelope-from zszalbot@gmail.com) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.226]) by mx1.freebsd.org (Postfix) with ESMTP id BD3658FC14 for ; Wed, 8 Oct 2008 05:48:48 +0000 (UTC) (envelope-from zszalbot@gmail.com) Received: by wr-out-0506.google.com with SMTP id c8so716021wra.27 for ; Tue, 07 Oct 2008 22:48:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=mUXN/+ZvbkbsQQ1/PL/AT4D15quyoujbuFNtNMcdkD8=; b=gvLz/L1+Ti1Tg2+/0OfR12Ju/YdxnsWx1aFC0LrLJNyKgFcxBxqDGBo8YP1BUF/7Ns ZArSjqtEYVFKbrpHvUynC1RlM4S0hmsnj4Gq/f0mD9Rwu2D/nrqiAU2f+JelG00bjuvJ mQZz9SAa75o3tH7cOk375gwidG1yYcry138jU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=Uv1Huitbj7c3tSk9IQy1nzyW0R6YZNtee5I+qKiJVEeTykrnh5mWWdaQZN4gATIJ/z 8agoGDjnn3P/hGn+tRb3ewNCNQzPO0dYTY2purQ5A1eXO4jehxN1ml00zKYEzTPSn+jh AqhQwLecqlA1UJdGoP68A2hAzU/nf2NsLGedw= Received: by 10.64.195.20 with SMTP id s20mr12921303qbf.20.1223444927234; Tue, 07 Oct 2008 22:48:47 -0700 (PDT) Received: by 10.64.112.18 with HTTP; Tue, 7 Oct 2008 22:48:47 -0700 (PDT) Message-ID: <94136a2c0810072248t7143c6am7b5740a7d770317d@mail.gmail.com> Date: Wed, 8 Oct 2008 07:48:47 +0200 From: "Zbigniew Szalbot" To: freebsd-questions MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: 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 05:48:49 -0000 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. Thanks! -- Zbigniew Szalbot