From owner-freebsd-threads@FreeBSD.ORG  Mon Nov 15 10:57:30 2004
Return-Path: <owner-freebsd-threads@FreeBSD.ORG>
Delivered-To: freebsd-threads@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id C505316A4CE
	for <threads@freebsd.org>; Mon, 15 Nov 2004 10:57:30 +0000 (GMT)
Received: from fledge.watson.org (fledge.watson.org [204.156.12.50])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 65A7343D3F
	for <threads@freebsd.org>; Mon, 15 Nov 2004 10:57:30 +0000 (GMT)
	(envelope-from robert@fledge.watson.org)
Received: from fledge.watson.org (localhost [127.0.0.1])
	by fledge.watson.org (8.13.1/8.13.1) with ESMTP id iAFAu5Q7079060;
	Mon, 15 Nov 2004 05:56:05 -0500 (EST)
	(envelope-from robert@fledge.watson.org)
Received: from localhost (robert@localhost)iAFAu5dZ079057;
	Mon, 15 Nov 2004 10:56:05 GMT
	(envelope-from robert@fledge.watson.org)
Date: Mon, 15 Nov 2004 10:56:05 +0000 (GMT)
From: Robert Watson <rwatson@freebsd.org>
X-Sender: robert@fledge.watson.org
To: Julian Elischer <julian@elischer.org>
In-Reply-To: <4192763C.2010403@elischer.org>
Message-ID: <Pine.NEB.3.96L.1041115105150.66223H-100000@fledge.watson.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
cc: threads@freebsd.org
Subject: Re: [Fwd: Re: Mysql - Linuxthreads : Still needed?]
X-BeenThere: freebsd-threads@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Threading on FreeBSD <freebsd-threads.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-threads>
List-Post: <mailto:freebsd-threads@freebsd.org>
List-Help: <mailto:freebsd-threads-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-threads>,
	<mailto:freebsd-threads-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 15 Nov 2004 10:57:30 -0000


On Wed, 10 Nov 2004, Julian Elischer wrote:

> send to the right list. 

So, the good news is that we've successfully dramatically improved the
performance of MySQL between 5.2 and 5.3.  The mixed news is that clearly
we have more work to do. :-)  Out of curiousity, has anyone done much in
the way of kernel profiling during heavy duty MySQL runs to see if there
are specific kernel bottlenecks we can be working on?

I've noticed that we're contending a fair amount on UNIX domain socket
locking, although with Giant off the stack this is a big improvement over
what we saw previously.  Although it was a few months ago, my recollection
from profiling the mutex use and kernel use is that we're spending a lot
of time checking to see if we have to deliver signals to threads or not in
kernel.  I may have the opportunity to do a bit of profiling today or
tomorrow and see what I bump into.

Robert N M Watson             FreeBSD Core Team, TrustedBSD Projects
robert@fledge.watson.org      Principal Research Scientist, McAfee Research