From owner-freebsd-current@FreeBSD.ORG  Tue Oct 16 18:59:14 2007
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
Delivered-To: freebsd-current@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 4CA8016A418;
	Tue, 16 Oct 2007 18:59:14 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Received: from weak.local (hub.freebsd.org [IPv6:2001:4f8:fff6::36])
	by mx1.freebsd.org (Postfix) with ESMTP id F1D6013C457;
	Tue, 16 Oct 2007 18:59:12 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Message-ID: <47150A01.2040100@FreeBSD.org>
Date: Tue, 16 Oct 2007 20:59:13 +0200
From: Kris Kennaway <kris@FreeBSD.org>
User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728)
MIME-Version: 1.0
To: Stefan Lambrev <stefan.lambrev@moneybookers.com>
References: <20071016110642.GB54457@hyperion.scode.org>	<ff27tu$k01$1@ger.gmane.org>	<20071016114323.GA36300@eos.sc1.parodius.com>	<20071016120143.GA57926@hyperion.scode.org>	<3bbf2fe10710160747q51b065gcbf0cd4ef2224945@mail.gmail.com>
	<4714D2F5.1060206@moneybookers.com>
In-Reply-To: <4714D2F5.1060206@moneybookers.com>
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit
Cc: Attilio Rao <attilio@freebsd.org>, freebsd-current@freebsd.org,
	Peter Schuller <peter.schuller@infidyne.com>
Subject: Re: Status of MySQL on 7 w/o patches applied
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>, 
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 16 Oct 2007 18:59:14 -0000

Stefan Lambrev wrote:
> Hi,
> 
> Attilio Rao wrote:
>> 2007/10/16, Peter Schuller <peter.schuller@infidyne.com>:
>>  
>>>>> Just in case you missed some debugging knobs: can you retest with
>>>>> RELENG_7? (not -current).
>>>>>         
>>> I will, but I did disable INVARIANTS/WITNESS. I was afraid I had
>>> missed something else that I am not aware of; diffing the kernel conf
>>> did not indicate this was the case.
>>>     
>>
>> Recent NetBSD benchmarks, showed that malloc debugging is a very big
>> bottleneck for sybench, so you should remove it as well.
>> Also, benchmarks posted where just in regard of cached datas, so
>> without any need to do I/O from disks.
>>
>> Attilio
>>
>>
>>   
> If you run real RELENG_7 it have to be without debug in kernel, and in 
> malloc,
> nothing really to tune here :)
> 
> Just update your source tree to the latest RELENG_7 recompile and etc.
> 
> http://lists.freebsd.org/pipermail/freebsd-performance/2007-May/002664.html 
> - here are my results with mysql with FreeBSD 6.2,
> you can use it to see what I did and when I reach best performance.
> 
>  From what I remember to achieve good results you have to:
> 1) cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/my.cnf
> (or use huge if you have more one dual core CPUs)

I don't know what settings this has, but I use

http://people.freebsd.org/~kris/scaling/my.cnf

Kris