From owner-freebsd-questions@FreeBSD.ORG Fri Sep 30 16:21:48 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2C16C16A41F for ; Fri, 30 Sep 2005 16:21:48 +0000 (GMT) (envelope-from corwin@pleiades.aeternal.net) Received: from pleiades.aeternal.net (pleiades.in.markiza.sk [62.168.76.28]) by mx1.FreeBSD.org (Postfix) with ESMTP id AA8A243D48 for ; Fri, 30 Sep 2005 16:21:47 +0000 (GMT) (envelope-from corwin@pleiades.aeternal.net) Received: by pleiades.aeternal.net (Postfix, from userid 1001) id BD7DD1141E; Fri, 30 Sep 2005 18:22:03 +0200 (CEST) Date: Fri, 30 Sep 2005 18:22:03 +0200 From: martin hudec To: freebsd-questions@freebsd.org Message-ID: <20050930162203.GD87964@pleiades.aeternal.net> References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <433D3C12.6020104@axis.nl> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="kvUQC+jR9YzypDnK" Content-Disposition: inline In-Reply-To: X-Copyright: (C) 2005 Martin Hudec X-Operating-System: FreeBSD pleiades.aeternal.net 7.0-CURRENT i386 X-PGP-Key: http://www.aeternal.net/corwin_aeternal.asc User-Agent: mutt-ng/devel-r445 (FreeBSD) Subject: Re: Which MySQL version best to use and with/without linux threads? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: martin hudec List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 Sep 2005 16:21:48 -0000 --kvUQC+jR9YzypDnK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello, On Fri, Sep 30, 2005 at 08:08:32PM +0400 or thereabouts, Andrew P. wrote: > As for the MySQL version (branch) - the only > difference you should care about is feature set. > If you feel comfortable without triggers and > stored procedures (their absence makes > many professional MSSQL/Oracle/Postgres > users frown upon MySQL) you shouldn't be > looking at MySQL 5.0 for at least another > half a year. As for 4.1/4.0 - you should probably > stick to 4.0 on your mission-critical servers, > but certainly try 4.1 on your production, but > not so critical servers. 4.1 has collations, ndb clustering.. I am currently deploying these features to our.. mission critical servers.. and I am playing with idea to use 5.0.13 for this - after very intensive testing of course :).. If one has no need for collations and clustering, then your advice to stay with 4.0 is good.. one might experience slight difficulties while migrating databases with utf8 data (length of keys etc.). --=20 martin hudec * 421 907 303 393 * corwin@aeternal.net * http://www.aeternal.net "Nothing travels faster than the speed of light with the possible=20 exception of bad news, which obeys its own special laws." Douglas Adams, "The Hitchhiker's Guide to the Galaxy" --kvUQC+jR9YzypDnK Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQFDPWYrZYEZIv+rgggRApmsAKCJ/aedkUS52i/qJgnphVwQ0gfkCQCdG1us au10h5dMVazGL0cJZ4Grbqg= =PISy -----END PGP SIGNATURE----- --kvUQC+jR9YzypDnK--