Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-04-12 Thread Vivek Khera
On Apr 12, 2005, at 12:23 PM, Young Lee wrote: I had repeated the panic by reset debug.mpsafenet from 0 to 1, after that, the system automatically reboot after several hours, and if debug.mpsafenet was set to 0, the system is stable. so i guess this is a tcp stack or NIC driver SMP thread-safe iss

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-04-12 Thread Young Lee
I had repeated the panic by reset debug.mpsafenet from 0 to 1, after that, the system automatically reboot after several hours, and if debug.mpsafenet was set to 0, the system is stable. so i guess this is a tcp stack or NIC driver SMP thread-safe issue, normally my server got over 1000 interrupt

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-04-03 Thread Uzi Klein
Young Lee wrote: Thank you very much. My server's uptime last two days by refer to Klein's configuration, it's impactful, thanks to Klein. My concern of stablility is focus on mysql's build options as BUILD_STATIC & BUILD_OPTIMIZED, but it looks like ridiculous without any logicality, build_stat

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-31 Thread Young Lee
Thank you very much. My server's uptime last two days by refer to Klein's configuration, it's impactful, thanks to Klein. My concern of stablility is focus on mysql's build options as BUILD_STATIC & BUILD_OPTIMIZED, but it looks like ridiculous without any logicality, build_static should have no

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-30 Thread Doug White
On Wed, 30 Mar 2005, Young Lee wrote: > the system is totally dead with the pannic message, and have > to hard reset to reboot. even i reboot the server, it will crash in > several minutes, because of hundreds of request is coming. You get a panic? You didn't say that before! > by refer to Klein

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-30 Thread Young Lee
admin# sysctl -a | grep net.inet.tcp.sack net.inet.tcp.sack.enable: 1 i use SMP kernel configuration from cvsup without any modification. -- Young Lee On Wed, 30 Mar 2005 17:40:49 +0800 Xin LI <[EMAIL PROTECTED]> wrote: > Hi, Young, > > å 2005-03-30äç 17:08 +0800ïYoung Leeåéï > > the system i

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-30 Thread Michael Vince
I am running 1 mildly busy new MySQL server thats running fine on 5.3-RELEASE-p5 #5: Sat Jan 22 04:54:07 EST 2005 from the generic conf kernel Its a Dell 1850 Dual P4 Xeon CPU 3.00GHz EMT64 with HTT enabled FYI I actually have a Dell 2650 thats not doing anything at the moment be

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-30 Thread Xin LI
Hi, Young, å 2005-03-30äç 17:08 +0800ïYoung Leeåéï > the system is totally dead with the pannic message, and have > to hard reset to reboot. even i reboot the server, it will crash in > several minutes, because of hundreds of request is coming. > > by refer to Klein's configuration and turn "de

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-30 Thread Young Lee
the system is totally dead with the pannic message, and have to hard reset to reboot. even i reboot the server, it will crash in several minutes, because of hundreds of request is coming. by refer to Klein's configuration and turn "debug.mpsafenet=0" in /boot/loader.conf, the server is stable s

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread Doug White
On Tue, 29 Mar 2005, [GB2312] ÀîÒã¸Õ wrote: > Hi, > > I have a dell pe2650 box with dual xeon 2.4G, disabled the HTT, > installed 5.3-RELEASE, enabled SMP, mysql 4.1.10a built from > the port. > > If the mysql connections is high (e.g. over 100 connections), > the system will freezes in several mi

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread 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 <[EMAIL PROTECTED]> wro

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread Vivek Khera
On Mar 29, 2005, at 1:17 AM, [EMAIL PROTECTED] wrote: I have a dell pe2650 box with dual xeon 2.4G, disabled the HTT, installed 5.3-RELEASE, enabled SMP, mysql 4.1.10a built from the port. I am observing similar problems with high load (not necessarily high number of connections) with 5.4-PRERELEA

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread Uzi Klein
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_MUTEXE

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread Young Lee
I have try linuxthreads, it crashed, never try any optimzation option. -- Young Lee On Tue, 29 Mar 2005 17:05:54 +0800 Young Lee <[EMAIL PROTECTED]> 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. > > t

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread Young Lee
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 suit

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-29 Thread Uzi Klein
Young Lee wrote: > the system is hang and throw a fatal 12 pannic. > > I build mysql41-server from port without any parameters, and the > thread lib use libpthread.so.1, use ldd to look details as below > > admin# ldd /usr/local/libexec/mysqld > /usr/local/libexec/mysqld: > libz.so.2 => /

Re: FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-28 Thread Uzi Klein
李毅刚 wrote: >Hi, > >I have a dell pe2650 box with dual xeon 2.4G, disabled the HTT, >installed 5.3-RELEASE, enabled SMP, mysql 4.1.10a built from >the port. > >If the mysql connections is high (e.g. over 100 connections), >the system will freezes in several minutes, and the fatal alway >indicat

FreeBSD 5.3 SMP freezes with MySQL 4.1

2005-03-28 Thread =?GB2312?B?wO7S47jV?=
Hi, I have a dell pe2650 box with dual xeon 2.4G, disabled the HTT, installed 5.3-RELEASE, enabled SMP, mysql 4.1.10a built from the port. If the mysql connections is high (e.g. over 100 connections), the system will freezes in several minutes, and the fatal alway indicated to the mysqld proc