Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 interrupts/s on bge, I have plan to replace the onboard bge NIC to fxp and set debug.mpsafenet to 1 to see what will happen this week. -- Young Lee On Thu, 31 Mar 2005 18:03:08 +0200 Uzi Klein [EMAIL PROTECTED] wrote: 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_static should have not any different between dynamatic lib. I will do some testing after the current configuration to be proven by uptime over one week, and try to find out how to repeat the panic. I think the real change was usin linuxthreads for SMP honestly. The BUILD_STATIC BUILD_OPTIMIZED only increase speed by not setting shared libs and enables assembly AFAIK. -- Uzi Klein Software Development Manager BMBY Software Systems Ltd 2 Hataasia St., Yokneam, Israel P: +972 4 959 79 89 F: +972 3 617 93 36 http://www.bmby.com ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 issue, normally my server got over 1000 interrupts/s on bge, I have plan to replace the onboard bge NIC to fxp and set debug.mpsafenet to 1 to see what will happen this week. I just did the exact same thing: disable motherboard bge in preference to em (intel) on a PCI card, and have had 100% stable for the last 6 days. Normally every night during heavy network backup and database reporting the bge ports would either be reset after watchdog timeout, or the whole system would freeze with nothing logged to console, screen, or BIOS... so going 6 days without any events leads me to point a big hairy finger at bge driver. Even with mpsafenet=0, I was having these timeouts and lockups, and bad performance thrown in. :-( I run with mpsafenet default and the em ethernet driver. Be sure to disable the onboard bge in your BIOS. I'm on a dual opteron Tyan S2881 motherboard, for what that's worth. FreeBSD 5.4-STABLE from April 4 is my OS. My guess is with the intel NIC you will find yourself much more stable. On my lesser loaded machines the bge driver holds up ok. Vivek Khera, Ph.D. +1-301-869-4449 x806
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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_static should have not any different between dynamatic lib. I will do some testing after the current configuration to be proven by uptime over one week, and try to find out how to repeat the panic. I think the real change was usin linuxthreads for SMP honestly. The BUILD_STATIC BUILD_OPTIMIZED only increase speed by not setting shared libs and enables assembly AFAIK. -- Uzi Klein Software Development Manager BMBY Software Systems Ltd 2 Hataasia St., Yokneam, Israel P: +972 4 959 79 89 F: +972 3 617 93 36 http://www.bmby.com ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 not any different between dynamatic lib. I will do some testing after the current configuration to be proven by uptime over one week, and try to find out how to repeat the panic. -- Young Lee On Wed, 30 Mar 2005 23:18:56 +1000 Michael Vince [EMAIL PROTECTED] wrote: I am running 1 mildly busy new MySQL server thats running fine on5.3-RELEASE-p5 #5: Sat Jan 22 04:54:07 EST 2005 from the generic confkernel 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 momentbecause it had sluggish performance when I started to put some seriousburden on it. I recently updated to the latest MySQL to 4.1.10a from 4.1.5 with usingthis set of settings (I hate using ports manually) portupgrade -Rfri -m 'BUILD_OPTIMIZED=yes BUILD_STATIC=yes'/var/db/pkg/mysql-server-4.1* I copied the default large.cnf file to /var/db/mysql/my.cnf for betterperformance but thats about it, I am still evaluating MySQL performance. To give you a remote idea how busy this MySQL server is, here aresome bits running mysqladmin extended-status | Bytes_received | 49227436 | | Bytes_sent | 71933703 | | Threads_connected| 25 | | Threads_created | 42 | | Uptime | 101775 | According to MySQL manual Threads_created gives an idea of the load onthe MySQL server. phpMyAdmin lists MySQL status in a much nicer way This MySQL server has been running for 1 days, 4 hours, 38 minutes and28 seconds. Query statistics: Since its startup, 335,544 queries have beensent to the server. Total oslash; per hour oslash; per minute oslash; per second 335,544 11,715.47 195.26 3.25 select 204,621 7,144.3161.04 % insert 29,149 1,017.738.70 % show keys 85,395 2,981.5525.48 % This server is doing more things then I originally planned it to do,its also running a Postgres 7.4 server that has over 500megs of dataand almost constant 100% usage of disk IO according to top via m, Ihave statistics enabled on postgres but no way to show some simplesummaries. I run Apache2 in prefork mode and currently has around 350 averageapache daemons ps -auxww | grep -c httpd 356 Its doing over 1 million dynamic page loads a day (some page loadsdon't use database) This server also is running 12 separate Java processes each at around200megs of size. Since cvsuping to the latest 5_3 for release security patches andcritical updates the server is been perfectly stable, before that I didhave kernel panic reboot problems that I believe were caused be massivethread usage from the java processes. Although I have rebooted just a little while ago the servers uptime iscurrently 33days. With your server how have you been updating your server to 5.3-P5release? Its possible you have a similar problem. I am emailing this in HTML format in the hope the tables come out morenicely. Regards, Mike Young Lee wrote: I have try your solution yesterday, so far it is stable, and willobserve the stability for some days. btw, i turn debug.mpsafenet=0 in /boot/loader.conf to evade the possible network stack deadlock under SMP. ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 so far, and it last 20 hours. -- Young Lee On Tue, 29 Mar 2005 21:01:51 -0800 (PST) Doug White [EMAIL PROTECTED] wrote: 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 minutes, and the fatal alway indicated to the mysqld process. When I build the kernel without SMP, the system is stable. I have try 5.3-p5 and 5.4-PRE, the problem is still there. It's my configuration mistake or will be solved in 5.4-RELEASE ? There's just not enough information to tell. When you say freeze, is the machine totally unresponsive, or does the console allow you to type characters? Can you ping the system when it appears frozen? Does the system eventually recover if the load is taken away? -- Doug White| FreeBSD: The Power to Serve [EMAIL PROTECTED] | www.FreeBSD.org ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
Hi, Young, 2005-03-30 17:08 +0800Young 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 so far, and it last 20 hours. Have you tried disabling SACK? (net.inet.tcp.sack)? BTW. I think it might be helpful to show your kernel compiling configuration. Cheers, -- Xin LI delphij delphij net http://www.delphij.net/ signature.asc Description: This is a digitally signed message part
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 because it had sluggish performance when I started to put some serious burden on it. I recently updated to the latest MySQL to 4.1.10a from 4.1.5 with using this set of settings (I hate using ports manually) portupgrade -Rfri -m 'BUILD_OPTIMIZED=yes BUILD_STATIC=yes' /var/db/pkg/mysql-server-4.1* I copied the default large.cnf file to /var/db/mysql/my.cnf for better performance but thats about it, I am still evaluating MySQL performance. To give you a remote idea how busy this MySQL server is, here are some bits running mysqladmin extended-status | Bytes_received | 49227436 | | Bytes_sent | 71933703 | | Threads_connected| 25 | | Threads_created | 42 | | Uptime | 101775 | According to MySQL manual Threads_created gives an idea of the load on the MySQL server. phpMyAdmin lists MySQL status in a much nicer way This MySQL server has been running for 1 days, 4 hours, 38 minutes and 28 seconds. Query statistics: Since its startup, 335,544 queries have been sent to the server. Total ø per hour ø per minute ø per second 335,54411,715.47 195.26 3.25 select 204,621 7,144.31 61.04 % insert 29,149 1,017.73 8.70 % show keys 85,395 2,981.55 25.48 % This server is doing more things then I originally planned it to do, its also running a Postgres 7.4 server that has over 500megs of data and almost constant 100% usage of disk IO according to top via m, I have statistics enabled on postgres but no way to show some simple summaries. I run Apache2 in prefork mode and currently has around 350 average apache daemons ps -auxww | grep -c httpd 356 Its doing over 1 million dynamic page loads a day (some page loads don't use database) This server also is running 12 separate Java processes each at around 200megs of size. Since cvsuping to the latest 5_3 for release security patches and critical updates the server is been perfectly stable, before that I did have kernel panic reboot problems that I believe were caused be massive thread usage from the java processes. Although I have rebooted just a little while ago the servers uptime is currently 33days. With your server how have you been updating your server to 5.3-P5 release? Its possible you have a similar problem. I am emailing this in HTML format in the hope the tables come out more nicely. Regards, Mike Young Lee wrote: 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. ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 +0800Young 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 so far, and it last 20 hours. Have you tried disabling SACK? (net.inet.tcp.sack)? BTW. I think it might be helpful to show your kernel compiling configuration. Cheers, -- Xin LI delphij delphij net http://www.delphij.net/ ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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's configuration and turn debug.mpsafenet=0 in /boot/loader.conf, the server is stable so far, and it last 20 hours. Can't say I've had problems with mpsafenet here. -- Doug White| FreeBSD: The Power to Serve [EMAIL PROTECTED] | www.FreeBSD.org ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 = /lib/libz.so.2 (0x28422000) libwrap.so.3 = /usr/lib/libwrap.so.3 (0x28432000) libcrypt.so.2 = /lib/libcrypt.so.2 (0x2843a000) libstdc++.so.4 = /usr/lib/libstdc++.so.4 (0x28452000) libm.so.3 = /lib/libm.so.3 (0x28524000) libpthread.so.1 = /usr/lib/libpthread.so.1 (0x2853f000) libc.so.5 = /lib/libc.so.5 (0x28563000) i wonder why should it uses libwrap and libstdc++... did you try compiling it optimized? or with linuxthreads? I use the original SMP kernel configuration file: admin# cat /usr/src/sys/i386/conf/SMP include GENERIC ident SMP-GENERIC options SMP did you add optionsSMP in your kernel conf? I can see the kernel loading 1 CPU should look like that: snip ... Copyright (c) 1992-2004 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD 5.3-RELEASE-p5 #2: Tue Feb 22 16:47:08 UTC 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC ACPI APIC Table: HP 0083 Timecounter i8254 frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 3.20GHz (3200.13-MHz 686-class CPU) Origin = GenuineIntel Id = 0xf34 Stepping = 4 Features=0xbfebfbffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE Hyperthreading: 2 logical CPUs real memory = 2147430400 (2047 MB) avail memory = 2100178944 (2002 MB) FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu2 (AP): APIC ID: 6 cpu3 (AP): APIC ID: 7 ioapic0 Version 2.0 irqs 0-23 on motherboard ioapic1 Version 2.0 irqs 24-47 on motherboard ... /snip dmesg with up below - Copyright (c) 1992-2005 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD 5.4-PRERELEASE #2: Thu Mar 24 19:16:17 CST 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC Timecounter i8254 frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 2.40GHz (2387.28-MHz 686-class CPU) Origin = GenuineIntel Id = 0xf29 Stepping = 9 Features=0xbfebfbffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI, MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE real memory = 2147352576 (2047 MB) avail memory = 2095882240 (1998 MB) ACPI APIC Table: DELL PE2650 ioapic0: Changing APIC ID to 8 ioapic1: Changing APIC ID to 9 ioapic2: Changing APIC ID to 10 MADT: Forcing active-low polarity and level trigger for SCI ioapic0 Version 1.1 irqs 0-15 on motherboard ioapic1 Version 1.1 irqs 16-31 on motherboard ioapic2 Version 1.1 irqs 32-47 on motherboard npx0: math processor on motherboardusing npx0: INT 16 interfaceusing acpi0: DELL PE2650 on motherboard acpi0: Power Button (fixed) Timecounter ACPI-safe frequency 3579545 Hz quality 1000 acpi_timer0: 32-bit timer at 3.579545MHz port 0x808-0x80b on acpi0 cpu0: ACPI CPU on acpi0 pcib0: ACPI Host-PCI bridge port 0xcf8-0xcff on acpi0 pci0: ACPI PCI bus on pcib0 pci0: unknown at device 4.0 (no driver attached) pci0: unknown at device 4.1 (no driver attached) pci0: unknown at device 4.2 (no driver attached) pci0: display, VGA at device 14.0 (no driver attached) atapci0: ServerWorks CSB5 UDMA100 controller port 0x8b0-0x8bf,0x376,0x170-0x177,0x3f6,0x1f0-0x1f7 at device 1 5.1 on pci0 ata0: channel #0 on atapci0 ata1: channel #1 on atapci0 ohci0: OHCI (generic) USB controller mem 0xfe10-0xfe100fff irq 5 at device 15.2 on pci0 usb0: OHCI version 1.0, legacy support usb0: SMM does not respond, resetting usb0: OHCI (generic) USB controller on ohci0 usb0: USB revision 1.0 uhub0: (0x1166) OHCI root hub, class 9/0, rev 1.00/1.00, addr 1 uhub0: 4 ports with 4 removable, self powered isab0: PCI-ISA bridge at device 15.3 on pci0 isa0: ISA bus on isab0 pcib1: ACPI Host-PCI bridge on acpi0 pci4: ACPI PCI bus on pcib1 pcib2: ACPI PCI-PCI bridge at device 8.0 on pci4 pci5: ACPI PCI bus on pcib2 aac0: Dell PERC 3/Di mem 0xf800-0xfbff irq 30 at device 8.1 on pci4 aac0: i960RX 100MHz, 54MB cache memory, optional battery present aac0: Kernel 2.8-0, Build 6082, S/N a438d3 aac0: Supported Options=275cWCACHE,DATA64,HOSTTIME,WINDOW4GB,SOFTERR,NORECOND,SGMAP64 pcib3: ACPI Host-PCI bridge on acpi0 pci3: ACPI PCI bus on pcib3 bge0: Broadcom BCM5703 Gigabit Ethernet, ASIC rev. 0x1002 mem 0xfcf1-0xfcf1 irq 28 at device 6.0 on p ci3 miibus0: MII bus on bge0 brgphy0: BCM5703 10/100/1000baseTX PHY on
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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. -- Young Lee On Tue, 29 Mar 2005 10:54:52 +0200 Uzi Klein [EMAIL PROTECTED] wrote: 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 = /lib/libz.so.2 (0x28422000) libwrap.so.3 = /usr/lib/libwrap.so.3 (0x28432000) libcrypt.so.2 = /lib/libcrypt.so.2 (0x2843a000) libstdc++.so.4 = /usr/lib/libstdc++.so.4 (0x28452000) libm.so.3 = /lib/libm.so.3 (0x28524000) libpthread.so.1 = /usr/lib/libpthread.so.1 (0x2853f000) libc.so.5 = /lib/libc.so.5 (0x28563000) i wonder why should it uses libwrap and libstdc++... did you try compiling it optimized? or with linuxthreads? I use the original SMP kernel configuration file: admin# cat /usr/src/sys/i386/conf/SMP include GENERIC ident SMP-GENERIC options SMP did you add options SMP in your kernel conf? I can see the kernel loading 1 CPU should look like that: snip ... Copyright (c) 1992-2004 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD 5.3-RELEASE-p5 #2: Tue Feb 22 16:47:08 UTC 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC ACPI APIC Table: HP 0083 Timecounter i8254 frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 3.20GHz (3200.13-MHz 686-class CPU) Origin = GenuineIntel Id = 0xf34 Stepping = 4 ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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. 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. -- Young Lee On Tue, 29 Mar 2005 10:54:52 +0200 Uzi Klein [EMAIL PROTECTED] wrote: 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 = /lib/libz.so.2 (0x28422000) libwrap.so.3 = /usr/lib/libwrap.so.3 (0x28432000) libcrypt.so.2 = /lib/libcrypt.so.2 (0x2843a000) libstdc++.so.4 = /usr/lib/libstdc++.so.4 (0x28452000) libm.so.3 = /lib/libm.so.3 (0x28524000) libpthread.so.1 = /usr/lib/libpthread.so.1 (0x2853f000) libc.so.5 = /lib/libc.so.5 (0x28563000) i wonder why should it uses libwrap and libstdc++... did you try compiling it optimized? or with linuxthreads? I use the original SMP kernel configuration file: admin# cat /usr/src/sys/i386/conf/SMP include GENERIC ident SMP-GENERIC options SMP did you add optionsSMP in your kernel conf? I can see the kernel loading 1 CPU should look like that: snip ... Copyright (c) 1992-2004 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD 5.3-RELEASE-p5 #2: Tue Feb 22 16:47:08 UTC 2005 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC ACPI APIC Table: HP 0083 Timecounter i8254 frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 3.20GHz (3200.13-MHz 686-class CPU) Origin = GenuineIntel Id = 0xf34 Stepping = 4 ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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: [EMAIL PROTECTED] P: +972 4 959 79 89 M: +972 52 374 53 34 F:+972 3 617 93 36 Web: http://www.bmby.com machine i386 cpu I486_CPU cpu I586_CPU cpu I686_CPU ident GENERIC # To statically compile in device wiring instead of /boot/device.hints #hints GENERIC.hints # Default places to look for devices. options SMP # Multi-Processor options SCHED_4BSD # 4BSD scheduler options INET# InterNETworking options FFS # Berkeley Fast Filesystem options SOFTUPDATES # Enable FFS soft updates support options UFS_ACL # Support for accmachine i386 cpu I486_CPU cpu I586_CPU cpu I686_CPU ident BMBY # To statically compile in device wiring instead of /boot/device.hints #hints GENERIC.hints # Default places to look for devices. options SMP # Multi-Processor options SCHED_4BSD # 4BSD scheduler options INET# InterNETworking options FFS # Berkeley Fast Filesystem options SOFTUPDATES # Enable FFS soft updates support options UFS_ACL # Support for access control lists options UFS_DIRHASH # Improve performance on big directories options MD_ROOT # MD is a potential root device options CD9660 # ISO 9660 Filesystem options PROCFS # Process filesystem (requires PSEUDOFS) options PSEUDOFS# Pseudo-filesystem framework options GEOM_GPT# GUID Partition Tables. options COMPAT_43 # Compatible with BSD 4.3 [KEEP THIS!] options COMPAT_FREEBSD4 # Compatible with FreeBSD4 options SCSI_DELAY=5000 # Delay (in ms) before probing SCSI options KTRACE # ktrace(1) support options SYSVSHM # SYSV-style shared memory options SYSVMSG # SYSV-style message queues options SYSVSEM # SYSV-style semaphores options _KPOSIX_PRIORITY_SCHEDULING # POSIX P1003_1B real-time extensions options KBD_INSTALL_CDEV# install a CDEV entry in /dev #optionsAHC_REG_PRETTY_PRINT# Print register bitfields in debug # output. Adds ~128k to driver. #optionsAHD_REG_PRETTY_PRINT# Print register bitfields in debug # output. Adds ~215k to driver. options ADAPTIVE_GIANT # Giant mutex is adaptive. device apic# I/O APIC # Bus support. Do not remove isa, even if you have no isa slots device isa #device eisa device pci # Floppy drives #device fdc # ATA and ATAPI devices device ata #device atadisk # ATA disk drives #device ataraid # ATA RAID drives device atapicd # ATAPI CDROM drives #device atapifd # ATAPI floppy drives #device atapist # ATAPI tape drives options ATA_STATIC_ID # Static device numbering # SCSI Controllers #device ahb # EISA AHA1742 family #device ahc # AHA2940 and onboard AIC7xxx devices #device ahd # AHA39320/29320 and onboard AIC79xx devices #device amd # AMD 53C974 (Tekram DC-390(T)) #device isp # Qlogic family #device mpt # LSI-Logic MPT-Fusion #device ncr # NCR/Symbios Logic #device sym # NCR/Symbios Logic (newer chipsets + those of `ncr') #device trm # Tekram DC395U/UW/F DC315U adapters #device adv # Advansys SCSI adapters #device adw # Advansys wide SCSI adapters #device aha #
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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-PRERELEASE from March 22 on a Tyan K8SR motherboard dual Opteron system running PostgreSQL 8. I am not ready to rule out hardware problem, though, as I have had a fair number of ethernet port timout+reset reported by the kernel. I shall try disabling SMP to see what happens. It is times like these I wish there was an equivalent to the Dell diagnostics suite for other machines :-( If only Dell would sell Opteron! ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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] 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: [EMAIL PROTECTED] P: +972 4 959 79 89 M: +972 52 374 53 34 F:+972 3 617 93 36 Web: http://www.bmby.com ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 minutes, and the fatal alway indicated to the mysqld process. When I build the kernel without SMP, the system is stable. I have try 5.3-p5 and 5.4-PRE, the problem is still there. It's my configuration mistake or will be solved in 5.4-RELEASE ? There's just not enough information to tell. When you say freeze, is the machine totally unresponsive, or does the console allow you to type characters? Can you ping the system when it appears frozen? Does the system eventually recover if the load is taken away? -- Doug White| FreeBSD: The Power to Serve [EMAIL PROTECTED] | www.FreeBSD.org ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
FreeBSD 5.3 SMP freezes with MySQL 4.1
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 process. When I build the kernel without SMP, the system is stable. I have try 5.3-p5 and 5.4-PRE, the problem is still there. It's my configuration mistake or will be solved in 5.4-RELEASE ? ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD 5.3 SMP freezes with MySQL 4.1
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 indicated to the mysqld process. Does it actually crash or juyst hangs? Which thread options did you use in the port config? Please post your dmseg, mysql log, mysql slow query log. When I build the kernel without SMP, the system is stable. I have try 5.3-p5 and 5.4-PRE, the problem is still there. It's my configuration mistake or will be solved in 5.4-RELEASE ? I'm currently running a mysql 4.10 on a heavy loaded 5.3-RELEASE-p5 production SMP server with no problems at all. U. ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to [EMAIL PROTECTED]