From owner-freebsd-threads@FreeBSD.ORG Tue Jun 15 11:23:28 2004 Return-Path: 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 29DC216A4CE; Tue, 15 Jun 2004 11:23:28 +0000 (GMT) Received: from mail.ngdc.net (mail.ngdc.net [195.190.153.169]) by mx1.FreeBSD.org (Postfix) with ESMTP id B365443D46; Tue, 15 Jun 2004 11:23:27 +0000 (GMT) (envelope-from laursen@netgroup.dk) Message-ID: <045c01c452cb$16f4b0b0$ce01000a@animal> From: "Lasse Laursen" To: "Cedric Tabary" , freebsd-current@freebsd.org References: <03db01c4524f$f60d5760$6401a8c0@animal> <20040615110613.GB81104@efrei.fr> Date: Tue, 15 Jun 2004 13:12:18 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 cc: mike cc: freebsd-threads@freebsd.org Subject: Re: Possible Threading problem with -CURRENT / MySQL? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 15 Jun 2004 11:23:28 -0000 Hi, Have you had any lockups in MySQL with your setup? We have tried to disable HTT and hopefully that will solve the problem. Regards -- Lasse Laursen · VP, Hosting Technology · NetGroup Processing Aps St. Kongensgade 40H · DK-1264 Copenhagen K, Denmark Phone: +45 3370 1526 · Fax: +45 3313 0066 - Don't be fooled by cheap finnish imitations - BSD is the One True Code ----- Original Message ----- From: "Cedric Tabary" To: Cc: "Lasse Laursen" ; ; "mike" ; "Petri Helenius" Sent: Tuesday, June 15, 2004 1:06 PM Subject: Re: Possible Threading problem with -CURRENT / MySQL? > On 14/06/2004 17:43, Robert Watson wrote: > > On Mon, 14 Jun 2004, Lasse Laursen wrote: > > > > > Also on a SMP machine? I think that the problem is somehow related to > > > SMP machines since the problems started when we moved to a SMP box :( > > > > If you haven't already, it would certainly be worth removing SMP from the > > kernel on that box and just running a UP kernel to confirm that it's a > > problem using SMP. I don't doubt it's the case, but it's worth checking > > anyway to be sure. > > I have a similar smp config (dell poweredge 2650, dual Xeon 2.8, RAID5) > > I have best performance with linux 2.4.21-smp (not tried 2.6), > but very poor (5x less) with mysqld using libpthreads on CURRENT. > mysqld process is always in state 'kserel' or sometimes '*Giant' > > http://grumly.eu.org/~ced/dmesg.txt > http://grumly.eu.org/~ced/CED-SMP.txt (no invariants, no witness) > > mysqld with linuxthreads seems to work better ... > and even better with libc_r (but using only 1 cpu) > > Everything with HTT disabled in bios. Enabling HTT gives even worst > performance :/