From owner-freebsd-performance@FreeBSD.ORG  Sat Dec  1 22:20:04 2007
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 E27CA16A419
	for <freebsd-performance@freebsd.org>;
	Sat,  1 Dec 2007 22:20:04 +0000 (UTC)
	(envelope-from jroberson@chesapeake.net)
Received: from webaccess-cl.virtdom.com (webaccess-cl.virtdom.com
	[216.240.101.25])
	by mx1.freebsd.org (Postfix) with ESMTP id 9BF3F13C448
	for <freebsd-performance@freebsd.org>;
	Sat,  1 Dec 2007 22:20:04 +0000 (UTC)
	(envelope-from jroberson@chesapeake.net)
Received: from [192.168.1.107] (cpe-24-94-75-93.hawaii.res.rr.com
	[24.94.75.93]) (authenticated bits=0)
	by webaccess-cl.virtdom.com (8.13.6/8.13.6) with ESMTP id
	lB1MK1AJ057539; Sat, 1 Dec 2007 17:20:03 -0500 (EST)
	(envelope-from jroberson@chesapeake.net)
Date: Sat, 1 Dec 2007 12:22:34 -1000 (HST)
From: Jeff Roberson <jroberson@chesapeake.net>
X-X-Sender: jroberson@192.168.1.107
To: Gergely CZUCZY <phoemix@harmless.hu>
In-Reply-To: <20071201211012.GA55519@harmless.hu>
Message-ID: <20071201122122.S884@192.168.1.107>
References: <20071129101729.GA57985@harmless.hu>
	<20071130143023.I884@192.168.1.107>
	<20071201163334.GA21709@harmless.hu>
	<200712012055.lB1Kt5IQ005728@lava.sentex.ca>
	<20071201205609.GA54238@harmless.hu>
	<200712012108.lB1L8qAd005766@lava.sentex.ca>
	<20071201211012.GA55519@harmless.hu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Cc: freebsd-performance@freebsd.org, Mike Tancsa <mike@sentex.net>
Subject: Re: mysql scaling questions
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: Sat, 01 Dec 2007 22:20:05 -0000

On Sat, 1 Dec 2007, Gergely CZUCZY wrote:

> On Sat, Dec 01, 2007 at 04:06:55PM -0500, Mike Tancsa wrote:
>> At 03:56 PM 12/1/2007, Gergely CZUCZY wrote:
>>> I don't quite understand the question. It's the very same box, with
>>> a dualboot configuration.
>>
>> Fire up the 3ware controller's RAID management software and make sure the same write caching strategy is set for FreeBSD and Linux. The
>> driver my default to different values.
>>
>> i.e. under "controller settings" make sure "write cache" and "queuing" are the same values for linux and freebsd.
> Let's get back to this on monday. I'm at home now, and the
> box is at me workplace, still running a test (i can't reboot it).

Also, can you verify with a read-only test to see where it's at?  I have 
not tested writes with that many threads.  I notice mysql goes much faster 
with a fresh table too.  So can you blow away and recreate the sysbench 
tables and then do read-only?  If that is much slower we'll know there is 
some configuration problem or similar.

Thanks,
Jeff


>
> Sincerely,
>
> Gergely Czuczy
> mailto: gergely.czuczy@harmless.hu
>
> -- 
> Weenies test. Geniuses solve problems that arise.
>