From owner-freebsd-database@FreeBSD.ORG  Mon Aug  2 14:29:30 2004
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP
	id E640616A4CE; Mon,  2 Aug 2004 14:29:30 +0000 (GMT)
Received: from search.sparks.net (search.sparks.net [207.5.180.136])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id A90FD43D6A; Mon,  2 Aug 2004 14:29:30 +0000 (GMT)
	(envelope-from dmiller@miningworks.com)
Received: by search.sparks.net (Postfix, from userid 100)
	id 219C1A902; Mon,  2 Aug 2004 10:29:30 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by search.sparks.net (Postfix) with ESMTP
	id 1AB37A901; Mon,  2 Aug 2004 10:29:30 -0400 (EDT)
Date: Mon, 2 Aug 2004 10:29:30 -0400 (EDT)
From: somethrowawayaddy@d.sparks.net
X-Sender: dmiller@search.sparks.net
To: adp <dap99@i-55.com>
In-Reply-To: <00dd01c47775$0087df40$0200a8c0@THEBOX>
Message-ID: <Pine.BSF.4.21.0408021025410.15538-100000@search.sparks.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: dmiller@miningworks.com
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-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 02 Aug 2004 14:29:31 -0000

On Sat, 31 Jul 2004, 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 had that problem a couple of years ago and resolved it on a box that's
still in use.  Very heavily loaded machine, 15 GB database, over 300
million rows in one table.  I couldn't find notes on it, however, and
don't recall exactly what it was.

One thing it might have been - did you change the HZ value in your kernel
conf file, perhaps for device polling?  I ran into problems on this
machine when setting HZ above 500 but don't recall for sure it was mysql
problems.

I'm happy to share the mysql build and conf files, and the kernel conf
file if you think it would help.  I think it was a kernel tweak that
solved the problem.

HTH,

--- David