Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-14 Thread Alban Hertroys
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:

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-14 Thread Alban Hertroys
On Mar 14, 2007, at 1:55, Steven Hartland wrote: Alban Hertroys wrote: Sorry, couldn't resist... Being a troll? I don't troll, I'm not like that. I have a problem with how mysql often gets falsely marketed as the fastest database. The subject just pushed the right buttons, sorry about

FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Martin
You can view my benchmark here: https://manuelmartini.it/bench/mysql/ m. signature.asc Description: PGP signature

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Ivan Voras
Martin wrote: You can view my benchmark here: https://manuelmartini.it/bench/mysql/ Interesting results. The performance improvements talked about at http://jeffr-tech.livejournal.com/6268.html#cutid1 are not yet included in 7-current so the results might improve :) signature.asc

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Kris Kennaway
On Tue, Mar 13, 2007 at 03:42:06PM -0400, Craig Rodrigues wrote: On Tue, Mar 13, 2007 at 03:47:29PM +0100, Martin wrote: You can view my benchmark here: https://manuelmartini.it/bench/mysql/ Can you add links your kernel config file for each configuration you tested? It looks like

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Martin
Il giorno Tue, 13 Mar 2007 15:42:06 -0400 Craig Rodrigues [EMAIL PROTECTED] ha scritto: On Tue, Mar 13, 2007 at 03:47:29PM +0100, Martin wrote: You can view my benchmark here: https://manuelmartini.it/bench/mysql/ Can you add links your kernel config file for each configuration you

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Martin
Il giorno Tue, 13 Mar 2007 15:57:57 -0400 Kris Kennaway [EMAIL PROTECTED] ha scritto: On Tue, Mar 13, 2007 at 03:42:06PM -0400, Craig Rodrigues wrote: On Tue, Mar 13, 2007 at 03:47:29PM +0100, Martin wrote: You can view my benchmark here: https://manuelmartini.it/bench/mysql/

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Kris Kennaway
On Tue, Mar 13, 2007 at 09:13:56PM +0100, Martin wrote: Il giorno Tue, 13 Mar 2007 15:42:06 -0400 Craig Rodrigues [EMAIL PROTECTED] ha scritto: On Tue, Mar 13, 2007 at 03:47:29PM +0100, Martin wrote: You can view my benchmark here: https://manuelmartini.it/bench/mysql/ Can you

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Kris Kennaway
On Tue, Mar 13, 2007 at 09:19:08PM +0100, Martin wrote: Also some more discussion would be useful, e.g. you appear to be testing on different machines so the most important thing to understand is how, or whether, the hardware differs. You do link to the dmesgs, but it's hard to process

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Craig Rodrigues
On Tue, Mar 13, 2007 at 09:13:56PM +0100, Martin wrote: I use GENERIC kernel file for 6.2 and GENERIC on 7 and I removed WITNESS You did not remove WITNESS in all your configs. I see this message: WARNING: WITNESS option enabled, expect reduced performance. in the dmesg output of two of your

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Alban Hertroys
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

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Kris Kennaway
On Wed, Mar 14, 2007 at 01:27:22AM +0100, Alban Hertroys wrote: 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

Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64

2007-03-13 Thread Steven Hartland
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