From owner-freebsd-performance@FreeBSD.ORG  Fri Jul  4 18:25:05 2008
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
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 124201065671
	for <freebsd-performance@freebsd.org>;
	Fri,  4 Jul 2008 18:25:05 +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 594E48FC19;
	Fri,  4 Jul 2008 18:25:04 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Message-ID: <486E6B00.10208@FreeBSD.org>
Date: Fri, 04 Jul 2008 20:25:04 +0200
From: Kris Kennaway <kris@FreeBSD.org>
User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421)
MIME-Version: 1.0
To: rabing@omc.net
References: <486E4C20.7050102@omc.net>
In-Reply-To: <486E4C20.7050102@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 <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 04 Jul 2008 18:25:05 -0000

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