Date: Tue, 28 Jun 2005 07:59:12 +0200 From: Martin Nilsson <martin@gneto.com> To: Steve Roome <steve@pepcross.com> Cc: performance@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <42C0E730.5010703@gneto.com> In-Reply-To: <20050627134146.GA626@bibipentium.lonres.com> References: <20050623145041.GC64879@bibipentium.lonres.com> <42BD64F1.4080001@roq.com> <20050627134146.GA626@bibipentium.lonres.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Steve Roome wrote: > Sorry, good point, here's the my.cnf we're using. Please note however > that although the configuration may not be optimal, we have been using > the same config for benchmarking on Linux also. No matter how broken > this my.cnf is we still shouldn't find MySQL running half the speed on > an "identical" setups only switching from Linux to FreeBSD. Hi, Have you tested some more real-world queries on Linux vs. FreeBSD? The select-key.smack is a very simple test, a very small table (5.3MB on disk, 90k rows), no joins/sorts and only selects from index. Maybe the performance difference just affects the connect/communication/thread syncronistaion and thus this simple test is a worst case test of performance between Linux & FreeBSD. I'll try to set up something here so I can make some tests too... How does a P4/Xeon compare to Athlon64/Opteron on these tests (Linux vs FreeBSD) the long pipeline in the P4 (Prescott/Nocona) is difficult to optimize for, SMP syncronisation is also much more expensive on netburst, maybe the are better at doing this in Linux? Regards, Martin
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42C0E730.5010703>