From owner-freebsd-questions@FreeBSD.ORG Sun May 31 08:11:10 2009 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 CF601106566C for ; Sun, 31 May 2009 08:11:10 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id 54DB58FC13 for ; Sun, 31 May 2009 08:11:10 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.3/8.14.3) with ESMTP id n4V8AtPU015378; Sun, 31 May 2009 09:11:03 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.2 smtp.infracaninophile.co.uk n4V8AtPU015378 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=infracaninophile.co.uk; s=200708; t=1243757463; bh=OQLr3qoI2F1zZUinn2/dtJSRxlwcx9kgAM9yMKlne60=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<4A223B88.80401@infracaninophile.co.uk>|Date:=20Sun ,=2031=20May=202009=2009:10:48=20+0100|From:=20Matthew=20Seaman=20 |Organization:=20Infracaninophile |User-Agent:=20Thunderbird=202.0.0.21=20(X11/20090420)|MIME-Versio n:=201.0|To:=20Grant=20Peel=20|CC:=20freebsd- questions@freebsd.org|Subject:=20Re:=20Mysql6=20or=20Mysql5|Refere nces:=20|In-Reply-To:=20|X-Enigmail-Version:=200.95. 6|Content-Type:=20multipart/signed=3B=20micalg=3Dpgp-sha256=3B=0D= 0A=20protocol=3D"application/pgp-signature"=3B=0D=0A=20boundary=3D "------------enig19F81413F48E115382450617"; b=FwxrDTXfpNKe71ZNdeM64qWzmD15q0O3UZSuDEHjXeQtc6E119cLLcQnK/2cWctPR wtEJ3H2sOaX8LpJDMvc9+ZWuEFpDSurH/TW8P9R0/5FEJtf81oUeG3v9rrS3h0aaql yMbXQii8sczvChtkjzGeIvHl3tt6tRNIgwwpGpk0= X-Authentication-Warning: happy-idiot-talk.infracaninophile.co.uk: Host localhost [IPv6:::1] claimed to be happy-idiot-talk.infracaninophile.co.uk Message-ID: <4A223B88.80401@infracaninophile.co.uk> Date: Sun, 31 May 2009 09:10:48 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.21 (X11/20090420) MIME-Version: 1.0 To: Grant Peel References: In-Reply-To: X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig19F81413F48E115382450617" X-Virus-Scanned: clamav-milter 0.95.1 at happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-3.0 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: freebsd-questions@freebsd.org Subject: Re: Mysql6 or Mysql5 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: Sun, 31 May 2009 08:11:11 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig19F81413F48E115382450617 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Grant Peel wrote: > Does anyone have any expierience with it? Is it solid? Fast? Are > there any 'gotchas' when using databases developed on older versions > of Mysql? (4). I can't answer about speed or solidity -- except to point out that MySQL themselves describe MYSQL 6.0 as an "alpha development release". http://dev.mysql.com/downloads/mysql/6.0.html MySQL 5.1 is the preferred generally-available release at the moment. 5.1= is certainly reasonably solid, but I don't think it offers much in terms of = speed increases over 5.0 and it's likely to be slower than a 4.x system. Of co= urse, 4.x doesn't support any of the transactional stuff or foreign keys or hig= her concurrency / multiple CPUs anything like as well as the later versions. As for compatibility between MySQL 4.x and MySQL 6.x; well, it might work= , but the chances are it will break due to a number of small but incompatib= le changes in schemas, SQL etc. etc. Most readily available software will w= ork with MySQL 5.0+ nowadays, and it is usually possible for a reasonably exp= erienced DBA to load data dumped out of a 4.x server into a 5.x server without too= much expenditure of either ingenuity or profanity. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enig19F81413F48E115382450617 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEUEAREIAAYFAkoiO44ACgkQ8Mjk52CukIw8YwCXXQEXEPWl6l/Uoh258j14pTf8 QgCeOV+PKpCWuDysbgidZsqYEytnJME= =br0w -----END PGP SIGNATURE----- --------------enig19F81413F48E115382450617--