[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: FreeBSD MySQL still WAY slower than Linux
- To: Robert Watson <rwatson_(_at_)_freebsd_(_dot_)_org>
- Subject: Re: FreeBSD MySQL still WAY slower than Linux
- From: David Sze <dsze_(_at_)_alumni_(_dot_)_uwaterloo_(_dot_)_ca>
- Date: Wed, 29 Jun 2005 09:58:39 -0400
- Cc: Steve Roome <steve_(_at_)_pepcross_(_dot_)_com>, performance_(_at_)_freebsd_(_dot_)_org
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, Here
we go with a bunch of results of FreeBSD 6 with mysql and different
threading libraries, as for you, there's sadly not enough in it so far.
Maybe I need to tune a whole bunch of stuff I've missed ?
What version of MySQL are you using? I saw much better FreeBSD MySQL
performance with 4.0.x than 4.1.x in terms of transactions per second, and
am wondering what changed in MySQL -- did it start using different IPC
primitives, threading primitives, etc? I realize it complicates testing,
but if you have a chance to compare 4.0.x and 4.1.x across linux and
freebsd, that would be quite helpful, so we can see if there's a change in
relative performance. Most of my work to optimize MySQL performance with
SMP has been using 4.0.x, FYI, so 4.1.x might require different
I haven't got around to finishing all the benchmarks yet, but on
5.4-RELEASE-p2 amd64, I see about 5-7% better performance with 4.0.x versus
4.1.x for the select-key benchmark, and no improvement for update-select
(both with InnoDB tables, using the "my-innodb-heavy-4G.cnf" file).
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