From owner-freebsd-stable@FreeBSD.ORG  Tue May  1 14:38:48 2007
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: freebsd-stable@freebsd.org
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 1479B16A401
	for <freebsd-stable@freebsd.org>; Tue,  1 May 2007 14:38:48 +0000 (UTC)
	(envelope-from mikej@rogers.com)
Received: from smtp105.rog.mail.re2.yahoo.com (smtp105.rog.mail.re2.yahoo.com
	[206.190.36.83])
	by mx1.freebsd.org (Postfix) with SMTP id B7C5813C45B
	for <freebsd-stable@freebsd.org>; Tue,  1 May 2007 14:38:47 +0000 (UTC)
	(envelope-from mikej@rogers.com)
Received: (qmail 416 invoked from network); 1 May 2007 14:12:07 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rogers.com;
	h=Received:X-YMail-OSG:Received:Message-ID:In-Reply-To:References:Date:Subject:From:To:Cc:User-Agent:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:Importance;
	b=lxU1TtyQaoOgdQjJnr06e5C787YomIbczk8VlnRtVA2NJagFSkqSGudGYvzNZK68EJlbSeMx+p1SPiisEgNtLCGRun5dBkE2h37KgtRxydZHv6bYQqeNZDEsqHoYwsfjRogAKQqusMNLgysSu/lEZa4HO+Z5Yb4kmsUdLTIaSYM=
	; 
Received: from unknown (HELO wettoast.dyndns.org)
	(mikej@rogers.com@99.244.62.78 with login)
	by smtp105.rog.mail.re2.yahoo.com with SMTP; 1 May 2007 14:12:07 -0000
X-YMail-OSG: Gsd6v00VM1mdcjWVQ8MOwaY3tUdKtiNMec._Ek9tKtSSyKLGRRi8RfXtgOMO2EtQYQ--
Received: from 209.47.38.69 (SquirrelMail authenticated user mikej)
	by wettoast.dyndns.org with HTTP;
	Tue, 1 May 2007 10:12:03 -0400 (EDT)
Message-ID: <53892.209.47.38.69.1178028723.squirrel@wettoast.dyndns.org>
In-Reply-To: <d018a9bd0704302358h1cb35046i2c4498fcb8fec5d7@mail.gmail.com>
References: <d018a9bd0704301811n47a34e7ax457f527f083e49e0@mail.gmail.com>
	<20070501020721.GA44472@icarus.home.lan>
	<d018a9bd0704302358h1cb35046i2c4498fcb8fec5d7@mail.gmail.com>
Date: Tue, 1 May 2007 10:12:03 -0400 (EDT)
From: "Mike Jakubik" <mikej@rogers.com>
To: "Ken Chen" <ken73.chen@gmail.com>
User-Agent: SquirrelMail/1.4.9a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
Cc: freebsd-stable@freebsd.org
Subject: Re: mysql frequently crash on 6.2
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 01 May 2007 14:38:48 -0000

On Tue, May 1, 2007 2:58 am, Ken Chen wrote:
> 2007/5/1, Jeremy Chadwick <koitsu@freebsd.org>:
>>
>>
>> I can confirm this problem.  Normally sig11 is an indication that you
>> have hardware-related problems, but in this particular case (at least in
>> my experience), it can also be caused by some lack-of loader.conf
>> tunables permitting mysqld to allocate the amount of memory you're
>> claiming in my.cnf.
>
>
>  Jeremy, thank you for your information.But I has modified
> /boot/loader.conf
> already, you can check the 'limits' output in my last post.
>
> The mysql run well on my other machine with low-loading, but at the
> high-loading box. mysql always get 'mysqld got signal 11'.

I've had problems with 6.2 and mysql on a large server as well. High CPU
usage and crashes. I switched the threading library to libthr and the
problems went away.