libpthread vs libthread, simply mysql benchmark

[Robert Watson]

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