From owner-freebsd-questions@FreeBSD.ORG  Fri Aug 29 07:34:40 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 3C6B11065677
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2008 07:34:40 +0000 (UTC)
	(envelope-from pprocacci@datapipe.com)
Received: from fmailhost05.isp.att.net (fmailhost05.isp.att.net
	[204.127.217.105])
	by mx1.freebsd.org (Postfix) with ESMTP id 2D8128FC1D
	for <freebsd-questions@freebsd.org>;
	Fri, 29 Aug 2008 07:34:40 +0000 (UTC)
	(envelope-from pprocacci@datapipe.com)
Received: from [10.5.21.122] (adsl-241-169-57.bna.bellsouth.net[74.241.169.57])
	by isp.att.net (frfwmhc05) with ESMTP
	id <20080829073439H0500e6jkse>; Fri, 29 Aug 2008 07:34:39 +0000
X-Originating-IP: [74.241.169.57]
Message-ID: <48B7A67F.8050204@datapipe.com>
Date: Fri, 29 Aug 2008 02:34:23 -0500
From: "Paul A. Procacci" <pprocacci@datapipe.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: FreeBSD <freebsd-questions@freebsd.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: General Mysql Performance Question
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 29 Aug 2008 07:34:40 -0000

Hey All,

Recently I've been asked to do performance testing of postgres and mysql 
on FreeBSD.  Kris' page 
(http://people.freebsd.org/~kris/scaling/mysql.html) was extremely 
useful in giving me a starting point for my own comparisons.  
Additionally, his name is splattered all over the web with patches, 
tuning tips, etc.  For that, I thank you Kris.  With that said, I've 
come across something that I can not find the answer to and I'm hoping I 
have missed something incredibly simple.  If this has been mentioned 
before, then I apologize in advance.

http://paul.procacci.me/benchmarks/freebsd7-Release.html

My question is in reference to the 1st and 2nd graphs on this page.  
While testing the performance of the databases given in this graph, the 
one thing that sticks out is that when Mysql uses the myisam engine with 
the ULE schedular, performance drops quite considerably regardless of 
mysql version.  The clearly shows ULE to perform worst at higher work 
loads than 4BSD, at least in this one example.

Now, I read that lockmgr code is still a work in progress, but I'm 
unsure if that applies specifically to this specific problem that I'm 
providing.  What I'm hoping for quite frankly is a "yes, this is 
because...." type of response.

This isn't a problem per se, but rather a curiosity type of question.

Thanks in advance,
~Paul