From owner-freebsd-questions@FreeBSD.ORG Thu Sep 20 02:57:18 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 4A1C216A41B for ; Thu, 20 Sep 2007 02:57:18 +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 0B7DE13C46A for ; Thu, 20 Sep 2007 02:57:17 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.1/8.14.1) id l8K2vFJa007767; Wed, 19 Sep 2007 21:57:15 -0500 (CDT) (envelope-from dan) Date: Wed, 19 Sep 2007 21:57:15 -0500 From: Dan Nelson To: Aliya Harbouri Message-ID: <20070920025713.GE7562@dan.emsphone.com> References: 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 02:57:18 -0000 In the last episode (Sep 18), Aliya Harbouri said: > Building the databases/mysql50-server Port, I see (they'er all in > Makefile, yes?) my choices for knob-settings in make.conf are: > > WITH_OPENSSL=true > WITH_PROC_SCOPE_PTH=yes > BUILD_OPTIMIZED=yes > WITH_INNODB=yes > WITHOUT_ARCHIVE=true > WITHOUT_CSV=true > WITHOUT_FEDERATED=true > WITHOUT_NDB=true > > Turning INNODB on/off is clear. > > But I haven't been able to grok how to > > (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. -- Dan Nelson dnelson@allantgroup.com