Re: FreeBSD MySQL still WAY slower than Linux

2005-06-29 Thread Bruce Evans
On Wed, 29 Jun 2005, Jeremie Le Hen wrote: Could you try mounting the filesystem where the database lives with the noatime option, and re-run your tests ? IIRC from previous threads on this subject, Linux doesn't really honor this while FreeBSD does, which pulls down the performances. I think

Re: FreeBSD MySQL still WAY slower than Linux

2005-06-29 Thread Nick Evans
I just tried this on my dual opteron test rig and didn't notice a difference in performance with noatime set. What did make a difference was moving from fxp to bge network cards. bge supports checksum offloading where fxp only supports interrupt bundling. Freed up another 20% idle during my test ru

Re: FreeBSD MySQL still WAY slower than Linux

2005-06-29 Thread David Sze
At 01:33 PM 29/06/2005 +0100, Robert Watson wrote this to All: On Thu, 23 Jun 2005, Steve Roome wrote: The different threading libraries are more for completeness. In my last test I saw <10% difference between them on amd64. Well, I finally got some tests out for FreeBSD/i386 with -current,

Re: FreeBSD MySQL still WAY slower than Linux

2005-06-29 Thread Robert Watson
On Thu, 23 Jun 2005, Steve Roome wrote: The different threading libraries are more for completeness. In my last test I saw <10% difference between them on amd64. Well, I finally got some tests out for FreeBSD/i386 with -current, Here we go with a bunch of results of FreeBSD 6 with mysql and

Re: FreeBSD MySQL still WAY slower than Linux

2005-06-29 Thread Jeremie Le Hen
Hi Michael, hi Steve, > For me this is as fast as I need my database to be but I can understand > there is a difference here between FreeBSD and Linux that would make you > prefer it as the db OS choice. Could you try mounting the filesystem where the database lives with the noatime option, and