From owner-freebsd-stable@FreeBSD.ORG Wed Mar 14 01:00:13 2007 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 7BE2116A402 for ; Wed, 14 Mar 2007 01:00:13 +0000 (UTC) (envelope-from killing@multiplay.co.uk) Received: from multiplay.co.uk (core6.multiplay.co.uk [85.236.96.23]) by mx1.freebsd.org (Postfix) with ESMTP id 0A62213C44B for ; Wed, 14 Mar 2007 01:00:12 +0000 (UTC) (envelope-from killing@multiplay.co.uk) X-Spam-Checker-Version: SpamAssassin 3.1.5 (2006-08-29) on core6.multiplay.co.uk X-Spam-Level: X-Spam-Status: No, score=-24.7 required=6.0 tests=BAYES_00, USER_IN_WHITELIST, USER_IN_WHITELIST_TO autolearn=ham version=3.1.5 Received: from vader ([212.135.219.179]) by multiplay.co.uk (multiplay.co.uk [85.236.96.23]) (MDaemon PRO v9.5.4) with ESMTP id md50003609973.msg for ; Wed, 14 Mar 2007 00:55:43 +0000 Message-ID: <009c01c765d3$759f0890$b3db87d4@multiplay.co.uk> From: "Steven Hartland" To: "Alban Hertroys" , "Kris Kennaway" References: <20070313154729.1ec6abb7@DELOREAN.manuelmartini.it><20070313194206.GA5957@crodrigues.org><20070313195756.GA11679@xor.obsecurity.org><20070313211908.59de6504@DELOREAN.manuelmartini.it><20070313214559.GB13079@xor.obsecurity.org> <330A1347-2309-417E-83B5-5B2CE005B9C8@solfertje.student.utwente.nl> Date: Wed, 14 Mar 2007 00:55:20 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-MDRemoteIP: 212.135.219.179 X-Return-Path: killing@multiplay.co.uk X-Envelope-From: killing@multiplay.co.uk X-MDaemon-Deliver-To: freebsd-stable@freebsd.org X-Spam-Processed: multiplay.co.uk, Wed, 14 Mar 2007 00:55:44 +0000 X-MDAV-Processed: multiplay.co.uk, Wed, 14 Mar 2007 00:55:44 +0000 Cc: Martin , freebsd-stable@freebsd.org Subject: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Mar 2007 01:00:13 -0000 Alban Hertroys wrote: > Sorry, couldn't resist... Being a troll? > This being mysql, the number of processors isn't going to matter > much, no matter how many connections you have. Mysql doesn't scale > very well to multiple cpu's. You seem to have been paying no attention at all to any of the mysql performance benchmarks and optimisation efforts that have being going on recently. > Not to say that PostgreSQL is the ultimate benchmark instead of > mysql, just a better one. Of course they both have their uses, but > IMO mysql is loosing terrain fast. Any benchmark which looks to closely emulate "real life work" is valid, just be because "you" dont use or like a particular product doesnt make it any less suitable for testing / benchmarking. I'm sure if you took a survey of how many people are using mysql vs PostgreSQL it would show that the former is much more popular DB. No this doesnt make it better but it does make it a more suitable candidate for performance work as the benefits will benefit more people and more systems. Obviously this doesnt mean that optimisations for DB X wont benefit DB Y, or other apps for that matter, as its likely they will. > [1] I really mean it doesn't compare. PostgreSQL provides more (and > IMHO better) features, and can be faster under the right > circumstances (usually complex queries or concurrent writes). It also > scales almost linearly to the number of cpu's, provided there are > enough simultaneous connections. It also has a "known" bottleneck to its performance on FreeBSD see earlier comments in other threads by Kris on this which clearly limits any benefit gained from using it as a benchmark. Steve ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337 or return the E.mail to postmaster@multiplay.co.uk.