From owner-freebsd-current@FreeBSD.ORG Mon Jun 14 18:01:26 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 89D3816A4CE; Mon, 14 Jun 2004 18:01:26 +0000 (GMT) Received: from mail.ngdc.net (mail.ngdc.net [195.190.153.169]) by mx1.FreeBSD.org (Postfix) with ESMTP id DAA8F43D5D; Mon, 14 Jun 2004 18:01:23 +0000 (GMT) (envelope-from laursen@netgroup.dk) Received: from animal (port390.ds1-noe.adsl.cybercity.dk [217.157.177.19]) (AUTH: LOGIN laursen@solidcore.dk) by bunsen.solidcore.dk with esmtp; Mon, 14 Jun 2004 20:01:21 +0200 Message-ID: <01c301c45239$940781f0$6401a8c0@animal> From: "Lasse Laursen" To: freebsd-threads@freebsd.org, freebsd-current@freebsd.org Date: Mon, 14 Jun 2004 20:00:41 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" 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 Subject: Possible Threading problem with -CURRENT / MySQL? X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 Jun 2004 18:01:26 -0000 Hi, I posted this on the 2freebsq-questions" list some time ago but didn't get 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 CEST 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=5.8.4 PERL_VERSION=5.8.4 PERL_ARCH=mach NOPERL=yo NO_PERL=yo NO_PERL_WRAPPER=yo 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="(1536*1024*1024)" options MAXSSIZ="(1024*1024*1024)" options DFLDSIZ="(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 · 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