From owner-freebsd-questions@FreeBSD.ORG Sun Jun 13 09:25:15 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 557F716A4CE for ; Sun, 13 Jun 2004 09:25:15 +0000 (GMT) Received: from mail.ngdc.net (mail.ngdc.net [195.190.153.169]) by mx1.FreeBSD.org (Postfix) with ESMTP id CC6C643D31 for ; Sun, 13 Jun 2004 09:25:14 +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; Sun, 13 Jun 2004 10:53:00 +0200 Message-ID: <004001c45123$d10fb7f0$6401a8c0@animal> From: "Lasse Laursen" To: freebsd-questions@FreeBSD.org Date: Sun, 13 Jun 2004 10:52:23 +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: MySQL lockups on FreeBSD 5.2-CURRENT X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 13 Jun 2004 09:25:15 -0000 Hi all, 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? 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