From owner-freebsd-performance@FreeBSD.ORG Thu Oct 5 19:17:19 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CCCD916A403 for ; Thu, 5 Oct 2006 19:17:19 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from slimak.dkm.cz (slimak.dkm.cz [62.24.64.34]) by mx1.FreeBSD.org (Postfix) with SMTP id 182A343D62 for ; Thu, 5 Oct 2006 19:17:15 +0000 (GMT) (envelope-from 000.fbsd@quip.cz) Received: (qmail 48529 invoked by uid 0); 5 Oct 2006 19:17:10 -0000 Received: from grimm.quip.cz (HELO ?192.168.1.2?) (213.220.192.218) by slimak.dkm.cz with SMTP; 5 Oct 2006 19:17:10 -0000 Message-ID: <45255A36.5010108@quip.cz> Date: Thu, 05 Oct 2006 21:17:10 +0200 From: Miroslav Lachman <000.fbsd@quip.cz> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 X-Accept-Language: cz, en, cs, en-us MIME-Version: 1.0 To: Jerry Bell References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> In-Reply-To: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-performance@freebsd.org Subject: Re: Help with improving mysql performance on 6.2PRE X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Oct 2006 19:17:19 -0000 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