Why is MySQL nearly twice as fast on Linux/AMD64 Vs.
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