From owner-freebsd-performance@FreeBSD.ORG Thu Oct 5 23:24:06 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 3DEFE16A407 for ; Thu, 5 Oct 2006 23:24:06 +0000 (UTC) (envelope-from jbell@stelesys.com) Received: from stelesys.com (web3.stelesys.com [63.175.100.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id D77C043D45 for ; Thu, 5 Oct 2006 23:24:05 +0000 (GMT) (envelope-from jbell@stelesys.com) Received: from [127.0.0.1] (helo=www.stelesys.com) by stelesys.com with esmtpa (Exim 4.63 (FreeBSD)) (envelope-from ) id 1GVcZQ-000Hh7-QB for freebsd-performance@freebsd.org; Thu, 05 Oct 2006 19:24:04 -0400 Received: from 71.56.92.181 (SquirrelMail authenticated user jbell@stelesys.com) by www.stelesys.com with HTTP; Thu, 5 Oct 2006 19:24:04 -0400 (EDT) Message-ID: <2840.71.56.92.181.1160090644.squirrel@www.stelesys.com> In-Reply-To: <45255A36.5010108@quip.cz> References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> <45255A36.5010108@quip.cz> Date: Thu, 5 Oct 2006 19:24:04 -0400 (EDT) From: "Jerry Bell" To: freebsd-performance@freebsd.org User-Agent: SquirrelMail/1.4.6-rc1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal 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 23:24:06 -0000 Many thanks to all who responded. You are an incredibly smart group of people. The recompiling without static yielded much better results: 2950# super-smack -d mysql select-key-mysql.smack 10 10000 Query Barrel Report for client smacker1 connect: max=1ms min=0ms avg= 0ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 51118.22 >From ~34k qps to ~51k qps is quite an improvement! I always thougt that compiling something static increased performance, but then that's probably true for things that have to startup and shutdown frequently. Thanks again. Jerry > 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 > _______________________________________________ > freebsd-performance@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-performance > To unsubscribe, send any mail to > "freebsd-performance-unsubscribe@freebsd.org" >