You can view my benchmark here: https://manuelmartini.it/bench/mysql/ m. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 187 bytes Desc: not available Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20070313/78047438/signature.pgp
Ivan Voras
2007-Mar-13 19:32 UTC
FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64
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 :) -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 250 bytes Desc: OpenPGP digital signature Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20070313/5be30cac/signature.pgp
Craig Rodrigues
2007-Mar-13 19:42 UTC
FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64
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 your 6.2 configuration does not have WITNESS enabled, but your 7.0 configuration does. -- Craig Rodrigues rodrigc@crodrigues.org
Il giorno Tue, 13 Mar 2007 15:42:06 -0400 Craig Rodrigues <rodrigc@crodrigues.org> 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 tested? > It looks like your 6.2 configuration does not have > WITNESS enabled, but your 7.0 configuration does. >I use GENERIC kernel file for 6.2 and GENERIC on 7 and I removed WITNESS -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 187 bytes Desc: not available Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20070313/c10ca079/signature.pgp
Kris Kennaway
2007-Mar-13 21:40 UTC
FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64
On Tue, Mar 13, 2007 at 09:13:56PM +0100, Martin wrote:> Il giorno Tue, 13 Mar 2007 15:42:06 -0400 > Craig Rodrigues <rodrigc@crodrigues.org> 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 tested? > > It looks like your 6.2 configuration does not have > > WITNESS enabled, but your 7.0 configuration does. > > > > I use GENERIC kernel file for 6.2 > and GENERIC on 7 and I removed WITNESSHow about INVARIANTS? This has a 10-20% cost depending on workload. Kris -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 187 bytes Desc: not available Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20070313/7f9bec2e/attachment.pgp
Craig Rodrigues
2007-Mar-13 21:54 UTC
FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64
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 WITNESSYou 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 tests. Can you just publish the exact kernel config in the results table that you used, to make it easier to figure out your exact configuration, instead of guessing? -- Craig Rodrigues rodrigc@crodrigues.org