From owner-freebsd-questions@FreeBSD.ORG Fri Jan 1 10:04:12 2010 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 B4A28106566C for ; Fri, 1 Jan 2010 10:04:12 +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 14B0B8FC0C for ; Fri, 1 Jan 2010 10:04:11 +0000 (UTC) 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 o01A45sq057582; Fri, 1 Jan 2010 10:04:07 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.3 smtp.infracaninophile.co.uk o01A45sq057582 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=infracaninophile.co.uk; s=200708; t=1262340247; bh=mET5Cu4xL/aDUmLSXILO5iWCI2H9hDrdnXRVfpqC4nc=; 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<4B3DC88F.2020807@infracaninophile.co.uk>|Date:=20F ri,=2001=20Jan=202010=2010:03:59=20+0000|From:=20Matthew=20Seaman= 20|Organization:=20Infracaninophi le|User-Agent:=20Thunderbird=202.0.0.23=20(X11/20091129)|MIME-Vers ion:=201.0|To:=20Abdullah=20Ibn=20Hamad=20Al-Marri=20|CC:=20FreeBSD=20Questions=20|Subject:=20Re:=20FreeBSD=208.0=20and=20MySQL=205.1.x|References: =20<159045.14228.qm@web111306.mail.gq1.yahoo.com>|In-Reply-To:=20< 159045.14228.qm@web111306.mail.gq1.yahoo.com>|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=20boun dary=3D"------------enigFC6B24862A2EDAED648CB607"; b=g0gIzuBWYr1Lo/gJ7T2Ui3dHG25Vm7cVxInP8WBK0SFRMoAFttwawMLZrxWi9q4mR tAfQszicSoNL5+RlpLgP8noQ6a/N1p3d3+Lcn+S+PdxpLVexL5c1yTC7xwAnsMyXaJ qhJrN3jV3il1VgzeMjh7eHODGEmNmQ34kql+yCOU= X-Authentication-Warning: happy-idiot-talk.infracaninophile.co.uk: Host localhost [IPv6:::1] claimed to be happy-idiot-talk.infracaninophile.co.uk Message-ID: <4B3DC88F.2020807@infracaninophile.co.uk> Date: Fri, 01 Jan 2010 10:03:59 +0000 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.23 (X11/20091129) MIME-Version: 1.0 To: Abdullah Ibn Hamad Al-Marri References: <159045.14228.qm@web111306.mail.gq1.yahoo.com> In-Reply-To: <159045.14228.qm@web111306.mail.gq1.yahoo.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enigFC6B24862A2EDAED648CB607" X-Virus-Scanned: clamav-milter 0.95.3 at happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-1.4 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,FH_DATE_PAST_20XX,NO_RELAYS autolearn=no 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 Subject: Re: FreeBSD 8.0 and MySQL 5.1.x 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: Fri, 01 Jan 2010 10:04:12 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigFC6B24862A2EDAED648CB607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Abdullah Ibn Hamad Al-Marri wrote: > Hey there, >=20 > I was curious if it's the right time to move to MySQL 5.1.x instead MyS= QL 5.0.x. with FreeBSD 8.x >=20 > Any bench marks with FreeBSD 8.x? Or shall we stick to MySQL 5.0.x for = now? >=20 We can't really answer that for you. If performance is your overriding consideration, then 5.1 /might/ be a good choice. It depends very much on the sort of workloads you have. 5.0 is faster for some things, 5.1 fo= r others. I think it's generally the case though that 5.1 does give improv= ed performance on the latest multi-core 64 bit servers with high concurrency= applications, but the only way to know for sure is to run your own tests.= Don't put your trust entirely in benchmarks: they are frequently ill-conc= eived and badly executed, and usually concentrate on highlighting a specific performance feature under highly artificial conditions. Real life usage = will give you different answers. Although MySQL is pushing 5.1 as their current GA release, I don't think there's going to be any dropping of support for 5.0 any time soon. 5.1 w= ould be my first choice for a new installation, but I see no pressing need to upgrade any existing 5.0 systems. On the other hand, 5.1 is stable and reasonably well debugged nowadays, and it's got good backwards compatibil= ity with 5.0, so if you do decide to upgrade, it's probably not going to caus= e you any great trauma. 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 --------------enigFC6B24862A2EDAED648CB607 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.14 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREIAAYFAks9yJUACgkQ8Mjk52CukIxwMwCggEIP73VqgRnHEJTqgWikL+Xr ZukAn1V5udiVk4K6sCa+oztsN7p/cPY/ =jkQO -----END PGP SIGNATURE----- --------------enigFC6B24862A2EDAED648CB607--