From owner-freebsd-amd64@FreeBSD.ORG Fri Sep 30 16:25:40 2005 Return-Path: X-Original-To: freebsd-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 42ACE16A41F for ; Fri, 30 Sep 2005 16:25:40 +0000 (GMT) (envelope-from fcash-ml@sd73.bc.ca) Received: from smtp.sd73.bc.ca (mailtest.sd73.bc.ca [142.24.13.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9FE5E43D53 for ; Fri, 30 Sep 2005 16:25:39 +0000 (GMT) (envelope-from fcash-ml@sd73.bc.ca) Received: from localhost (localhost [127.0.0.1]) by localhost.sd73.bc.ca (Postfix) with ESMTP id DD8B48A00DF for ; Fri, 30 Sep 2005 09:25:39 -0700 (PDT) Received: from smtp.sd73.bc.ca ([127.0.0.1]) by localhost (mailtest.sd73.bc.ca [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 37799-01-32 for ; Fri, 30 Sep 2005 09:25:38 -0700 (PDT) Received: from [192.168.0.9] (unknown [192.168.0.9]) by smtp.sd73.bc.ca (Postfix) with ESMTP id 44CBD8A0112 for ; Fri, 30 Sep 2005 09:25:34 -0700 (PDT) From: Freddie Cash Organization: School District 73 To: freebsd-amd64@freebsd.org Date: Fri, 30 Sep 2005 09:25:37 -0700 User-Agent: KMail/1.8.1 References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <433D3C12.6020104@axis.nl> In-Reply-To: <433D3C12.6020104@axis.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200509300925.38171.fcash-ml@sd73.bc.ca> X-Virus-Scanned: by amavisd-new using ClamAV at sd73.bc.ca 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: Fri, 30 Sep 2005 16:25:40 -0000 On September 30, 2005 06:22 am, Olaf Greve wrote: > 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? Scott Long and Kris Kenneway ran various benchmarks back in the early 5.x days comparing MySQL 4 compiled with LinuxThreads, libc_r, libkse (the default threading library on 5.x and 6.x), and libthr. In almost all cases, libkse was just as faster or faster than LinuxThreads. Short of doing your own benchmarks using your own data, it's safe to say you don't need to use LinuxThreads when compiling MySQL. > 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 ? MySQL 5.x hasn't even hit beta yet, you definitely don't want to be using it on a production system. :) I've seen some reports where 4.1.x is a lot faster than 4.0.x, and other reports where 4.1.x is a lot slower than 4.0.x. Basically it comes down to "do you need any of the features in 4.1 that are not in 4.0". -- Freddie Cash, CCNT CCLP Helpdesk / Network Support Tech. School District 73 (250) 377-HELP [377-4357] fcash-ml@sd73.bc.ca