From owner-freebsd-performance@FreeBSD.ORG Thu Oct 5 16:30:32 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 B245516A415 for ; Thu, 5 Oct 2006 16:30:32 +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 6D86A43D67 for ; Thu, 5 Oct 2006 16:30:04 +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 1GVHTn-0003OX-CU for freebsd-performance@freebsd.org; Wed, 04 Oct 2006 20:52:51 -0400 Received: from 71.56.92.181 (SquirrelMail authenticated user jbell@stelesys.com) by www.stelesys.com with HTTP; Wed, 4 Oct 2006 20:52:51 -0400 (EDT) Message-ID: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> Date: Wed, 4 Oct 2006 20:52:51 -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: 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 16:30:32 -0000 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 And this is about the best result I get: 2950# super-smack -d mysql select-key-mysql.smack 10 10000 Query Barrel Report for client smacker1 connect: max=200ms min=0ms avg= 20ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 34440.88 Are there any other optimizations I need to do to mysql or freebsd? I'm still not 100% convinced that I've done everything I need to use libthr instead of libpthread. I expected the 2950 to be a bit closer to the 1.8Ghz opteron discussed here: http://article.gmane.org/gmane.os.freebsd.performance/1137/match=mysql Realistically, there's probably a bit of a performance advantage in the opteron, but I wouldn't expect it to be that large. Thanks! Jerry