From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 07:38:18 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C69F516A41F; Fri, 16 Sep 2005 07:38:18 +0000 (GMT) (envelope-from grog@lemis.com) Received: from ext-gw.lemis.com (ext-gw.lemis.com [150.101.14.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id C8F1A43D49; Fri, 16 Sep 2005 07:38:17 +0000 (GMT) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by ext-gw.lemis.com (Postfix) with ESMTP id 7376413111E; Fri, 16 Sep 2005 17:08:16 +0930 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 4E6C184D73; Fri, 16 Sep 2005 17:08:16 +0930 (CST) Date: Fri, 16 Sep 2005 17:08:16 +0930 From: Greg 'groggy' Lehey To: Justin Bastedo Message-ID: <20050916073816.GB41235@wantadilla.lemis.com> References: <8a52552405091521103933833d@mail.gmail.com> <20050916041339.GN86168@wantadilla.lemis.com> <8a52552405091521592405d814@mail.gmail.com> <20050916051600.GP86168@wantadilla.lemis.com> <8a5255240509152356516b639d@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="rJwd6BRFiFCcLxzm" Content-Disposition: inline In-Reply-To: <8a5255240509152356516b639d@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Organization: MySQL AB Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.MySQL.com/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: freebsd-database@freebsd.org, Alex Dupre Subject: Re: MySQL 5 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Sep 2005 07:38:18 -0000 --rJwd6BRFiFCcLxzm Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thursday, 15 September 2005 at 23:56:38 -0700, Justin Bastedo wrote: > Well I did modify the Makefile it seemed to compile fine, i'm in the > process of moving over a large db from my current server and am about > to test and move a large amount of data into an archive table so i'll > be sure to let everyone know how it goes here. > > just for your reference, not sure if you want to add them but here is > a diff of the changes i made to my make file: > > # diff Makefile Makefile.orig > 68,71d67 > < .if defined(WITH_ARCHIVE_ENGINE) > < CONFIGURE_ARGS+=--with-archive-storage-engine > < .endif > < > 150d145 > < @${ECHO} " WITH_ARCHIVE_ENGINE=yes Enable Archive Table > Engine Support." Thanks, that's very helpful. I'm copying Alex on this, since he's the maintainer for this port. > I think this will be a more common need amoung mysql users moving > into mysql 5. I'm not quite sure but I think this engine will also > work in mysql 4.1 so it might be nice to have that there, especially > until the 5 port comes off of beta. I may test this in 4.1 just to > compare speeds and stability. Thanks. Keep us informed. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia See complete headers for address and phone numbers. Are you MySQL certified? http://www.mysql.com/certification/ --rJwd6BRFiFCcLxzm Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDKnZoIubykFB6QiMRAtubAKCDsPyjnqhN6TJ8gFbTf/IaFmAwiQCgh2Ig AhpXKz4nsY3NkOmLyQYg8Z4= =7uAV -----END PGP SIGNATURE----- --rJwd6BRFiFCcLxzm--