From owner-freebsd-threads@FreeBSD.ORG Mon Jun 14 19:44:17 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 4B1C016A4CE; Mon, 14 Jun 2004 19:44:17 +0000 (GMT) Received: from mail.mikehost.net (lvs-1.voxel.net [207.99.115.72]) by mx1.FreeBSD.org (Postfix) with ESMTP id CA97043D5C; Mon, 14 Jun 2004 19:44:14 +0000 (GMT) (envelope-from mike@mike2k.com) Received: by mail.mikehost.net (Postfix, from userid 502) id 104EC1C139; Mon, 14 Jun 2004 11:20:40 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by mail.mikehost.net (Postfix) with ESMTP id 0A0041C0F0; Mon, 14 Jun 2004 11:20:40 -0700 (PDT) Date: Mon, 14 Jun 2004 11:20:39 -0700 (PDT) From: mike X-X-Sender: mike@sql01.internal.mikehost.net To: Lasse Laursen In-Reply-To: <01c301c45239$940781f0$6401a8c0@animal> Message-ID: References: <01c301c45239$940781f0$6401a8c0@animal> mike: yes MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=Windows-1252 Content-Transfer-Encoding: QUOTED-PRINTABLE cc: freebsd-current@freebsd.org 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: Mon, 14 Jun 2004 19:44:17 -0000 welcome to our hell. we've been experiencing mysql problems on freebsd 5.x as well. it sounds like scheduler/threading is to blame but we were not able to give sufficient or proper motivation to the folks who could examine this deeper - we even offered $500 cash to whomever stepped up to help resolve this. linux runs almost 2x as fast on the same hardware with no configuring - and we get nearly the same results running in single CPU mode vs. dual CPU mode on fbsd... something is definately fubar with the mysql+fbsd5.x combination. On Mon, 14 Jun 2004, Lasse Laursen wrote: > Hi, > > I posted this on the 2freebsq-questions" list some time ago but didn't ge= t > any response. Maybe someone on this list can help: > > We are running MySQL 4.0.20 on FreeBSD 5.2-CURRENT. The machine is a dual > Xeon with 4GByte of memory with HTT enabled. > > Some info about the system: > > FreeBSD dbnode3 5.2-CURRENT FreeBSD 5.2-CURRENT #0: Tue Jun 8 14:41:02 C= EST > 2004 laursen@dbnode3:/usr/obj/usr/src/sys/DBNODE3 i386 > > the /etc/libmap.conf contains: > > libc_r.so.5 libpthread.so.1 > libc_r.so libpthread.so > > /etc/make.conf contains: > > # -- use.perl generated deltas -- # > # Created: Wed Jun 9 10:18:52 2004 > # Setting to use base perl from ports: > PERL_VER=3D5.8.4 > PERL_VERSION=3D5.8.4 > PERL_ARCH=3Dmach > NOPERL=3Dyo > NO_PERL=3Dyo > NO_PERL_WRAPPER=3Dyo > > MySQL 4.0.20 was compiled with --without-libwrap (libwrapper seems to be > broken) and WITH_PROC_SCOPE_PTH set to yes. > > WE use the SCHED_ULE, and: > > # Memory options > options MAXDSIZ=3D"(1536*1024*1024)" > options MAXSSIZ=3D"(1024*1024*1024)" > options DFLDSIZ=3D"(1536*1024*1024)" > > The server runs fine until a single thread/query suddenly locks up the > entire MySQL daemon. After that all queries are just queued and a restart= of > the daemon is needed to unlock the system. The system itself is stable > enough as far as I can see. 'top' reports a lot of locks (*Giant) so I > assume that it's some weird problem with the threading? We used to use > FreeBSD on non-SMP machines without any problems. > > I have tried with linux threads as well but the same problem occurs. > > Have anyone experienced any similar problems and found a solution to this > rather weird problem? > > Feel free to request any further information about the system/setup and I > will do my best to provide it to the list. > > Regards > -- > Lasse Laursen =B7 VP, Hosting Technology =B7 NetGroup Processing Aps > St. Kongensgade 40H =B7 DK-1264 Copenhagen K, Denmark > Phone: +45 3370 1526 =B7 Fax: +45 3313 0066 > > - Don't be fooled by cheap finnish imitations - BSD is the One True Code > > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org= " >