Date: Tue, 27 Nov 2007 08:29:28 -0800 From: "Michael K. Smith - Adhost" <mksmith@adhost.com> To: <Albert.Shih@obspm.fr>, <freebsd-questions@freebsd.org> Subject: RE: Help for very bad perf for MySQL Message-ID: <17838240D9A5544AAA5FF95F8D52031602E53B14@ad-exh01.adhost.lan> In-Reply-To: <8cb6106e0711270811r706fa81di9fafa79acfd227a1@mail.gmail.com> References: <20071127130020.GA81551@pcjas.obspm.fr><BMEDLGAENEKCJFGODFOCOECFCFAA.tedm@toybox.placo.com> <8cb6106e0711270811r706fa81di9fafa79acfd227a1@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> -----Original Message----- > From: owner-freebsd-questions@freebsd.org [mailto:owner-freebsd- > questions@freebsd.org] On Behalf Of Josh Carroll > Sent: Tuesday, November 27, 2007 8:12 AM > To: Ted Mittelstaedt > Cc: Albert.Shih@obspm.fr; freebsd-questions@freebsd.org > Subject: Re: Help for very bad perf for MySQL >=20 > > 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. >=20 > 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: >=20 > % echo "libpthread.so.2 libthr.so.2" >> /etc/libmap.conf >=20 > 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. >=20 > Regards, > Josh Here are some things that helped us on a high-volume MySQL server. -- /etc/sysctl.conf -- (these can be added dynamically from the command line) kern.threads.max_groups_per_proc=3D40000 kern.threads.max_threads_per_proc=3D40000 kern.maxfiles=3D65535 kern.maxfilesperproc=3D65535 -- /boot/loader.conf -- (You'll have to reboot for these to take effect) kern.maxdsiz=3D"1073741824" # 1GB kern.dfldsiz=3D"1073741824" # 1GB kern.maxssiz=3D"134217728" # 128MB -- /etc/libmap.conf -- (as Josh said) [mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so Regards, Mike
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?17838240D9A5544AAA5FF95F8D52031602E53B14>