From owner-freebsd-performance@FreeBSD.ORG Sun Feb 25 19:44:35 2007 Return-Path: X-Original-To: freebsd-performance@FreeBSD.org Delivered-To: freebsd-performance@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4994616A403 for ; Sun, 25 Feb 2007 19:44:35 +0000 (UTC) (envelope-from tataz@tataz.chchile.org) Received: from postfix2-g20.free.fr (postfix2-g20.free.fr [212.27.60.43]) by mx1.freebsd.org (Postfix) with ESMTP id DA37513C4A6 for ; Sun, 25 Feb 2007 19:44:34 +0000 (UTC) (envelope-from tataz@tataz.chchile.org) Received: from smtp5-g19.free.fr (smtp5-g19.free.fr [212.27.42.35]) by postfix2-g20.free.fr (Postfix) with ESMTP id 8CDF1B6B5AA for ; Sun, 25 Feb 2007 19:21:00 +0100 (CET) Received: from tatooine.tataz.chchile.org (tataz.chchile.org [82.233.239.98]) by smtp5-g19.free.fr (Postfix) with ESMTP id ED7F535B67; Sun, 25 Feb 2007 20:20:47 +0100 (CET) Received: from obiwan.tataz.chchile.org (unknown [192.168.1.25]) by tatooine.tataz.chchile.org (Postfix) with ESMTP id D1A689BE05; Sun, 25 Feb 2007 19:22:39 +0000 (UTC) Received: by obiwan.tataz.chchile.org (Postfix, from userid 1000) id C8F8D405B; Sun, 25 Feb 2007 20:22:39 +0100 (CET) Date: Sun, 25 Feb 2007 20:22:39 +0100 From: Jeremie Le Hen To: Kris Kennaway Message-ID: <20070225192239.GN2479@obiwan.tataz.chchile.org> References: <20070224215508.GA41968@xor.obsecurity.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070224215508.GA41968@xor.obsecurity.org> User-Agent: Mutt/1.5.13 (2006-08-11) Cc: freebsd-performance@FreeBSD.org Subject: Re: Progress on scaling of FreeBSD on 8 CPU systems 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: Sun, 25 Feb 2007 19:44:35 -0000 Hi, Kris, On Sat, Feb 24, 2007 at 04:55:08PM -0500, Kris Kennaway wrote: > Now that the goals of the SMPng project are complete, for the past > year or more several of us have been working hard on profiling FreeBSD > in various multiprocessor workloads, and looking for performance > bottlenecks to be optimized. > > We have recently made significant progress on optimizing for MySQL > running on an 8-core amd64 system. The graph of results may be found > here: > > http://www.freebsd.org/~kris/scaling/scaling.png > > This shows the graph of MySQL transactions/second performed by a > multi-threaded client workload against a local MySQL database with > varying numbers of client threads, with identically configured FreeBSD > and Linux systems on the same machine. I'm really glad to be looking at these results eventually. Thanks to all FreeBSD committers. > The test was run on FreeBSD 7.0, with the latest version of the ULE > 2.0 scheduler, the libthr threading library, and an uncommitted patch > from Jeff Roberson [1] that addresses poor scalability of file > descriptor locking (using a new sleepable mutex primitive); this patch > is responsible for almost all of the performance and scaling > improvements measured. It also includes some other patches (collected > in my kris-contention p4 branch) that have been shown to help > contention in MySQL workloads in the past (including a UNIX domain > socket locking pushdown patch from Robert Watson), but these were > shown to only give small individual contributions, with a cumulative > effect on the order of 5-10%. MySQL uses gettimeofday(2) very often. ISTR it has been stated that MySQL performances could make the most of a system-wide shared page where the current time would be updated regularly by the kernel; gettimeofday(2) could consequentely work without any context switch. Do the patches you're talking about include such a feature already ? Thank you. Best regards, -- Jeremie Le Hen < jeremie at le-hen dot org >< ttz at chchile dot org >