From owner-freebsd-stable@FreeBSD.ORG  Wed Mar 30 04:31:17 2005
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id BB04016A4CE
	for <freebsd-stable@freebsd.org>;
	Wed, 30 Mar 2005 04:31:17 +0000 (GMT)
Received: from 163.com (smtp.163.com [202.108.44.205])
	by mx1.FreeBSD.org (Postfix) with SMTP id 5BE7443D2D
	for <freebsd-stable@freebsd.org>;
	Wed, 30 Mar 2005 04:31:16 +0000 (GMT)	(envelope-from ncisoft@163.com)
Received: from [192.168.1.15] (unknown [61.51.103.93])
	by smtp2 (Coremail) with SMTP id LEChh3YrSkL0knEA.2
	for <uzi@bmby.com>; Wed, 30 Mar 2005 12:30:52 +0800 (CST)
X-Originating-IP: [61.51.103.93]
Date: Wed, 30 Mar 2005 12:30:50 +0800
From: Young Lee <ncisoft@163.com>
To: Uzi Klein <uzi@bmby.com>
In-Reply-To: <42491F63.9020305@bmby.com>
References: <20050329165741.DD3B.NCISOFT@163.com> <42491F63.9020305@bmby.com>
Message-Id: <20050330122213.CB3E.NCISOFT@163.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Becky! ver. 2.11.02 [en]
cc: ncisoft@163.com
cc: freebsd-stable@freebsd.org
Subject: Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.1
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: Wed, 30 Mar 2005 04:31:17 -0000

I have try your solution yesterday, so far it is stable, and will
observe the stability for some days. btw, i turn "debug.mpsafenet=0" 
in /boot/loader.conf to evade the possible network stack deadlock 
under SMP.

-- 
Young Lee


On Tue, 29 Mar 2005 11:26:59 +0200
Uzi Klein <uzi@bmby.com> wrote:
> Young Lee wrote:
> > as I said , I build mysql41-server from port without any parameters, 
> > so you can see libwrap, and i will --without it next time.
> > 
> > the smp kernel should be crashed in 2 minutes, so my server is 
> > running with UP configuration, and the SMP dmesg wasn't saved.
> > 
> > I wonder ADAPTIVE_MUTEXES options is suitable for SMP? I am very
> > likely to see your kernel conf file and mysql build options, they
> > will be very useful, thanks.
> > 
> 
> attached my kernel conf file
> 
> im using mysql with linuxthreads :
> 
> # cd /usr/ports/databases/mysql41-server
> # make \
> WITH_CHARSET=latin1 \
> WITH_XCHARSET=complex \
> WITH_COLLATION=latin1_general_ci \
> WITH_LINUXTHREADS=yes \
> BUILD_STATIC=yes \
> BUILD_OPTIMIZED=yes
> # make install clean
> 
> --
> Uzi Klein
> Software Development Manager
> BMBY Software Systems Ltd
> 2 Hataasia St., Yokneam, Israel
> Email:   uzi@bmby.com
> P:  +972 4  959 79 89
> M: +972 52 374 53 34
> F:    +972 3  617 93 36
> Web:     http://www.bmby.com