From owner-freebsd-performance@FreeBSD.ORG Thu Jan 5 02:49:50 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 7FB1516A41F for ; Thu, 5 Jan 2006 02:49:50 +0000 (GMT) (envelope-from leo.huang.gd@gmail.com) Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.200]) by mx1.FreeBSD.org (Postfix) with ESMTP id BEE7C43D58 for ; Thu, 5 Jan 2006 02:49:49 +0000 (GMT) (envelope-from leo.huang.gd@gmail.com) Received: by uproxy.gmail.com with SMTP id o2so197273uge for ; Wed, 04 Jan 2006 18:49:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XJ8g43uKUVsTrOmReZiz3E+Ep86Oc5+smLf8L4t6sxWNuK+TwU2k37usVsdME8xsYtj4U2iGjqXFO5SVQnCqmT2xv19TCVNQCaMrC5EDAbdgNkIFk7C3d+vFAhX+Re0dYX+fGVuyekLZWw2j5GO57DbAjmp1Yk3O2ToGTUX1xQs= Received: by 10.66.255.18 with SMTP id c18mr5525788ugi; Wed, 04 Jan 2006 18:49:48 -0800 (PST) Received: by 10.66.238.19 with HTTP; Wed, 4 Jan 2006 18:49:48 -0800 (PST) Message-ID: Date: Thu, 5 Jan 2006 10:49:48 +0800 From: Leo Huang To: Michael Vince In-Reply-To: <43BB9AD0.8060202@roq.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43B7BBEE.5020701@roq.com> <3aaaa3a0601011728j31f1cd5as@mail.gmail.com> <43BB9AD0.8060202@roq.com> Cc: Chris , 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Jan 2006 02:49:50 -0000 > 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. I am surprised too. But It really happened in my test. You can get the crash situation from my last letter. Best regards, Leo Huang 2006/1/4, Michael Vince : > 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=3D40000 > >>kern.threads.max_groups_per_proc=3D40000 > >> > >>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 indicat= e > >there is a general stability problem with libpthread. My own experience > >backs up their results since on a production web server with heavy forum= s 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 > > > > >