From owner-freebsd-questions@FreeBSD.ORG Thu Sep 20 03:53:59 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 004AE16A41A for ; Thu, 20 Sep 2007 03:53:58 +0000 (UTC) (envelope-from aliyaharbouri@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by mx1.freebsd.org (Postfix) with ESMTP id 7D5D113C4CA for ; Thu, 20 Sep 2007 03:53:58 +0000 (UTC) (envelope-from aliyaharbouri@gmail.com) Received: by ug-out-1314.google.com with SMTP id a2so405670ugf for ; Wed, 19 Sep 2007 20:53:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=+tjdurbnaE+lCBoMqYwb9abaaFrHA4QpnTNF/kujvZQ=; b=M176r+7K51ihfNEdAW2UOYIIDpHg1JmK8hP24duKLKCtUfL7xu/bRKEq0TFYvNlvEoeCP48cxscEjbPmmt0GuyGFslVysQ7qGi3rJXoTMIGCzPvyQ/OsoxumLF/0e2kHaw9frunGb2x02FWd10lscWikNQ9145ft/3y6C6ua5UM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=r3Ui/pFm+EVW1YRssMwgnPk/eRjcAZKpL7wWXeEFNgwN7OilkukNJHpQXAzQk32XMONJs5nAezNSUfNqE7bC6lzJNgICgdoJIJk5uFigle6QCL8s9yw5kN3M/AT+sPsWylpXBayq60ZEP42UxHMTq4h7DsNo9/D210Qj4b1uU60= Received: by 10.66.217.2 with SMTP id p2mr769528ugg.1190260436542; Wed, 19 Sep 2007 20:53:56 -0700 (PDT) Received: by 10.67.91.14 with HTTP; Wed, 19 Sep 2007 20:53:56 -0700 (PDT) Message-ID: Date: Wed, 19 Sep 2007 20:53:56 -0700 From: "Aliya Harbouri" To: "Dan Nelson" In-Reply-To: <20070920025713.GE7562@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070920025713.GE7562@dan.emsphone.com> 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 03:53:59 -0000 Hi Dan! > > (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 know about the BDB-engine removal, too. Funny that this Port doesn't give you that option. Thanks a lot! Ali