Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 31 May 2009 09:10:48 +0100
From:      Matthew Seaman <m.seaman@infracaninophile.co.uk>
To:        Grant Peel <gpeel@thenetnow.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Mysql6 or Mysql5
Message-ID:  <4A223B88.80401@infracaninophile.co.uk>
In-Reply-To: <D2BBF78F6571470E9B4CB5146D9C91A4@GRANT>
References:  <D2BBF78F6571470E9B4CB5146D9C91A4@GRANT>

next in thread | previous in thread | raw e-mail | index | archive | help
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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4A223B88.80401>