Date: Thu, 05 Oct 2006 21:17:10 +0200 From: Miroslav Lachman <000.fbsd@quip.cz> To: Jerry Bell <jbell@stelesys.com> Cc: freebsd-performance@freebsd.org Subject: Re: Help with improving mysql performance on 6.2PRE Message-ID: <45255A36.5010108@quip.cz> In-Reply-To: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Jerry Bell wrote: > I have a Dell PE2950 with 2 dual core 3.73Ghz processors and 4G of ram. > I've looked through some of the lists here and have seen super-smack > results in the 42k qps range on a 2 dual core opteron system. I'm able to > get up to about 34k with the wide at the back of my server whilest rubbing > the side of it. > > Here's what I've done: > built both mysql 5.0 and 5.1 from ports with build_static and > optimazations on. > changed the clock to TSC > > added the following to my /etc/libmap.conf file: > [mysqld] > libc_r.so.5 libthr.so.2 > libc_r.so.6 libthr.so.2 > libthr.so.2 libthr.so.2 > libpthread.so.1 libthr.so.2 > libpthread.so.2 libthr.so.2 [...] As Nick Evans said, you can't use static version of MySQL daemon if you want to use /etc/libmap.conf I tested both (static vs. dynamic with libmap.conf), dynamic with libthr performs much better than static on Dual Xeon 3GHz SMP system with 2GB of RAM. My /etc/libmap.conf is just [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so Miroslav Lachman
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?45255A36.5010108>