Date: Wed, 14 Mar 2007 09:31:24 +0100 From: Alban Hertroys <dalroi@solfertje.student.utwente.nl> To: Kris Kennaway <kris@obsecurity.org> Cc: Martin <list@manuelmartini.it>, freebsd-stable@freebsd.org Subject: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64 Message-ID: <41F2E11D-74C4-4901-8050-22B40F7011D4@solfertje.student.utwente.nl> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41F2E11D-74C4-4901-8050-22B40F7011D4>