Date: Tue, 27 Nov 2007 11:11:33 -0500 From: "Josh Carroll" <josh.carroll@gmail.com> To: "Ted Mittelstaedt" <tedm@toybox.placo.com> Cc: Albert.Shih@obspm.fr, freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Message-ID: <8cb6106e0711270811r706fa81di9fafa79acfd227a1@mail.gmail.com> In-Reply-To: <BMEDLGAENEKCJFGODFOCOECFCFAA.tedm@toybox.placo.com> References: <20071127130020.GA81551@pcjas.obspm.fr> <BMEDLGAENEKCJFGODFOCOECFCFAA.tedm@toybox.placo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> Is Hyperthreading enabled (by default it is not under > FreeBSD) mysql is heavily dependent on threading, if it is not > built and linked into the freebsd threads package you will get > poor performance. Some folks have installed the linux compat libs > and linked mysql into the linux threads package and reported good > results. Actually, on 6.2, it's better to use libthr instead of libpthread. This can be done for MySQL only, but to test this without recompiling MySQL, he can: % echo "libpthread.so.2 libthr.so.2" >> /etc/libmap.conf Then restart the mysql server and test again. I noticed a huge increase in performance on 6.2 with libthr instead of libpthread. It wasn't a 10x improvement, though, so there is definitely something else going on with his setup. Regards, Josh
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?8cb6106e0711270811r706fa81di9fafa79acfd227a1>