From owner-freebsd-performance@FreeBSD.ORG Tue May 9 15:14:48 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 45C1B16A405; Tue, 9 May 2006 15:14:48 +0000 (UTC) (envelope-from hadara@bsd.ee) Received: from mail.neti.ee (mx1.elion.ee [194.126.101.123]) by mx1.FreeBSD.org (Postfix) with ESMTP id 378EF43D46; Tue, 9 May 2006 15:14:34 +0000 (GMT) (envelope-from hadara@bsd.ee) Received: from nat-155.nat (test.estpak.ee [194.126.115.47]) by Relayhost1.neti.ee (Postfix) with ESMTP id B9D061884F; Tue, 9 May 2006 18:14:27 +0300 (EEST) From: Sven Petai To: Kris Kennaway Date: Tue, 9 May 2006 18:18:11 +0300 User-Agent: KMail/1.9.1 References: <20060506150622.C17611@fledge.watson.org> <200605090335.00451.hadara@bsd.ee> <20060509004203.GA55852@xor.obsecurity.org> In-Reply-To: <20060509004203.GA55852@xor.obsecurity.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200605091818.12676.hadara@bsd.ee> X-Virus-Scanned: by amavisd-new-2.2.1 (20041222) (Debian) at neti.ee Cc: Sven Petai , freebsd-performance@freebsd.org, David Xu , current@freebsd.org Subject: Re: Fine-grained locking for POSIX local sockets (UNIX domain sockets) 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: Tue, 09 May 2006 15:14:49 -0000 On Tuesday 09 May 2006 03:42, Kris Kennaway wrote: > On Tue, May 09, 2006 at 03:34:59AM +0300, Sven Petai wrote: > > > Hmm, with this patch mysql 4.1 seems to crash at startup. I haven't > > > yet had time to investigate. Is anyone else seeing this? > > > > Seems to run fine here with 4.1.18 on amd64, but doesn't seem to make > > much difference though. > > > > I ran the tests again on the 8 core machine with and without rwatsons > > patch and this time with 6 tests for each setting and generated graphs: > > http://bsd.ee/~hadara/debug/mysql4/stats.html > > > > thr + select smack dynamics with the patch really do look quite > > interesting > > > > PS > > I'm currently running testround with rwatsons patch + > > http://people.freebsd.org/~csjp/kern_descrip.c.1145074052.diff + mysqld > > change davidxu suggested. > > Are there any other patches out there that I should try ? > > Sorry, I meant > http://people.freebsd.org/~csjp/sys.mpsafe.fileops.1145896495.diff > instead of that patch. Also try turning down HZ to 100, and changing > the wakeup()s to wakeup_one() in sys/filedesc.h. I preformed additional tests with the settings you suggested, updated graphs are available @ http://bsd.ee/~hadara/debug/mysql4/stats.html * with rwatsons patch + mysqld change suggested by davidxu + http://people.freebsd.org/~csjp/sys.mpsafe.fileops.1145896495.diff there doesnt seem to be much difference, but in general things seem to be couple of percent better mutex profiles for this configuration are available @ with 10 smack threads: http://bsd.ee/~hadara/debug/mysql4/freebsd_cur_ps2/mutex_freebsd_cur2_p2-select_10_10000.txt with 100 smack threads: http://bsd.ee/~hadara/debug/mysql4/freebsd_cur_ps2/mutex_freebsd_cur_p2-select_100_1000.txt * second run was with same patches, but HZ set to 100 this helps performance a lot but creates large fluxuations in select results with >20 threads + thr, sometimes difference between 2 runs with same settings was 10000+ q/s I'm currently still testing wakeup() -> wakeup_one() suggestion. In addition I did full testrun on linux to see how much this hardware is really capable of... graphs for that are available on the stats page too.