From owner-freebsd-stable@FreeBSD.ORG  Tue May  1 06:58:07 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 E3ACB16A401
	for <freebsd-stable@freebsd.org>; Tue,  1 May 2007 06:58:07 +0000 (UTC)
	(envelope-from ken73.chen@gmail.com)
Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228])
	by mx1.freebsd.org (Postfix) with ESMTP id 8B36B13C45D
	for <freebsd-stable@freebsd.org>; Tue,  1 May 2007 06:58:07 +0000 (UTC)
	(envelope-from ken73.chen@gmail.com)
Received: by nz-out-0506.google.com with SMTP id s1so1521854nze
	for <freebsd-stable@freebsd.org>; Mon, 30 Apr 2007 23:58:07 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=Jp0TBQsumHNiDVPPiJ8EmZMz2qVHNV3iydbJPjTAu6ThUXStgNtgu14qhi0ucl15zhrsi1/KW5bT8O71zzT3OjVYFK+FLD4VW1jSajlFwY/vMzdb15pVfm2zR8rp/tDme+HEdO+m4ePOamBqVcMZ+Ozw27Md9NQBqu1C2ta65e8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=JdDknEgFL9cSM+xt0c8t6sskgzb1PeHJToSgiMleFfhC40/Tl5x5Jh4X70Hzqnt6qxLJ1o8BdB/23Xr2xP1WjuojM5ydwLyDXeUEsV87YBj5CGdvcyyezI3oPVltPeUE20NYB0j0zAlPcVcjE4NUJk0inxbhcut7GAlmHtmYI6k=
Received: by 10.114.171.1 with SMTP id t1mr2284448wae.1178002686660;
	Mon, 30 Apr 2007 23:58:06 -0700 (PDT)
Received: by 10.114.76.14 with HTTP; Mon, 30 Apr 2007 23:58:06 -0700 (PDT)
Message-ID: <d018a9bd0704302358h1cb35046i2c4498fcb8fec5d7@mail.gmail.com>
Date: Tue, 1 May 2007 14:58:06 +0800
From: "Ken Chen" <ken73.chen@gmail.com>
To: "Ken Chen" <ken73.chen@gmail.com>, freebsd-stable@freebsd.org
In-Reply-To: <20070501020721.GA44472@icarus.home.lan>
MIME-Version: 1.0
References: <d018a9bd0704301811n47a34e7ax457f527f083e49e0@mail.gmail.com>
	<20070501020721.GA44472@icarus.home.lan>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Cc: 
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 06:58:08 -0000

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'.