mysql - linuxthreads

[Romeo Theriault]

A week or so ago I wrote to the this list asking about Freebsd and  
Mysql, wondering if you still needed to compile Mysql with  
linuxthreads to get better performance under Freebsd 6. I didn't get  
much of a response so I looked around for the answer. I thought I'd  
write back to the mailing list to tell anyone interested what I found.

In the Freebsd 6.0 is seems that to get the best MySQL performance  
you need to do a few things.
	#compile your kernel with the ULE scheduler
	#use the TSC timecounter
	#use the libthr threading library with mysql
	#and it seems mysql 4.x has better performance than 5.x under  
Freebsd 6.

Here are some websites that I found useful with this:
http://wikitest.freebsd.org/moin.cgi/MySQL
http://www.unixguide.net/freebsd/faq/05.26.shtml
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2005-12/ 
msg00078.html
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2005-12/ 
msg00084.html
http://lists.freebsd.org/pipermail/freebsd-performance/2005-December/ 
001677.html
http://taosecurity.blogspot.com/2005/11/problems-with-freebsd-6.html
http://blog.gslin.org/archives/2005/12/12/252/

Hopefully this helps someone else out.

Romeo