From owner-freebsd-performance@FreeBSD.ORG Fri Oct 6 07:57:42 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 D273E16A407 for ; Fri, 6 Oct 2006 07:57:42 +0000 (UTC) (envelope-from xdivac02@stud.fit.vutbr.cz) Received: from eva.fit.vutbr.cz (eva.fit.vutbr.cz [147.229.176.14]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3A3D543D46 for ; Fri, 6 Oct 2006 07:57:41 +0000 (GMT) (envelope-from xdivac02@stud.fit.vutbr.cz) Received: from eva.fit.vutbr.cz (localhost [127.0.0.1]) by eva.fit.vutbr.cz (envelope-from xdivac02@eva.fit.vutbr.cz) (8.13.8/8.13.7) with ESMTP id k967vcdV064935 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 6 Oct 2006 09:57:38 +0200 (CEST) Received: (from xdivac02@localhost) by eva.fit.vutbr.cz (8.13.8/8.13.3/Submit) id k967vcEF064934; Fri, 6 Oct 2006 09:57:38 +0200 (CEST) Date: Fri, 6 Oct 2006 09:57:38 +0200 From: Divacky Roman To: Jerry Bell Message-ID: <20061006075738.GA64854@stud.fit.vutbr.cz> References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> User-Agent: Mutt/1.4.2.2i X-Scanned-By: MIMEDefang 2.57 on 147.229.176.14 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: Fri, 06 Oct 2006 07:57:42 -0000 On Wed, Oct 04, 2006 at 08:52:51PM -0400, 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 > > 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. on UP people recomend to use TSC instead of acpi timer