From owner-freebsd-stable@FreeBSD.ORG Wed Mar 14 00:27:26 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 D2A9E16A401 for ; Wed, 14 Mar 2007 00:27:26 +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 5E64C13C44C for ; Wed, 14 Mar 2007 00:27:26 +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 464278034 for ; Wed, 14 Mar 2007 01:26:57 +0100 (CET) Received: from [10.236.150.4] (hollewijn.internal [10.236.150.4]) by solfertje.student.utwente.nl (Postfix) with ESMTP id 750CE8033; Wed, 14 Mar 2007 01:26:55 +0100 (CET) In-Reply-To: <20070313214559.GB13079@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> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <330A1347-2309-417E-83B5-5B2CE005B9C8@solfertje.student.utwente.nl> Content-Transfer-Encoding: 7bit From: Alban Hertroys Date: Wed, 14 Mar 2007 01:27:22 +0100 To: Kris Kennaway X-Mailer: Apple Mail (2.752.2) X-DSPAM-Result: Innocent X-DSPAM-Processed: Wed Mar 14 01:26:56 2007 X-DSPAM-Confidence: 0.9899 X-DSPAM-Probability: 0.0000 X-DSPAM-Signature: 74,45f741509413780612645 X-DSPAM-Factors: 27, but, 0.01000, From*Alban, 0.01000, just, 0.01000, Mime-Version*Message, 0.01000, or, 0.01000, or, 0.01000, from, 0.01000, of, 0.01000, of, 0.01000, Received*ESMTP, 0.01000, no, 0.01000, 22, 0.01000, Alban+Hertroys, 0.01000, Mime-Version*framework+v752.2), 0.01000, Mime-Version*1.0+(Apple, 0.01000, that, 0.01000, that, 0.01000, Hertroys, 0.01000, Content-Type*charset=US+ASCII, 0.01000, as, 0.01000, From*Hertroys, 0.01000, From*solfertje.student.utwente.nl>, 0.01000, Date*2007, 0.01000, had, 0.01000, Received*with, 0.01000, be, 0.01000, be, 0.01000 Cc: freebsd-stable@freebsd.org, Martin 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 00:27:26 -0000 On Mar 13, 2007, at 22:45, Kris Kennaway wrote: >> I used sql-bench >> /usr/ports/databases/mysql50-server/work/mysql-5.0.33/sql-bench/ >> (at this time) >> the default Makefile of port have "--without-bench" options so u >> need >> to make manually > > Hmm. This seems to be a single-user test, so while it's presumably > testing some relevant basic ingredients of database performance it's > probably not a realistic measure of server performance. i.e. if you > really only have a maximum of one client accessing your database then > your 4-core system is being more than 75% wasted :) Sorry, couldn't resist... 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. I've had my doubts about this "benchmark" from the beginning of this thread, I don't see the point of benchmarks using mysql - especially if it's not even clear whether myIsam or Innodb was used. If this benchmark means anything, I'm sure there are benchmarks that better suit the purpose (with the exception of benchmarking mysql performance for a single connection). What are we actually trying to benchmark here? In my experience mysql as a database accepts invalid data, doesn't comply to the SQL standards much and isn't very fast at real-life database queries - among other things. It doesn't compare[1] to a tuned PostgreSQL database, which I think is a considerably more interesting benchmark. And of course that would include multiple simultaneous connections. 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. [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. -- Alban Hertroys Priest to alien: "We want to know, is there a higher being?". Alien: "Well, actually that's why we're here, we're sheer out of virgins". !DSPAM:74,45f741509413780612645!