From owner-freebsd-performance@FreeBSD.ORG  Sun Jan  1 11:24:29 2006
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
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 2F94B16A41F
	for <freebsd-performance@freebsd.org>;
	Sun,  1 Jan 2006 11:24:29 +0000 (GMT) (envelope-from mv@roq.com)
Received: from p4.roq.com (ns1.ecoms.com [207.44.130.137])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C2FB343D5C
	for <freebsd-performance@freebsd.org>;
	Sun,  1 Jan 2006 11:24:28 +0000 (GMT) (envelope-from mv@roq.com)
Received: from p4.roq.com (localhost.roq.com [127.0.0.1])
	by p4.roq.com (Postfix) with ESMTP id ED97D4CB0C;
	Sun,  1 Jan 2006 11:24:46 +0000 (GMT)
Received: from [192.168.0.2] (ppp157-158.static.internode.on.net
	[150.101.157.158])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by p4.roq.com (Postfix) with ESMTP id 1B41B4CB03;
	Sun,  1 Jan 2006 11:24:45 +0000 (GMT)
Message-ID: <43B7BBEE.5020701@roq.com>
Date: Sun, 01 Jan 2006 22:24:30 +1100
From: Michael Vince <mv@roq.com>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US;
	rv:1.7.12) Gecko/20051208
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: huang leo <leo.huang.gd@gmail.com>
References: <a0cd7c070512151920s67ca6cd6h@mail.gmail.com>
In-Reply-To: <a0cd7c070512151920s67ca6cd6h@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: ClamAV using ClamSMTP
Cc: freebsd-performance@freebsd.org
Subject: Re: Benchmark MySQL Performance On FreeBSD And Linux
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 01 Jan 2006 11:24:29 -0000

huang leo wrote:

>Hi, all:
>
>We had evaluated MySQL performance on FreeBSD and Linux. The result is
>attached.
>
>We are longing for your feedbacks!
>
>
>Best regards,
>
>Leo Huang
>
Really good work.

I gave your results some thought and was thinking that maybe you should 
check to see if you reached the default 1500 threading limit  of libthr 
and maybe it needs to be increased, I set mine to 40000 like below.
kern.threads.max_threads_per_proc=40000
kern.threads.max_groups_per_proc=40000

I was thinking it would be good to show threading usage activity with 
some kind of 1 second loop doing ps -auxwH | grep -c 'mysql' or 
something like that so we could see what limits its getting to, and so I 
can have an idea of what I can compare it to on my own servers.

Just a suggestion.

Regards,
Mike