From owner-freebsd-database@FreeBSD.ORG  Fri Sep 16 06:56:39 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
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 5707816A41F
	for <freebsd-database@freebsd.org>;
	Fri, 16 Sep 2005 06:56:39 +0000 (GMT)
	(envelope-from justin.bastedo@gmail.com)
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.205])
	by mx1.FreeBSD.org (Postfix) with ESMTP id D47D043D46
	for <freebsd-database@freebsd.org>;
	Fri, 16 Sep 2005 06:56:38 +0000 (GMT)
	(envelope-from justin.bastedo@gmail.com)
Received: by xproxy.gmail.com with SMTP id i27so96039wxd
	for <freebsd-database@freebsd.org>;
	Thu, 15 Sep 2005 23:56:38 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=BiJanawunY0W8QGarbFc+RCZUbiHhCAkR+TnsFkMqc8k8rLyCX0MyBGGdXt5EvDKwoIbBKntZJlpz7WQEViGWnEAdfzYKw7q7lEfY5WGbsl2t9MD0RJh1OXJGLsG5Sm79/eU4SURq2e6vyh85Sv10crm1bnmT6R1un6AJPt3WAY=
Received: by 10.70.41.15 with SMTP id o15mr11136wxo;
	Thu, 15 Sep 2005 23:56:38 -0700 (PDT)
Received: by 10.70.35.7 with HTTP; Thu, 15 Sep 2005 23:56:38 -0700 (PDT)
Message-ID: <8a5255240509152356516b639d@mail.gmail.com>
Date: Thu, 15 Sep 2005 23:56:38 -0700
From: Justin Bastedo <justin.bastedo@gmail.com>
To: Greg 'groggy' Lehey <grog@mysql.com>
In-Reply-To: <20050916051600.GP86168@wantadilla.lemis.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <8a52552405091521103933833d@mail.gmail.com>
	<20050916041339.GN86168@wantadilla.lemis.com>
	<8a52552405091521592405d814@mail.gmail.com>
	<20050916051600.GP86168@wantadilla.lemis.com>
Cc: freebsd-database@freebsd.org
Subject: Re: MySQL 5
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: justin.bastedo@gmail.com
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 16 Sep 2005 06:56:39 -0000

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+=3D--with-archive-storage-engine
< .endif
<
150d145
<       @${ECHO} "      WITH_ARCHIVE_ENGINE=3Dyes Enable Archive Table
Engine Support."

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.