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>
index | next in thread | previous in thread | raw e-mail
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, Martinhome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42C0E730.5010703>