Why is MySQL nearly twice as fast on Linux?

[Daniel Eischen]

On Fri, 21 May 2004, JG wrote:
> >You can also build mysql with LinuxThreads under FreeBSD
> >and see if it performs any better.
> 
> LinuxThreads is not available for FreeBSD/AMD64.
> 
> However, as reported on the freebsd-amd64 thread list archive,
> sadly, the best configuration turned out to be running this 64-bit AMD64
> hardware in 32-bit mode under _i386_ FreeBSD rather than FreeBSD/AMD64
> with mysql compiled with linuxthreads -- and those results were still very poor
> compared to a "out of the box" Linux + mysql install.
> 
> >   If it is comparable,
> >that would tend to point to the kernel as the limiting
> >factor.
> 
> There is a significant improvement when using LinuxThreads vs
> libpthreads or libc_r, others have reported no difference with libthr
> as well.  

Can you point to the results (same hardware, native linux vs
libpthread vs linuxthreads)?  There is too much volume on
amd64 to go searching.

-- 
Dan Eischen