From owner-freebsd-performance@FreeBSD.ORG Mon Jul 7 09:43:20 2008 Return-Path: Delivered-To: freebsd-performance@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2245A1065676 for ; Mon, 7 Jul 2008 09:43:20 +0000 (UTC) (envelope-from kris@FreeBSD.org) Received: from weak.local (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 6819C8FC22; Mon, 7 Jul 2008 09:43:19 +0000 (UTC) (envelope-from kris@FreeBSD.org) Message-ID: <4871E537.7060504@FreeBSD.org> Date: Mon, 07 Jul 2008 11:43:19 +0200 From: Kris Kennaway User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) MIME-Version: 1.0 To: rabing@omc.net References: <486E4C20.7050102@omc.net> <486E6B00.10208@FreeBSD.org> <4871D784.1020809@omc.net> In-Reply-To: <4871D784.1020809@omc.net> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-performance@FreeBSD.org Subject: Re: low sysbench scores on 8 core server 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: Mon, 07 Jul 2008 09:43:20 -0000 Lutz Rabing wrote: > Kris Kennaway schrieb: >> Lutz Rabing wrote: >>> hi, >>> >>> I did some testing an a supermicro 2 x 4 core xeon server under 64bit >>> "7.0-STABLE #1: Fri Jul 4". when we first tested the system under load >>> (2000 apache threads) the system performed bad compare to other dual >>> core systems under the same workload. >>> >>> the 8 core system had 0% idle time and almost 100% system load. I could >>> not find out what the load was. disk IO was close to zero during that >>> time. >>> >>> because of that I checked the sysbench results with this test: >>> >>> sysbench --test=oltp --mysql-socket=/tmp/mysql.sock --mysql-user=root \ >>> --max-requests=0 --max-time=60 --oltp-read -only=on --num-threads=$1 run >> See my tuning notes at: >> >> http://people.freebsd.org/~kris/scaling/mysql.html >> >>> software versions used: >>> - mysql-server-5.1.25 >> In my tests mysql 5.1 has much worse performance than 5.0. >> >> Kris >> >> >> . >> > > > hi kris, > > thanks for your response. going back to mysql-5.0.51a the 8core server > performed as expected. (sysbench oltp: 4335 with 8 threads) Good to know. Let's hope mysql get their act together with the next release ;-) Kris From owner-freebsd-performance@FreeBSD.ORG Mon Jul 7 08:45:46 2008 Return-Path: Delivered-To: freebsd-performance@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 530781065683 for ; Mon, 7 Jul 2008 08:45:46 +0000 (UTC) (envelope-from rabing@omc.net) Received: from office.omc.net (office.omc.net [212.77.224.22]) by mx1.freebsd.org (Postfix) with ESMTP id DF3628FC1A for ; Mon, 7 Jul 2008 08:45:45 +0000 (UTC) (envelope-from rabing@omc.net) Received: from xoffice.omc.net (xoffice.omc.net [212.77.224.172]) by office.omc.net (8.14.1/8.14.1) with ESMTP id m678jhWN091144; Mon, 7 Jul 2008 10:45:43 +0200 (CEST) (envelope-from rabing@omc.net) Received: from [212.77.224.50] (lutz.omc.net [212.77.224.50]) by xoffice.omc.net (8.14.2/8.14.2) with ESMTP id m678jhof020014; Mon, 7 Jul 2008 10:45:43 +0200 (CEST) (envelope-from rabing@omc.net) Message-ID: <4871D784.1020809@omc.net> Date: Mon, 07 Jul 2008 10:44:52 +0200 From: Lutz Rabing User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Kris Kennaway References: <486E4C20.7050102@omc.net> <486E6B00.10208@FreeBSD.org> In-Reply-To: <486E6B00.10208@FreeBSD.org> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Mon, 07 Jul 2008 11:25:05 +0000 Cc: freebsd-performance@FreeBSD.org Subject: Re: low sysbench scores on 8 core server X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: rabing@omc.net List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Jul 2008 08:45:46 -0000 Kris Kennaway schrieb: > Lutz Rabing wrote: >> hi, >> >> I did some testing an a supermicro 2 x 4 core xeon server under 64bit >> "7.0-STABLE #1: Fri Jul 4". when we first tested the system under load >> (2000 apache threads) the system performed bad compare to other dual >> core systems under the same workload. >> >> the 8 core system had 0% idle time and almost 100% system load. I could >> not find out what the load was. disk IO was close to zero during that >> time. >> >> because of that I checked the sysbench results with this test: >> >> sysbench --test=oltp --mysql-socket=/tmp/mysql.sock --mysql-user=root \ >> --max-requests=0 --max-time=60 --oltp-read -only=on --num-threads=$1 run > > See my tuning notes at: > > http://people.freebsd.org/~kris/scaling/mysql.html > >> software versions used: >> - mysql-server-5.1.25 > > In my tests mysql 5.1 has much worse performance than 5.0. > > Kris > > > . > hi kris, thanks for your response. going back to mysql-5.0.51a the 8core server performed as expected. (sysbench oltp: 4335 with 8 threads) thanks, lutz