Date: Tue, 4 Oct 2005 21:03:20 -0400 From: Nick Evans <nevans@talkpoint.com> To: 'Peter Wemm' <peter@wemm.org>, freebsd-amd64@freebsd.org Cc: Olaf Greve <o.greve@axis.nl>, freebsd-questions@freebsd.org Subject: RE: Which MySQL version best to use and with/without linux thread s? Message-ID: <294123FE9E76C34193EF7019BAAE4B2C124F36@postal.talkpoint.com>
next in thread | raw e-mail | index | archive | help
> -----Original Message----- > From: Peter Wemm [mailto:peter@wemm.org] > Sent: Tuesday, October 04, 2005 8:17 PM > To: freebsd-amd64@freebsd.org > Cc: Olaf Greve; amd64@freebsd.org; freebsd-questions@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@wemm.org; peter@FreeBSD.org; peter@yahoo-inc.com > "All of this is for nothing if we don't go to the stars" - JMS/B5 > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@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@. Nick
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?294123FE9E76C34193EF7019BAAE4B2C124F36>