From owner-freebsd-questions@FreeBSD.ORG Thu Sep 20 04:15:34 2007 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 8C91B16A41B for ; Thu, 20 Sep 2007 04:15:34 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by mx1.freebsd.org (Postfix) with ESMTP id 49C5513C45A for ; Thu, 20 Sep 2007 04:15:34 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.1/8.14.1) id l8K4FXRd010922; Wed, 19 Sep 2007 23:15:33 -0500 (CDT) (envelope-from dan) Date: Wed, 19 Sep 2007 23:15:33 -0500 From: Dan Nelson To: Aliya Harbouri Message-ID: <20070920041533.GF7562@dan.emsphone.com> References: <20070920025713.GE7562@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: FreeBSD 7.0-CURRENT User-Agent: Mutt/1.5.16 (2007-06-09) Cc: freebsd-questions@freebsd.org Subject: Re: Which knobs do I use to control BDB use in MySQL-server port? 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: Thu, 20 Sep 2007 04:15:34 -0000 In the last episode (Sep 19), Aliya Harbouri said: > > > (1) Turn OFF use of BDB completely. The build seems to default > > > to the bundled BDB > > > > Mysql 5.0's configure script doesn't seem to have a --without-bdb > > flag, so it always gets built. > > > > (2) Use the Port install of BDB v46 I mentioned above. > > > > It does have a --with-berkeley-db=DIR flag, so you could add that > > to CONFIGURE_ARGS to force an external bdb to be used instead of > > the one bundled with mysql. Note that the bdb engine has been > > removed from mysql 5.1, so you should think about moving any bdb > > tables you might already have to innodb. Development on the bdb > > engine pretty much stopped once innodb was available. > > Gotcha! > > So, If I'm going to use the Port & make changes anyway, since, > > grep berkeley-db Makefile > CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db > > I suppose I might as well just do > > vi Makefile > > .if ${ARCH} == "i386" > - CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db > + CONFIGURE_ARGS+=--enable-assembler --without-berkeley-db > .endif I just tried it and it looks like that does disable bdb. I never noticed that line in the Makefile before :) > I know about the BDB-engine removal, too. Funny that this Port > doesn't give you that option. > > Thanks a lot! > > Ali -- Dan Nelson dnelson@allantgroup.com