Date: Fri, 27 Jan 2006 15:15:05 -0500 From: Romeo Theriault <romeotheriault@gmail.com> To: freebsd-questions@freebsd.org Subject: mysql - linuxthreads Message-ID: <DD408EDB-CC70-47BC-A8A9-3B0CE21596AD@gmail.com>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?DD408EDB-CC70-47BC-A8A9-3B0CE21596AD>