From owner-freebsd-database@FreeBSD.ORG  Wed Dec 22 22:14:52 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 9357216A4CE
	for <freebsd-database@freebsd.org>;
	Wed, 22 Dec 2004 22:14:52 +0000 (GMT)
Received: from mail.trippynames.com (mail.trippynames.com [38.113.223.19])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 72D4943D46
	for <freebsd-database@freebsd.org>;
	Wed, 22 Dec 2004 22:14:52 +0000 (GMT)
	(envelope-from sean@chittenden.org)
Received: from localhost (localhost [127.0.0.1])
	by mail.trippynames.com (Postfix) with ESMTP id DA459A6F98;
	Wed, 22 Dec 2004 14:14:28 -0800 (PST)
Received: from mail.trippynames.com ([127.0.0.1])
 by localhost (rand.nxad.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP
 id 82216-03-45; Wed, 22 Dec 2004 14:14:10 -0800 (PST)
Received: from [192.168.123.123] (unknown [38.113.223.82])
	by mail.trippynames.com (Postfix) with ESMTP id 0BA0AA6E22;
	Wed, 22 Dec 2004 11:26:10 -0800 (PST)
In-Reply-To: <235b800004122211121f3e0b3e@mail.gmail.com>
References: <235b800004122211121f3e0b3e@mail.gmail.com>
Mime-Version: 1.0 (Apple Message framework v619)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Message-Id: <6135206E-544F-11D9-AC87-000A95C705DC@chittenden.org>
Content-Transfer-Encoding: 7bit
From: Sean Chittenden <sean@chittenden.org>
Date: Wed, 22 Dec 2004 11:26:29 -0800
To: tethys ocean <tethys.ocean@gmail.com>
X-Mailer: Apple Mail (2.619)
cc: freebsd-database@freebsd.org
Subject: Re: top list
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: Wed, 22 Dec 2004 22:14:52 -0000

> Mysql running on an IBM dopuble cpu server freebsd 5.2.1 RELEASE
> whenever I said that TOP

This is a known issue with MySQL where it eats itself alive.  You'll 
have to kill -9 it and repair your tables.  I believe you'll be able to 
prevent this by running with FreeBSD 5.3 (or a slightly more recent 
version of pthreads) or recompiling MySQL with linuxthreads.  -sc

-- 
Sean Chittenden
PostgreSQL++