Which MySQL version best to use and with/without linux thread s?
nevans at talkpoint.com
Tue Oct 4 18:03:27 PDT 2005
> -----Original Message-----
> From: Peter Wemm [mailto:peter at wemm.org]
> Sent: Tuesday, October 04, 2005 8:17 PM
> To: freebsd-amd64 at freebsd.org
> Cc: Olaf Greve; amd64 at freebsd.org; freebsd-questions at freebsd.org
> Subject: Re: Which MySQL version best to use and with/without linux
> On Friday 30 September 2005 06:22 am, Olaf Greve wrote:
> Then, I'm currently configuring a second beast, eehhhh, server. :)
> Being an AMD-64 19" server, running FreeBSD 5.4-Release AMD64. On it,
> I instinctively installed the latest MySQL 4.0.x version (being
> 4.0.26) and it works flawlessly with the data from my current
> production machine.
> The only problem is that linuxthreads doesn't exist on FreeBSD/amd64.
> You have to use one of the native thread libraries.
> Your choices on 5.4 are not that great. I'd suggest libthr on 6.0 as
> the closest match to linuxthreads, but I don't recall if it is
> available on 5.4. I have a feeling it isn't. I have a feeling your
> choices are libc_r or libpthread (kse). libpthread should smoke libc_r
> for disk IO performance in general. But modern libthr (on 6.0+) should
> give it a serious run for its money.
> 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
> freebsd-questions at freebsd.org mailing list
> To unsubscribe, send any mail to
"freebsd-questions-unsubscribe at freebsd.org"
I've been benchmarking this on a dual opteron 246 server. mysql 4.1.x and
libthr worked on 5.4, but 6.0 was faster and libthr was definitely faster
than pthreads. There's a thread about this on performance at .
More information about the freebsd-questions