From owner-freebsd-questions@FreeBSD.ORG Fri Sep 30 16:08:35 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 715B716A41F for ; Fri, 30 Sep 2005 16:08:35 +0000 (GMT) (envelope-from infofarmer@gmail.com) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id F218F43D49 for ; Fri, 30 Sep 2005 16:08:34 +0000 (GMT) (envelope-from infofarmer@gmail.com) Received: by zproxy.gmail.com with SMTP id z31so407011nzd for ; Fri, 30 Sep 2005 09:08:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hJu8GZqysE8TI9FDxN5C0tSu88xpJ1T5fq0+KFhVM/D6x9dBehhcs7jW2QBib6lcqEDbfBFcbC4U5rqxtRB/3zwGUKZRKoHLj7rDjq38nFRQwYr2XK1NS+Ka3+i0fxHjli16qCmXIDu+uGWMgU/3Ld2Xgg0FeX39B14aoljx1y0= Received: by 10.36.153.7 with SMTP id a7mr5675146nze; Fri, 30 Sep 2005 09:08:33 -0700 (PDT) Received: by 10.37.20.34 with HTTP; Fri, 30 Sep 2005 09:08:32 -0700 (PDT) Message-ID: Date: Fri, 30 Sep 2005 20:08:32 +0400 From: "Andrew P." To: Olaf Greve In-Reply-To: <433D3C12.6020104@axis.nl> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <433D3C12.6020104@axis.nl> Cc: freebsd-questions@freebsd.org 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: "Andrew P." List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 Sep 2005 16:08:35 -0000 On 9/30/05, 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-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" > I'm not a very experienced MySQL user, but in the absence of a better reply, here it goes. linuxthreads were only important on FreeBSD 4.x. Starting with 5.x we have a more efficient threading model. Extensive testing did not reveal any significant performance increase with MySQL compiled with linuxthreads on FreeBSD 5.x. You'd better forget about linuxthreads for good. 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. Cheerz, Andrew P.