From owner-freebsd-questions@FreeBSD.ORG Wed Nov 25 22:41:54 2009 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 163D7106566C for ; Wed, 25 Nov 2009 22:41:54 +0000 (UTC) (envelope-from kline@thought.org) Received: from aristotle.thought.org (ns1.thought.org [209.180.213.210]) by mx1.freebsd.org (Postfix) with ESMTP id AA3FF8FC16 for ; Wed, 25 Nov 2009 22:41:52 +0000 (UTC) Received: from thought.org (tao.thought.org [10.47.0.250]) (authenticated bits=0) by aristotle.thought.org (8.14.2/8.14.2) with ESMTP id nAPMfQqI031588; Wed, 25 Nov 2009 14:41:26 -0800 (PST) (envelope-from kline@thought.org) Received: by thought.org (nbSMTP-1.00) for uid 1002 kline@thought.org; Wed, 25 Nov 2009 14:41:47 -0800 (PST) Date: Wed, 25 Nov 2009 14:41:47 -0800 From: Gary Kline To: Michael Powell Message-ID: <20091125224147.GB58848@thought.org> References: <20091125185704.GA58709@thought.org> <4B0D8299.6080201@infracaninophile.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.3i X-Organization: Thought Unlimited. Public service Unix since 1986. X-Of_Interest: With 23 years of service to the Unix community. X-Spam-Status: No, score=-4.4 required=3.6 tests=ALL_TRUSTED,BAYES_00 autolearn=ham version=3.2.3 X-Spam-Checker-Version: SpamAssassin 3.2.3 (2007-08-08) on aristotle.thought.org Cc: freebsd-questions@freebsd.org Subject: Re: mysql60-server?? 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: Wed, 25 Nov 2009 22:41:54 -0000 On Wed, Nov 25, 2009 at 02:33:11PM -0500, Michael Powell wrote: > Matthew Seaman wrote: > > > Gary Kline wrote: > >> kwik one: > >> > >> in his build-server stuff [6.2], jon horne said to use > >> mysql50-server. i see the latest is mysql60.... > >> > >> should i go ahead and use the latest mysql database? or just do as the > >> > >> instruction say? > [snip] > > > > Prior to that we have: > > > > mysql51 -- MySQL's current GA (generally available) release offering. It's > > got a number of new features like stored procedures but > > depending on your workloads it may or may not be faster than... > > > > mysql50 -- The previous GA version, and still the most widely deployed > > version at > > the moment. It is still being actively maintained even if it > > is pretty > > much down-played on MySQL's website. This is a version that > > has been in all sorts of production use for years and pretty > > thoroughly debugged, hence a very safe choice. > > > > In summary: choose either of mysql50 or mysql51 according to preference or > > your particular requirements. > > > > A lot of people are still using 50 and many consider it faster than 51. I > think the main difference performance wise is 51 might have a tad heavier > thread handling performance for the latest and greatest high end quad socket > quad core boxen. 50 may offer better performance on older more down level > commodity boxen. I've been running 51 for a quite a while now and haven't > had any trouble with it, but I'm not hammering it either. If the hardware > isn't quite up to snuff 50 may actually be a better choice, especially in > the scenario where web and database are running on the same, albeit slower > machine. Another factor in the decision might be to consider when EOL may be > scheduled. > > -Mike > > good to know. thanks for the input! gary > -- Gary Kline kline@thought.org http://www.thought.org Public Service Unix "Misfortune doesn't improve anyone. That is a fable to reassure the afflicted. A life of hardship humiliates man and forces him to expend all his energy on resisting its deadly pressure. If a man comes out of it improved, it only means that he has spent an enormous amount of energy on improving in spite of everything. Just think what he might have done without that pressure." --Jiri Mucha, *Living and Partly Living*