[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: FreeBSD MySQL still WAY slower than Linux
- To: Jeremie Le Hen <jeremie_(_at_)_le-hen_(_dot_)_org>
- Subject: Re: FreeBSD MySQL still WAY slower than Linux
- From: Nick Evans <nevans_(_at_)_talkpoint_(_dot_)_com>
- Date: Wed, 29 Jun 2005 17:00:44 -0400
- Cc: Michael Vince <mv_(_at_)_roq_(_dot_)_com>, Steve Roome <steve_(_at_)_pepcross_(_dot_)_com>, performance_(_at_)_freebsd_(_dot_)_org
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 runs.
I'm now hitting ~23,000 selects/sec, ~42% idle when running select-key.smack
from 3 client hosts. If we establish a suitable test mix and distribute the
smack/data files at least we can get consistent test results across systems.
6-CURRENT as of Jun 27th
Dual Opteron 246
Tyan K8SD Thunder Pro
my-huge.cnf with tweaks.
On Wed, 29 Jun 2005 11:45:33 +0200
Jeremie Le Hen <jeremie_(_at_)_le-hen_(_dot_)_org> wrote:
> 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 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.
> Jeremie Le Hen
> < jeremie at le-hen dot org >< ttz at chchile dot org >
> freebsd-performance_(_at_)_freebsd_(_dot_)_org mailing list
> To unsubscribe, send any mail to "freebsd-performance-
freebsd-performance_(_at_)_freebsd_(_dot_)_org mailing list
To unsubscribe, send any mail to "freebsd-performance-unsubscribe_(_at_)_freebsd_(_dot_)_org"
Visit your host, monkey.org