From owner-freebsd-performance@FreeBSD.ORG Wed Jan 4 09:52:49 2006 Return-Path: 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 6EFCD16A41F for ; Wed, 4 Jan 2006 09:52:49 +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 1215C43D46 for ; Wed, 4 Jan 2006 09:52:48 +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 755614D14C; Wed, 4 Jan 2006 09:52:51 +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 4CDD54D129; Wed, 4 Jan 2006 09:52:40 +0000 (GMT) Message-ID: <43BB9AD0.8060202@roq.com> Date: Wed, 04 Jan 2006 20:52:16 +1100 From: Michael Vince 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: Chris References: <43B7BBEE.5020701@roq.com> <3aaaa3a0601011728j31f1cd5as@mail.gmail.com> In-Reply-To: <3aaaa3a0601011728j31f1cd5as@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP Cc: freebsd-performance@freebsd.org, huang leo 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Jan 2006 09:52:49 -0000 Chris wrote: >On 01/01/06, Michael Vince wrote: > > >>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 >> >> > > >Well sorry if I am completely wrong here, but that test seems to indicate >there is a general stability problem with libpthread. My own experience >backs up their results since on a production web server with heavy forums I >have had mysql lockups until I tinkered with the threading settings. > Personally I was surprised by this statement that libpthread wasn't working for his test, for me it does benchmark a tad slower but I have always seen libpthread as the most stable threading library. libthr doesn't work very well at all under amd64 in Java benchmarks (Java will core in a few minutes of usage) while pthread is much more reliable. >I am confused now as their is very little documentation on this, google >throws up barely anything and my main concern is stability. > >Chris > > I believe the best thing to do is always just benchmark and use whats best for you, there is no guarantee with this stuff. BTW I did a few super smack tests and saw that the thread numbers doesn't appear to reach thread numbers above 1500 but I only tested with smaller client numbers. Mike