From owner-freebsd-questions@FreeBSD.ORG  Mon Aug  2 11:48:45 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 E5BFB16A4CE; Mon,  2 Aug 2004 11:48:45 +0000 (GMT)
Received: from mail.imp.ch (ns1.imp.ch [157.161.1.2])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id C17E643D58; Mon,  2 Aug 2004 11:48:44 +0000 (GMT)
	(envelope-from mb@imp.ch)
Received: from cvs.imp.ch (cvs.imp.ch [157.161.4.9])
	by mail.imp.ch (8.12.9p2/8.12.3) with ESMTP id i72BmY2k054401;
	Mon, 2 Aug 2004 13:48:35 +0200 (CEST)
	(envelope-from Martin.Blapp@imp.ch)
Date: Mon, 2 Aug 2004 13:48:34 +0200 (CEST)
From: Martin Blapp <mb@imp.ch>
To: freebsd-hackers@freebsd.org
Message-ID: <20040802133701.V27692@cvs.imp.ch>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Checksum: a29a233aa37c0924050fa4c5c317243a
X-Virus-Message-Status: No
X-Virus-Status: No, scantime="0.0017 seconds"
X-Spam-Level: 
X-Spam-Status: No, hits=-4.9 required=4 scantime="1.1575 seconds"
	tests=BAYES_00
X-Scanned-By: MIMEDefang 2.44
cc: questions@freebsd.org
Subject: Solution: FreeBSD and MySQL - mysqld eats CPU alive
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 02 Aug 2004 11:48:46 -0000


Hi all,

We have many Mysql's running here, and just to tell you, there
are fixes/workarounds for the behaviour you see:

FreeBSD 4.8 / 4.9 / 4.10 :
--------------------------

Compile port with WITH_LINUXTHREADS=YES or remove tcpwrappers
support manually from the build if it hangs with libc_r. Use IP adresses for
master/slave configurations in my.cnf. On problem here is that getnamebyhost()
is not threadsafe. This produces the strange errors you see.

We run all mysqld without tcpwrappers support and do not have any
hangs anymore.

FreeBSD 5.2.1
-------------

You have to use libc_r.so libpthreads.so hangs occasionally

FreeBSD Current
---------------

You can use libpthrads.so or libc_r.so

Martin

Martin Blapp, <mb@imp.ch> <mbr@FreeBSD.org>
------------------------------------------------------------------
ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH
Phone: +41 61 826 93 00 Fax: +41 61 826 93 01
PGP: <finger -l mbr@freebsd.org>
PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E
------------------------------------------------------------------