libpthread vs libthread, simply mysql benchmark
rwatson at FreeBSD.org
Sat Feb 19 08:53:14 PST 2005
On Sat, 19 Feb 2005, Bosko Milekic wrote:
> > As of today, I get about 8400tps with HTT turned on, probably a bit
> > betterwith it turned off. By combining various factors we've introduced
> > in the last couple of years, such as MPSAFE network stack, scheduling
> > improvements, threading improvements, mutex changes, etc, we've improved
> > performance on mysql by over 100% on SMP, going from quite sub-par
> > performance in the depths of 5.x development (when all the infrastructure
> > changes were going in but no optimizations) to quite healthy in 6.x,
> > especially with the new threading library.
> For reference, do you have numbers from RELENG_4?
Unfortunately, not for this box. I hope to get a chance to run the tests
against a handy dual PIII with 4.x, 5.x, and 6.x in the next couple of
days. Just as an FYI to those wanting to give this a spin -- to test with
libthread on 6.x, you'll need a copy of MySQL linked against libc.so.6 so
it can get to the _umtx_op symbol, which is not currently present in a 5.x
libc. This basically translates to meaning: you'll need a package/port of
MySQL built against 6.x to test with libthread. The package on
ftp.FreeBSD.org worked fine for me.
Robert N M Watson
More information about the freebsd-performance