Which MySQL version best to use and with/without linux thread s?

[Nick Evans]

> -----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
> threads?
> 
> 
> 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
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> 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 .

Nick