From owner-freebsd-hackers Mon Feb 24 16:57:32 2003 Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 21AD537B401 for ; Mon, 24 Feb 2003 16:57:31 -0800 (PST) Received: from mail.imp.ch (mail.imp.ch [157.161.1.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 444CB43F3F for ; Mon, 24 Feb 2003 16:57:30 -0800 (PST) (envelope-from mb@imp.ch) Received: from levais.imp.ch (levais.imp.ch [157.161.4.66]) by mail.imp.ch (8.12.6/8.12.3) with ESMTP id h1P0vNXN042666; Tue, 25 Feb 2003 01:57:23 +0100 (CET) (envelope-from Martin.Blapp@imp.ch) Date: Tue, 25 Feb 2003 01:57:23 +0100 (CET) From: Martin Blapp To: Alexander Langer Cc: hackers@FreeBSD.org Subject: Re: mysql endless loops Message-ID: <20030225014854.X1778@levais.imp.ch> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi Alex, This is a well known bug. You should consider to use linuxthreads. I hope it will be usable for 4.8R. Else look for patches at http://people.freebsd.org/~mbr/patches I run now all production servers with linuxthreads and hangs have gone. This document here describes the main problems with mysql on FreeBSD linked with libc_r: Short version of problems with native threading support (userland threads): 1. Non-thread safe DNS Lookups 2. Unfair Scheduling 3. High Load 4. No SMP Support 5. Missing Locks http://jeremy.zawodny.com/blog/archives/000203.html Martin Martin Blapp, ------------------------------------------------------------------ ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E ------------------------------------------------------------------ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message