From owner-freebsd-amd64@FreeBSD.ORG Mon Oct 3 03:44:16 2005 Return-Path: X-Original-To: amd64@FreeBSD.org Delivered-To: freebsd-amd64@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6B0F816A41F for ; Mon, 3 Oct 2005 03:44:16 +0000 (GMT) (envelope-from mv@roq.com) Received: from vault.mel.jumbuck.com (ppp166-27.static.internode.on.net [150.101.166.27]) by mx1.FreeBSD.org (Postfix) with ESMTP id CA3F543D45 for ; Mon, 3 Oct 2005 03:44:15 +0000 (GMT) (envelope-from mv@roq.com) Received: from vault.mel.jumbuck.com (localhost [127.0.0.1]) by vault.mel.jumbuck.com (Postfix) with ESMTP id 4DF008A028; Mon, 3 Oct 2005 13:42:51 +1000 (EST) Received: from [192.168.46.52] (unknown [192.168.46.250]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by vault.mel.jumbuck.com (Postfix) with ESMTP id 2C6DC8A027; Mon, 3 Oct 2005 13:42:51 +1000 (EST) Message-ID: <4340A90E.9070806@roq.com> Date: Mon, 03 Oct 2005 13:44:14 +1000 From: Michael VInce User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.7.11) Gecko/20050925 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Olaf Greve References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <433D3C12.6020104@axis.nl> In-Reply-To: <433D3C12.6020104@axis.nl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP Cc: amd64@FreeBSD.org Subject: Re: Which MySQL version best to use and with/without linux threads? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 03 Oct 2005 03:44:16 -0000 I did benchmarks with Linux threads and without on 5.x and found Linux threads didn't help at all. It probably does on 4.x though. And i did consistently benchmark 4.0.x faster then 4.1 but it wasn't a large amount of difference. If your db server isn't maxed out in anyway and there are features in 4.1 you want then I would see little harm in upgrading. Mike Olaf Greve wrote: > Hi, > > I've got a MySQL 4.0.16 DB running with several DB instances in it. So > far, so good, but I'm looking for a bit of advice. > > I've got a few small questions: > > Firstly: is it (for a webserver) better to compile MySQL with > linux-threads or without? I seem to recall having read that Linux uses > a better threading mechanism, and that MySQL really benefits from > this... What do you all think? > > Then, I'm currently configuring a second beast, eehhhh, server. :) > Being an AMD-64 19" server, running FreeBSD 5.4-Release AMD64. On it, > I instinctively installed the latest MySQL 4.0.x version (being > 4.0.26) and it works flawlessly with the data from my current > production machine. > > Still so far, so good. :) > > However... I was wondering what the advantages (and potential > disadvantages!) may be of using a newer line of the MySQL DB. > > Can anyone tell me what the advantages/pitfalls may be of using v4.1.x > or even v5, over using 4.0.x ? > > A year or two ago I installed a 4.1.x version and there were some > issues then with using the passwords, coming from a 3.23.x or 4.0.x > one. I don't remember the details, but it had something to do with > that... > > Any advice is more than welcome, as this is the moment for me to make > this sort of decicion, and I'd like to do so based on real user's > experiences...:) > > Thank you kindly in advance, and with kind regards, > Olaf Greve > _______________________________________________ > freebsd-amd64@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-amd64 > To unsubscribe, send any mail to "freebsd-amd64-unsubscribe@freebsd.org"