From owner-freebsd-questions@FreeBSD.ORG Fri Sep 30 13:22:36 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 1A82D16A420; Fri, 30 Sep 2005 13:22:36 +0000 (GMT) (envelope-from o.greve@axis.nl) Received: from yggdrasil.interstroom.nl (yggdrasil.interstroom.nl [80.85.129.11]) by mx1.FreeBSD.org (Postfix) with ESMTP id AB0B843D48; Fri, 30 Sep 2005 13:22:35 +0000 (GMT) (envelope-from o.greve@axis.nl) Received: from ip127-180.introweb.nl ([80.65.127.180] helo=[192.168.1.42]) by yggdrasil with asmtp (Exim 3.35 #1 (Debian)) id 1ELKqM-0003Ss-00; Fri, 30 Sep 2005 15:22:30 +0200 Message-ID: <433D3C12.6020104@axis.nl> Date: Fri, 30 Sep 2005 15:22:26 +0200 From: Olaf Greve User-Agent: Mozilla Thunderbird 1.0.6-1.4.1.centos4 (X11/20050721) X-Accept-Language: en-us, en MIME-Version: 1.0 To: amd64@FreeBSD.org, freebsd-questions@freebsd.org References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> In-Reply-To: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-MailScanner-Information: Interstroom virusscan, please e-mail helpdesk@interstroom.nl for more information X-MailScanner-SpamCheck: Cc: Subject: 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 List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 Sep 2005 13:22:36 -0000 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