From owner-freebsd-performance@FreeBSD.ORG Thu Oct 5 17:29:29 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 D834B16A412 for ; Thu, 5 Oct 2006 17:29:29 +0000 (UTC) (envelope-from freebsd@lidstrom.eu) Received: from pne-smtpout1-sn2.hy.skanova.net (pne-smtpout1-sn2.hy.skanova.net [81.228.8.83]) by mx1.FreeBSD.org (Postfix) with ESMTP id E6EA043DC7 for ; Thu, 5 Oct 2006 17:28:07 +0000 (GMT) (envelope-from freebsd@lidstrom.eu) Received: from mailgw.henriklidstrom.se (83.250.106.220) by pne-smtpout1-sn2.hy.skanova.net (7.2.075) id 4516FC41002F58EC; Thu, 5 Oct 2006 19:28:04 +0200 Received: from localhost (localhost.henriklidstrom.se [127.0.0.1]) by mailgw.henriklidstrom.se (Postfix) with ESMTP id 71DA1B831; Thu, 5 Oct 2006 19:27:57 +0200 (CEST) Received: from mailgw.henriklidstrom.se ([127.0.0.1]) by localhost (mailgw.henriklidstrom.se [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 34385-07; Thu, 5 Oct 2006 19:27:52 +0200 (CEST) Received: from [192.168.0.2] (henkezan.henriklidstrom.se [192.168.0.2]) by mailgw.henriklidstrom.se (Postfix) with ESMTP id DE4A5B821; Thu, 5 Oct 2006 19:27:52 +0200 (CEST) Message-ID: <452540A0.3060602@lidstrom.eu> Date: Thu, 05 Oct 2006 19:28:00 +0200 From: =?ISO-8859-1?Q?Henrik_Lidstr=F6m?= User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) 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=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at henriklidstrom.se 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 17:29:29 -0000 Jerry Bell skrev: > 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. > > Isn't the disk subsystem of relevance here? Whats your setup? /Henrik