FreeBSD 5.3 SMP freezes with MySQL 4.1

[Young Lee]

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 at 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 at 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