From owner-freebsd-hackers@FreeBSD.ORG Sun Aug 1 22:22:00 2004 Return-Path: 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 0240516A4CF; Sun, 1 Aug 2004 22:22:00 +0000 (GMT) Received: from museful.corp.yahoo.com (museful.corp.yahoo.com [216.145.52.107]) by mx1.FreeBSD.org (Postfix) with ESMTP id DF40843D49; Sun, 1 Aug 2004 22:21:59 +0000 (GMT) (envelope-from jzawodn@yahoo-inc.com) Received: (from jzawodn@localhost) by museful.corp.yahoo.com (8.11.6/8.11.1) id i71MLrG87859; Sun, 1 Aug 2004 15:21:53 -0700 (PDT) (envelope-from jzawodn) Date: Sun, 1 Aug 2004 15:21:53 -0700 From: Jeremy Zawodny To: adp Message-ID: <20040801152153.B53045@yahoo-inc.com> References: <00dd01c47775$0087df40$0200a8c0@THEBOX> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <00dd01c47775$0087df40$0200a8c0@THEBOX>; from dap99@i-55.com on Sat, Jul 31, 2004 at 10:08:32PM -0500 X-Mailman-Approved-At: Mon, 02 Aug 2004 12:14:07 +0000 cc: freebsd-database@freebsd.org cc: freebsd-hackers@freebsd.org cc: questions@freebsd.org Subject: Re: FreeBSD and MySQL - mysqld eats CPU alive X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 01 Aug 2004 22:22:00 -0000 On Sat, Jul 31, 2004 at 10:08:32PM -0500, adp wrote: > I recently posted the following message to MySQL discussion list. The > response there, and the one I keep finding on Google, is that this is a > long-standing issue betweeen FreeBSD and MySQL. For me this has been > happening since FreeBSD 4.4. > > I have one site where we are going to have to move to Linux. I would much > prefer keeping us on FreeBSD, but we just can't afford the downtime anymore. > Another site is looking at moving to PostgreSQL on FreeBSD. That's too bad. MySQL can run quite well on FreeBSD. > I have several MySQL and FreeBSD installs across a few different sites, and > I consistently have problems with mysqld. It will begin to eat up all of the > CPU and eventually become unresponsive (or the machine will just burn). I > can't seem to manually reproduce this, but given enough time a FreeBSD box > with mysqld will go down. Yes, it's FreeBSD's broken DNS libraries. Add skip-name-resolve to your my.cnf and the problem will probably go away. Jeremy -- Jeremy D. Zawodny, Technical Yahoo - Yahoo MySQL Geek Desk: (408) 349-7878 Cell: (408) 685-5936