From owner-freebsd-performance@FreeBSD.ORG Fri Oct 6 13:16: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 80C8416A417 for ; Fri, 6 Oct 2006 13:16:32 +0000 (UTC) (envelope-from Alexander@Leidinger.net) Received: from www.ebusiness-leidinger.de (jojo.ms-net.de [84.16.236.246]) by mx1.FreeBSD.org (Postfix) with ESMTP id A860843D46 for ; Fri, 6 Oct 2006 13:16:31 +0000 (GMT) (envelope-from Alexander@Leidinger.net) Received: from Andro-Beta.Leidinger.net (p54A5F0B9.dip.t-dialin.net [84.165.240.185]) (authenticated bits=0) by www.ebusiness-leidinger.de (8.13.6/8.13.6) with ESMTP id k96DFHd2073724; Fri, 6 Oct 2006 15:15:18 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from localhost (webmail.Leidinger.net [192.168.1.102]) by Andro-Beta.Leidinger.net (8.13.4/8.13.4) with ESMTP id k96DGS6F025143; Fri, 6 Oct 2006 15:16:28 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from pslux.cec.eu.int (pslux.cec.eu.int [158.169.9.14]) by webmail.leidinger.net (Horde MIME library) with HTTP; Fri, 06 Oct 2006 15:16:28 +0200 Message-ID: <20061006151628.egmzstaiqsw48kk8@webmail.leidinger.net> X-Priority: 3 (Normal) Date: Fri, 06 Oct 2006 15:16:28 +0200 From: Alexander Leidinger To: Divacky Roman References: <3731.71.56.92.181.1160009571.squirrel@www.stelesys.com> <20061006075738.GA64854@stud.fit.vutbr.cz> In-Reply-To: <20061006075738.GA64854@stud.fit.vutbr.cz> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: Internet Messaging Program (IMP) H3 (4.1.3) / FreeBSD-7.0 X-Virus-Scanned: by amavisd-new Cc: freebsd-performance@freebsd.org, Jerry Bell 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 13:16:32 -0000 Quoting Divacky Roman (from Fri, 6 Oct =20 2006 09:57:38 +0200): > 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 t= o >> get up to about 34k with the wide at the back of my server whilest rubbin= g >> 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=3D200ms min=3D0ms avg=3D 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 He uses the TSC already... but nobody suggested the gettimeofday() =20 wrapper so far: http://wiki.freebsd.org/MySQL Bye, Alexander. --=20 Success is the sole earthly judge of right and wrong. =09=09-- Adolf Hitler, "Mein Kampf" http://www.Leidinger.net Alexander @ Leidinger.net: PGP ID =3D B0063FE7 http://www.FreeBSD.org netchild @ FreeBSD.org : PGP ID =3D 72077137