Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64?

JG amd64list at jpgsworld.com
Tue May 18 17:06:23 PDT 2004

At 01:59 PM 5/18/2004 -0700, you wrote:
>On Tuesday 18 May 2004 10:36 am, JG wrote:
> > MySQL Statically compiled with libc_r
>                                                              ^^^^^
>That's your killer.  You're using the the single-process polling loop
>based threads and comparing it to linux's parallel process based
>threads.  The moment one thread blocks on disk IO, everything stops.
>You want -lpthread instead, but this isn't going to be happy on
>5.2.1-RELEASE.  I've fixed a lot of bugs in 5-current that would mean
>the difference between it working versus crashing.
>Also, there are patches to change MySQL to use PTHREAD_SCOPE_PROCESS
>threads with -lpthread.  This works out a little better on benchmarks
>since it can make better use of the ligher weight context switches.
>Peter Wemm - peter at wemm.org; peter at FreeBSD.org; peter at yahoo-inc.com
>"All of this is for nothing if we don't go to the stars" - JMS/B5

Yes I'll definitely try this next.

Thanks to everyone for all the tips & suggestions.

I'll post some updated results tomorrow sometime.

More information about the freebsd-amd64 mailing list