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>