mysql - linuxthreads

Romeo Theriault romeotheriault at
Fri Jan 27 12:15:13 PST 2006

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: 

Hopefully this helps someone else out.


More information about the freebsd-questions mailing list