From owner-freebsd-current@FreeBSD.ORG Tue Oct 16 15:04:28 2007 Return-Path: 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 7267C16A418 for ; Tue, 16 Oct 2007 15:04:28 +0000 (UTC) (envelope-from stefan.lambrev@moneybookers.com) Received: from blah.sun-fish.com (blah.sun-fish.com [217.18.249.150]) by mx1.freebsd.org (Postfix) with ESMTP id 424F313C49D for ; Tue, 16 Oct 2007 15:04:27 +0000 (UTC) (envelope-from stefan.lambrev@moneybookers.com) Received: by blah.sun-fish.com (Postfix, from userid 1002) id 16C701B10F1F; Tue, 16 Oct 2007 17:04:26 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.2.3 (2007-08-08) on blah.cmotd.com X-Spam-Level: X-Spam-Status: No, score=-4.4 required=5.0 tests=ALL_TRUSTED,BAYES_00 autolearn=ham version=3.2.3 Received: from hater.haters.org (hater.cmotd.com [192.168.3.125]) by blah.sun-fish.com (Postfix) with ESMTP id 25B221B10F2C; Tue, 16 Oct 2007 17:04:22 +0200 (CEST) Message-ID: <4714D2F5.1060206@moneybookers.com> Date: Tue, 16 Oct 2007 18:04:21 +0300 From: Stefan Lambrev User-Agent: Thunderbird 2.0.0.6 (X11/20070918) MIME-Version: 1.0 To: Attilio Rao References: <20071016110642.GB54457@hyperion.scode.org> <20071016114323.GA36300@eos.sc1.parodius.com> <20071016120143.GA57926@hyperion.scode.org> <3bbf2fe10710160747q51b065gcbf0cd4ef2224945@mail.gmail.com> In-Reply-To: <3bbf2fe10710160747q51b065gcbf0cd4ef2224945@mail.gmail.com> Content-Type: text/plain; charset=windows-1251; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.2/4540/Sun Oct 14 03:43:55 2007 on blah.cmotd.com X-Virus-Status: Clean Cc: freebsd-current@freebsd.org, Peter Schuller 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Oct 2007 15:04:28 -0000 Hi, Attilio Rao wrote: > 2007/10/16, Peter Schuller : > >>>> 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) 2) sysctl kern.timecounter.hardware=TSC 3) changing default thread lib, but in RELENG_7 the fastest lib is used by default compile 2 kernels with scheduler 4BSD and ULE and compare results :) P.S. Do not forget to use the same version and compile options for mysql. -- Best Wishes, Stefan Lambrev ICQ# 24134177