From owner-freebsd-stable@FreeBSD.ORG Wed Mar 14 08:31:28 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 D4B4016A404 for ; Wed, 14 Mar 2007 08:31:28 +0000 (UTC) (envelope-from dalroi@solfertje.student.utwente.nl) Received: from solfertje.student.utwente.nl (solfertje.student.utwente.nl [130.89.167.40]) by mx1.freebsd.org (Postfix) with ESMTP id 8EE6813C458 for ; Wed, 14 Mar 2007 08:31:28 +0000 (UTC) (envelope-from dalroi@solfertje.student.utwente.nl) Received: from localhost (localhost.internal [127.0.0.1]) by solfertje.student.utwente.nl (Postfix) with SMTP id B44B18034 for ; Wed, 14 Mar 2007 09:30:58 +0100 (CET) Received: from [10.236.150.4] (hollewijn.internal [10.236.150.4]) by solfertje.student.utwente.nl (Postfix) with ESMTP id B679B8033; Wed, 14 Mar 2007 09:30:57 +0100 (CET) In-Reply-To: <20070314005546.GA15742@xor.obsecurity.org> 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> <20070314005546.GA15742@xor.obsecurity.org> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <41F2E11D-74C4-4901-8050-22B40F7011D4@solfertje.student.utwente.nl> Content-Transfer-Encoding: 7bit From: Alban Hertroys Date: Wed, 14 Mar 2007 09:31:24 +0100 To: Kris Kennaway X-Mailer: Apple Mail (2.752.2) X-DSPAM-Result: Innocent X-DSPAM-Processed: Wed Mar 14 09:30:58 2007 X-DSPAM-Confidence: 0.9899 X-DSPAM-Probability: 0.0000 X-DSPAM-Signature: 74,45f7b2c29417620521737 X-DSPAM-Factors: 27, but, 0.01000, but, 0.01000, From*Alban, 0.01000, Mime-Version*Message, 0.01000, or, 0.01000, an, 0.01000, of, 0.01000, Received*ESMTP, 0.01000, no, 0.01000, no, 0.01000, Hertroys+"If, 0.01000, Alban+Hertroys, 0.01000, Mime-Version*framework+v752.2), 0.01000, Mime-Version*1.0+(Apple, 0.01000, that, 0.01000, Hertroys, 0.01000, Content-Type*charset=US+ASCII, 0.01000, From*Hertroys, 0.01000, From*solfertje.student.utwente.nl>, 0.01000, in, 0.01000, in, 0.01000, Date*2007, 0.01000, Received*with, 0.01000, be, 0.01000, be, 0.01000, Date*31, 0.01000, Content-Type*delsp=yes, 0.01000 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 08:31:28 -0000 On Mar 14, 2007, at 1:55, Kris Kennaway wrote: >> 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. > > This might be standard dogma, but it also appears not to be true: > > http://people.freebsd.org/~kris/scaling/mysql.html Interesting. Results I have seen using a 16 CPU SGI Altex(?) showed an almost linear rise for postgres while mysql topped off after about 4 threads. Sorry, don't have the URL at hand (I probably still have it in my work mail). Now this may well have been a version before 5.0.33. I'm not sure what OS was used either, I suppose it was either Irix or Linux. Now I am curious whether the same performance drop on Linux would occur with a postgres benchmark. It probably will, but if not it seems like there's a problem in the way that mysql and linux interact. -- Alban Hertroys "If you can't see the forest through the trees, cut the trees and you'll see there is no forest" !DSPAM:74,45f7b2c29417620521737!