From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 04:10:22 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 EC69516A41F for ; Fri, 16 Sep 2005 04:10:22 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.201]) by mx1.FreeBSD.org (Postfix) with ESMTP id 894AB43D4C for ; Fri, 16 Sep 2005 04:10:22 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by xproxy.gmail.com with SMTP id i27so60016wxd for ; Thu, 15 Sep 2005 21:10:21 -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:mime-version:content-type:content-transfer-encoding:content-disposition; b=ShzTPCzS7dFa4cAlfHZGVajtDakwl1+Fd9Q1Dn7j+j5AcwCFBd/o0o6IEtzX3yDYww19IgmKC7o3CWECv4JLAAc/6LAF13NKBQm5KfTJkL+NcDXON712WNL84rLsduep++ee1p3/ezIXvtLheEFJuPyJwS3g02uxStj2fV9Rtrw= Received: by 10.70.38.7 with SMTP id l7mr86351wxl; Thu, 15 Sep 2005 21:10:21 -0700 (PDT) Received: by 10.70.35.7 with HTTP; Thu, 15 Sep 2005 21:10:21 -0700 (PDT) Message-ID: <8a52552405091521103933833d@mail.gmail.com> Date: Thu, 15 Sep 2005 21:10:21 -0700 From: Justin Bastedo To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Subject: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Sep 2005 04:10:23 -0000 I was just curoius to know if FreeBSD will run MySQL configured to support the Archive Table engine in 5.0. here are some version infos if it helps mysql Ver 14.12 Distrib 5.0.12-beta, for portbld-freebsd5.4 (amd64) using = 4.3 FreeBSD server4 5.4-RELEASE-p7 FreeBSD 5.4-RELEASE-p7 #0: Wed Sep 7 14:12:34 CDT 2005 user@server4:/usr/obj/usr/src/sys/SERVER4SMP=20 amd64 --=20 Justin Bastedo At Gmail Dot Com -------------------------------------------------- http://www.thebastedo.com From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 04:13:41 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 A9F0416A420 for ; Fri, 16 Sep 2005 04:13:41 +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 B61B643D49 for ; Fri, 16 Sep 2005 04:13:40 +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 8F50613112A; Fri, 16 Sep 2005 13:43:39 +0930 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 691A385220; Fri, 16 Sep 2005 13:43:39 +0930 (CST) Date: Fri, 16 Sep 2005 13:43:39 +0930 From: Greg 'groggy' Lehey To: Justin Bastedo Message-ID: <20050916041339.GN86168@wantadilla.lemis.com> References: <8a52552405091521103933833d@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="dZihrQ6eCIduWT38" Content-Disposition: inline In-Reply-To: <8a52552405091521103933833d@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: freebsd-database@freebsd.org 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 04:13:41 -0000 --dZihrQ6eCIduWT38 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thursday, 15 September 2005 at 21:10:21 -0700, Justin Bastedo wrote: > I was just curoius to know if FreeBSD will run MySQL configured to > support the Archive Table engine in 5.0. > > here are some version infos if it helps > > mysql Ver 14.12 Distrib 5.0.12-beta, for portbld-freebsd5.4 (amd64) using 4.3 > > FreeBSD server4 5.4-RELEASE-p7 FreeBSD 5.4-RELEASE-p7 #0: Wed Sep 7 14:12:34 CDT 2005 user@server4:/usr/obj/usr/src/sys/SERVER4SMP amd64 I'm not sure I understand the question. That looks like it builds. Have you tried running it? Greg -- See complete headers for address and phone numbers. --dZihrQ6eCIduWT38 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD4DBQFDKkZzIubykFB6QiMRAoL4AJwIUOIwOqpfar/q/nRu24SdqToHNACY+pDq 9T9G9n8kpyaVvz1ZtfJcFA== =JUjI -----END PGP SIGNATURE----- --dZihrQ6eCIduWT38-- From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 05:06:17 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 0AC3816A41F for ; Fri, 16 Sep 2005 05:06:17 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.201]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8E1D443D48 for ; Fri, 16 Sep 2005 05:06:16 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by xproxy.gmail.com with SMTP id i27so71782wxd for ; Thu, 15 Sep 2005 22:06:16 -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=fbg2L5BpipvunO96ugVe7AXqt1LzUuG/Qz30RVAJzVJ9XnPk6WqGDc2CLUyEW+ZS5qM5yum6uMh55uv4R7z1+PRDAx9Kz8A8vHVv7dsmE7Ri/jXxIarj/Z17YIeZDzwY5QOVe8DT7DVUAUSKQ8c/KCu9LR/bLAScC4N2yILAI/w= Received: by 10.70.35.10 with SMTP id i10mr12013wxi; Thu, 15 Sep 2005 21:59:08 -0700 (PDT) Received: by 10.70.35.7 with HTTP; Thu, 15 Sep 2005 21:59:08 -0700 (PDT) Message-ID: <8a52552405091521592405d814@mail.gmail.com> Date: Thu, 15 Sep 2005 21:59:08 -0700 From: Justin Bastedo To: Greg 'groggy' Lehey In-Reply-To: <20050916041339.GN86168@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> 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Sep 2005 05:06:17 -0000 No it just isn't an option to trigger it in the Make file, so I was a bit nervous about modifying it. Also thought that it might be omitted because it is not functioning in the FreeBSD version. http://dev.mysql.com/doc/mysql/en/archive-storage-engine.html says I need to add --with-archive-storage-engine to my configure... I asked mysql if it was enabled: mysql> SHOW VARIABLES LIKE 'have_archive'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_archive | NO | +---------------+-------+ 1 row in set (0.00 sec) So just trying to do more research before I go modifying make files and risking some tweaking/breaking of my port. Also on another note, was just curious as to the stability of the version of mysql I'm using, I know its beta but is there a place I can look for a potential release date on the non-beta version? Justin On 9/15/05, Greg 'groggy' Lehey wrote: > On Thursday, 15 September 2005 at 21:10:21 -0700, Justin Bastedo wrote: > > I was just curoius to know if FreeBSD will run MySQL configured to > > support the Archive Table engine in 5.0. > > > > here are some version infos if it helps > > > > mysql Ver 14.12 Distrib 5.0.12-beta, for portbld-freebsd5.4 (amd64) us= ing 4.3 > > > > FreeBSD server4 5.4-RELEASE-p7 FreeBSD 5.4-RELEASE-p7 #0: Wed Sep 7 14= :12:34 CDT 2005 user@server4:/usr/obj/usr/src/sys/SERVER4SMP amd64 >=20 > I'm not sure I understand the question. That looks like it builds. > Have you tried running it? >=20 > Greg > -- > See complete headers for address and phone numbers. >=20 >=20 >=20 --=20 Justin Bastedo At Gmail Dot Com -------------------------------------------------- http://www.thebastedo.com -----BEGIN PGP SIGNATURE----- iQA/AwUBQWxjbLk9v2UZrS+uEQI2FQCdFYEhvXMrEIqzru+mspfxLLyutH8Ani4OwJ6946W6QMk= cHjPr4dAau6kq=3DG2aD -----END PGP SIGNATURE----- From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 05:16:03 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 1AB2116A41F for ; Fri, 16 Sep 2005 05:16:03 +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 72F9943D45 for ; Fri, 16 Sep 2005 05:16:02 +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 0F6A1131BB5; Fri, 16 Sep 2005 14:46:01 +0930 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id DDE94852DF; Fri, 16 Sep 2005 14:46:00 +0930 (CST) Date: Fri, 16 Sep 2005 14:46:00 +0930 From: Greg 'groggy' Lehey To: Justin Bastedo Message-ID: <20050916051600.GP86168@wantadilla.lemis.com> References: <8a52552405091521103933833d@mail.gmail.com> <20050916041339.GN86168@wantadilla.lemis.com> <8a52552405091521592405d814@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="jXoUnAu9pZeaHebo" Content-Disposition: inline In-Reply-To: <8a52552405091521592405d814@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: freebsd-database@freebsd.org 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 05:16:03 -0000 --jXoUnAu9pZeaHebo Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thursday, 15 September 2005 at 21:59:08 -0700, Justin Bastedo wrote: > On 9/15/05, Greg 'groggy' Lehey wrote: >> On Thursday, 15 September 2005 at 21:10:21 -0700, Justin Bastedo wrote: >>> I was just curoius to know if FreeBSD will run MySQL configured to >>> support the Archive Table engine in 5.0. >>> >>> here are some version infos if it helps >>> >>> mysql Ver 14.12 Distrib 5.0.12-beta, for portbld-freebsd5.4 (amd64) using 4.3 >>> >>> FreeBSD server4 5.4-RELEASE-p7 FreeBSD 5.4-RELEASE-p7 #0: Wed Sep 7 14:12:34 CDT 2005 user@server4:/usr/obj/usr/src/sys/SERVER4SMP amd64 >> >> I'm not sure I understand the question. That looks like it builds. >> Have you tried running it? > > No it just isn't an option to trigger it in the Make file, so I was > a bit nervous about modifying it. Also thought that it might be > omitted because it is not functioning in the FreeBSD version. Ah, OK. I don't know of any problems, but that doesn't mean much. It's equally possible that nobody has thought of adding it. > So just trying to do more research before I go modifying make files > and risking some tweaking/breaking of my port. Understood. Let me know if you have problems. > Also on another note, was just curious as to the stability of the > version of mysql I'm using, I know its beta but is there a place I > can look for a potential release date on the non-beta version? Sorry, not yet. 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/ --jXoUnAu9pZeaHebo Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDKlUQIubykFB6QiMRAko6AJ9Rg1DpJ4QuDhMHc/KmtSnLtSmlQACfUz9N GB9abp/jvhs2v3PrpXVwUSY= =X0+H -----END PGP SIGNATURE----- --jXoUnAu9pZeaHebo-- From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 06:56:39 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 5707816A41F for ; 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 ; 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 ; 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 To: Greg 'groggy' Lehey 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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. 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-- From owner-freebsd-database@FreeBSD.ORG Fri Sep 16 08:18:48 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 9060816A41F for ; Fri, 16 Sep 2005 08:18:48 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.199]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2B50F43D46 for ; Fri, 16 Sep 2005 08:18:47 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by xproxy.gmail.com with SMTP id i27so1274wxd for ; Fri, 16 Sep 2005 01:18:46 -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=ETfYzedS1lJyHxZjPlGGxOztQba3gJGWeGrJcSQjEjG/6LbNlsZ+2DmWuxjV3h79irn4g9zjWsh6/REgu1vojg2s0jnhp0sML9qiGb5JRMvKQ9bQLCHrGayMtIvfYd9CxN/L6fnOxUvzghT1rS6/QwbuEamtF9r07Hm6McWsbOI= Received: by 10.70.49.12 with SMTP id w12mr27160wxw; Fri, 16 Sep 2005 01:18:46 -0700 (PDT) Received: by 10.70.35.7 with HTTP; Fri, 16 Sep 2005 01:18:46 -0700 (PDT) Message-ID: <8a52552405091601183622ea23@mail.gmail.com> Date: Fri, 16 Sep 2005 01:18:46 -0700 From: Justin Bastedo To: Greg 'groggy' Lehey In-Reply-To: <20050916073816.GB41235@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> <8a5255240509152356516b639d@mail.gmail.com> <20050916073816.GB41235@wantadilla.lemis.com> 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 Reply-To: justin.bastedo@gmail.com 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 08:18:48 -0000 Well you'll all be glad to know the tests ran fine on my system I moved the data over from my production server using mysqlhotcopy script. stopped my mysql, moved over the databases, started it back up, renamed my MyISAM table and recreated it as an ARCHIVE table. Here is some out put with some times: mysql> SHOW TABLE STATUS LIKE 'campaign_16_long_myisam'; +-------------------------+--------+---------+------------+----------+-----= -----------+-------------+-----------------+--------------+-----------+----= ------------+---------------------+---------------------+------------+-----= --------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time =20 | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------+--------+---------+------------+----------+-----= -----------+-------------+-----------------+--------------+-----------+----= ------------+---------------------+---------------------+------------+-----= --------------+----------+----------------+---------+ | campaign_16_long_myisam | MyISAM | 9 | Dynamic | 28224724 | 88 | 2500641604 | 4294967295 | 261594112 | =20 0 | 28621173 | 2005-07-07 13:57:00 | 2005-09-15 19:00:09 | NULL | latin1_swedish_ci | NULL | | | +-------------------------+--------+---------+------------+----------+-----= -----------+-------------+-----------------+--------------+-----------+----= ------------+---------------------+---------------------+------------+-----= --------------+----------+----------------+---------+ 1 row in set (0.00 sec) mysql> DROP TABLE IF EXISTS `campaign_16_long`; Query OK, 0 rows affected (0.02 sec) mysql> CREATE TABLE `campaign_16_long` ( -> `id` int(11) NOT NULL, -> `timestamp` bigint(20) NOT NULL default '0', -> `ad_name` varchar(25) NOT NULL default '', -> `type` varchar(25) NOT NULL default '', -> `referer` varchar(100) NOT NULL default '', -> `path` varchar(255) NOT NULL default '', -> `client_ip` varchar(15) NOT NULL default '' -> ) ENGINE=3DARCHIVE DEFAULT CHARSET=3Dlatin1; Query OK, 0 rows affected (0.02 sec) mysql> INSERT INTO `ad_tracking`.`campaign_16_long` SELECT * FROM `ad_tracking`.`campaign_16_long_myisam`; ... # top last pid: 85206; load averages: 0.99, 0.74, 0.37 =20 =20 up 8+12:37:29 03:02:10 66 processes: 2 running, 64 sleeping CPU states: 25.0% user, 0.0% nice, 1.1% system, 0.0% interrupt, 73.9% id= le Mem: 113M Active, 3212M Inact, 184M Wired, 158M Cache, 214M Buf, 5368K Free Swap: 2048M Total, 2048M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAN= D 85044 mysql 20 0 59756K 34092K kserel 1 6:52 98.10% 98.10% mysqld ... Query OK, 28224724 rows affected (8 min 42.90 sec) Records: 28224724 Duplicates: 0 Warnings: 0 mysql> SHOW TABLE STATUS LIKE 'campaign_16_long'; +------------------+---------+---------+------------+----------+-----------= -----+-------------+-----------------+--------------+-----------+----------= ------+---------------------+---------------------+------------+-----------= --------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time =20 | Check_time | Collation | Checksum | Create_options | Comment | +------------------+---------+---------+------------+----------+-----------= -----+-------------+-----------------+--------------+-----------+----------= ------+---------------------+---------------------+------------+-----------= --------+----------+----------------+---------+ | campaign_16_long | ARCHIVE | 10 | Compressed | 28224724 | =20 4533 | 533048587 | 127942673892 | 0 | 0 |=20 NULL | 2005-09-16 03:04:20 | 2005-09-16 03:04:20 | NULL =20 | latin1_swedish_ci | NULL | | | +------------------+---------+---------+------------+----------+-----------= -----+-------------+-----------------+--------------+-----------+----------= ------+---------------------+---------------------+------------+-----------= --------+----------+----------------+---------+ 1 row in set (0.00 sec) # ls -alh | grep campaign_16_long -rw-rw---- 1 mysql mysql 19B Sep 16 02:54 campaign_16_long.ARM -rw-rw---- 1 mysql mysql 508M Sep 16 03:04 campaign_16_long.ARZ -rw-rw---- 1 mysql mysql 8.6K Sep 16 02:54 campaign_16_long.frm -rw-r----- 1 mysql mysql 2.3G Sep 15 19:00 campaign_16_long_myisam.MYD -rw-r----- 1 mysql mysql 249M Sep 15 21:35 campaign_16_long_myisam.MYI -rw-r----- 1 mysql mysql 8.6K Jul 7 13:57 campaign_16_long_myisam.frm The server moved 28,224,724 in 8 min 42.9 seconds. It compressed the data from 2.3G to 508M AMAZING storage saver! I am truely happy, running selects off it were just as fast as the MyISAM: mysql> SELECT * FROM `campaign_16_long_myisam` LIMIT 0, 30; ... 30 rows in set (0.00 sec) mysql> SELECT * FROM `campaign_16_long` LIMIT 0, 30; ... 30 rows in set (0.00 sec) System Specs: FreeBSD 5.4-RELEASE-p7 #0: Wed Sep 7 14:12:34 CDT 2005 CPU: Dual Core AMD Opteron(tm) Processor 265 (1792.85-MHz K8-class CPU) FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu2 (AP): APIC ID: 2 cpu3 (AP): APIC ID: 3 4096MB Ram 2 x 146GB SCSI/ RAID 1 I don't know if this helps much more than to confirm that the ARCHIVE Table Engine for MySQL 5 works fine in FreeBSD 5.4 on AMD64. But let me know if you have any more questions I would be more than happy to try and answer any. Justin