From owner-freebsd-performance@FreeBSD.ORG Sat May 6 20:32:08 2006 Return-Path: X-Original-To: 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 A56C716A40E; Sat, 6 May 2006 20:32:08 +0000 (UTC) (envelope-from bra@fsn.hu) Received: from people.fsn.hu (people.fsn.hu [195.228.252.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5DCC243D6E; Sat, 6 May 2006 20:32:04 +0000 (GMT) (envelope-from bra@fsn.hu) Received: from localhost (localhost [127.0.0.1]) by people.fsn.hu (Postfix) with ESMTP id 82E9584423; Sat, 6 May 2006 22:32:03 +0200 (CEST) Received: from people.fsn.hu ([127.0.0.1]) by localhost (people.fsn.hu [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 33631-04; Sat, 6 May 2006 22:31:58 +0200 (CEST) Received: from [172.16.164.67] (fw.axelero.hu [195.228.243.120]) by people.fsn.hu (Postfix) with ESMTP id CD6EA8441E; Sat, 6 May 2006 22:31:57 +0200 (CEST) Message-ID: <445D07C1.7080403@fsn.hu> Date: Sat, 06 May 2006 22:32:01 +0200 From: Attila Nagy User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Robert Watson References: <20060506150622.C17611@fledge.watson.org> In-Reply-To: <20060506150622.C17611@fledge.watson.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at fsn.hu Cc: performance@FreeBSD.org, 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: Sat, 06 May 2006 20:32:09 -0000 Hello, On 2006. 05. 06. 16:16, Robert Watson wrote: > In local measurements, I have observed a 0% change in MySQL performance > on uniprocessor systems, and on a dual-processor system I have observed > a 4%-5% performance improvement with two client MySQL threads. Just a quick, nowhere correct test: http://people.fsn.hu/~bra/freebsd/20060506a-uds-fine-grain.diff/domsock.png The machine is a quad core Xeon LV server, the client side is sysbench, accessing mysql 4.1.8 on a socket. Heap table, simple test. -- Attila Nagy e-mail: Attila.Nagy@fsn.hu Free Software Network (FSN.HU) phone: +3630 306 6758 http://www.fsn.hu/