Date: Mon, 15 May 2006 19:53:31 +0400 From: "Mike L. Rogalsky" <autoinfo@auto.ru> To: <freebsd-database@freebsd.org> Subject: MySQL 4.1.19 and FreeBSD 6.1 amd64 Message-ID: <049101c67837$b791d500$0132a8c0@AUTORU.AUTO>
next in thread | raw e-mail | index | archive | help
I have 2 identical servers: Super Micro SYS-6014H-32÷ 1U (http://www.supermicro.com/products/system/1U/6014/SYS-6014H-32.cfm) Super X6DHR-3G2 Motherboard Dual CPU Intel P4 Xeon D 2,8Ghz 2*2Mb cache 800 fsb (PAXVILLE)*2 DDR2 2Gb ECC reg 400MHZ*4 SM SNK-P0009 1U, Nocona CEK Passive Heatsink*2 Supermicro Socket DIMM All-in-One Zero-Channel RAID Card (AOC-SOZCR1) with 3 SAS disk in RAID-5 (http://www.supermicro.com/products/accessories/addon/AOC-SOZCR1.cfm) Kernel - GENERIC and : options SMP options MAXDSIZ=(1024UL*1024*1024) options MAXSSIZ=(128UL*1024*1024) options DFLDSIZ=(1024UL*1024*1024) options VM_KMEM_SIZE_MAX="(1024*1024*1024)" Copyright (c) 1992-2006 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 6.1-RELEASE #1: Fri May 12 14:51:03 MSD 2006 auto@neptun:/usr/obj/usr/src/sys/MYSQL Timecounter "i8254" frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2811.31-MHz K8-class CPU) Origin = "GenuineIntel" Id = 0xf48 Stepping = 8 Features=0xbfebfbff<FPU,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> Features2=0x649d<SSE3,RSVD2,MON,DS_CPL,EST,CNTX-ID,CX16,<b14>> AMD Features=0x20100800<SYSCALL,NX,LM> AMD Features2=0x1<LAHF> Cores per package: 2 Logical CPUs per core: 2 real memory = 9395240960 (8960 MB) avail memory = 8294051840 (7909 MB) ACPI APIC Table: <PTLTD APIC > FreeBSD/SMP: Multiprocessor System Detected: 8 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu2 (AP): APIC ID: 2 cpu3 (AP): APIC ID: 3 cpu4 (AP): APIC ID: 4 cpu5 (AP): APIC ID: 5 cpu6 (AP): APIC ID: 6 cpu7 (AP): APIC ID: 7 ioapic0 <Version 2.0> irqs 0-23 on motherboard ioapic1 <Version 2.0> irqs 24-47 on motherboard ioapic2 <Version 2.0> irqs 48-71 on motherboard kbd0 at kbdmux0 acpi0: <PTLTD RSDT> on motherboard acpi0: Power Button (fixed) Timecounter "ACPI-fast" frequency 3579545 Hz quality 1000 acpi_timer0: <24-bit timer at 3.579545MHz> port 0x1008-0x100b on acpi0 cpu0: <ACPI CPU> on acpi0 cpu1: <ACPI CPU> on acpi0 cpu2: <ACPI CPU> on acpi0 cpu3: <ACPI CPU> on acpi0 pcib0: <ACPI Host-PCI bridge> port 0xcf8-0xcff on acpi0 pci0: <ACPI PCI bus> on pcib0 pci0: <unknown> at device 0.1 (no driver attached) pci0: <base peripheral> at device 1.0 (no driver attached) pcib1: <ACPI PCI-PCI bridge> irq 16 at device 2.0 on pci0 pci1: <ACPI PCI bus> on pcib1 pcib2: <ACPI PCI-PCI bridge> at device 0.0 on pci1 pci2: <ACPI PCI bus> on pcib2 em0: <Intel(R) PRO/1000 Network Connection Version - 3.2.18> port 0x2000-0x203f mem 0xd4200000-0xd421ffff irq 30 at device 3.0 on pci2 em0: Ethernet address: 00:30:48:2e:a5:5c em1: <Intel(R) PRO/1000 Network Connection Version - 3.2.18> port 0x2040-0x207f mem 0xd4220000-0xd423ffff irq 31 at device 3.1 on pci2 em1: Ethernet address: 00:30:48:2e:a5:5d pci1: <base peripheral, interrupt controller> at device 0.1 (no driver attached) pcib3: <ACPI PCI-PCI bridge> at device 0.2 on pci1 pci3: <ACPI PCI bus> on pcib3 aac0: <Adaptec SAS RAID 4000SAS> mem 0xd5000000-0xd5ffffff,0xd4400000-0xd45fffff,0xdc000000-0xdfffffff irq 58 at device 3.0 on pci3 aac0: Enabling 64-bit address support aac0: New comm. interface enabled aac0: Adaptec Raid Controller 2.0.0-1 aacp0: <SCSI Passthrough Bus> on aac0 aacp1: <SCSI Passthrough Bus> on aac0 aacp2: <SCSI Passthrough Bus> on aac0 pci1: <base peripheral, interrupt controller> at device 0.3 (no driver attached) pcib4: <ACPI PCI-PCI bridge> irq 16 at device 4.0 on pci0 pci4: <ACPI PCI bus> on pcib4 pcib5: <ACPI PCI-PCI bridge> irq 16 at device 6.0 on pci0 pci5: <ACPI PCI bus> on pcib5 uhci0: <Intel 82801EB (ICH5) USB controller USB-A> port 0x1400-0x141f irq 16 at device 29.0 on pci0 uhci0: [GIANT-LOCKED] usb0: <Intel 82801EB (ICH5) USB controller USB-A> on uhci0 usb0: USB revision 1.0 uhub0: Intel UHCI root hub, class 9/0, rev 1.00/1.00, addr 1 uhub0: 2 ports with 2 removable, self powered uhci1: <Intel 82801EB (ICH5) USB controller USB-B> port 0x1420-0x143f irq 19 at device 29.1 on pci0 uhci1: [GIANT-LOCKED] usb1: <Intel 82801EB (ICH5) USB controller USB-B> on uhci1 usb1: USB revision 1.0 uhub1: Intel UHCI root hub, class 9/0, rev 1.00/1.00, addr 1 uhub1: 2 ports with 2 removable, self powered uhci2: <Intel 82801EB (ICH5) USB controller USB-C> port 0x1440-0x145f irq 18 at device 29.2 on pci0 uhci2: [GIANT-LOCKED] usb2: <Intel 82801EB (ICH5) USB controller USB-C> on uhci2 usb2: USB revision 1.0 uhub2: Intel UHCI root hub, class 9/0, rev 1.00/1.00, addr 1 uhub2: 2 ports with 2 removable, self powered uhci3: <Intel 82801EB (ICH5) USB controller USB-D> port 0x1460-0x147f irq 16 at device 29.3 on pci0 uhci3: [GIANT-LOCKED] usb3: <Intel 82801EB (ICH5) USB controller USB-D> on uhci3 usb3: USB revision 1.0 uhub3: Intel UHCI root hub, class 9/0, rev 1.00/1.00, addr 1 uhub3: 2 ports with 2 removable, self powered ehci0: <Intel 82801EB/R (ICH5) USB 2.0 controller> mem 0xd4001000-0xd40013ff irq 23 at device 29.7 on pci0 ehci0: [GIANT-LOCKED] usb4: EHCI version 1.0 usb4: companion controllers, 2 ports each: usb0 usb1 usb2 usb3 usb4: <Intel 82801EB/R (ICH5) USB 2.0 controller> on ehci0 usb4: <Intel 82801EB/R (ICH5) USB 2.0 controller> on ehci0 usb4: USB revision 2.0 uhub4: Intel EHCI root hub, class 9/0, rev 2.00/1.00, addr 1 uhub4: 8 ports with 8 removable, self powered pcib6: <ACPI PCI-PCI bridge> at device 30.0 on pci0 pci6: <ACPI PCI bus> on pcib6 pci6: <display, VGA> at device 1.0 (no driver attached) isab0: <PCI-ISA bridge> at device 31.0 on pci0 isa0: <ISA bus> on isab0 atapci0: <Intel ICH5 UDMA100 controller> port 0x1f0-0x1f7,0x3f6,0x170-0x177,0x376,0x14a0-0x14af at device 31.1 on pci0 ata0: <ATA channel 0> on atapci0 ata1: <ATA channel 1> on atapci0 pci0: <serial bus, SMBus> at device 31.3 (no driver attached) acpi_button0: <Power Button> on acpi0 atkbdc0: <Keyboard controller (i8042)> port 0x60,0x64 irq 1 on acpi0 fdc0: <floppy drive controller> port 0x3f0-0x3f5,0x3f7 irq 6 drq 2 on acpi0 fdc0: [FAST] fd0: <1440-KB 3.5" drive> on fdc0 drive 0 orm0: <ISA Option ROMs> at iomem 0xc0000-0xc7fff,0xc8000-0xc8fff,0xc9000-0xccfff on isa0 sc0: <System console> at flags 0x100 on isa0 sc0: VGA <16 virtual consoles, flags=0x300> vga0: <Generic ISA VGA> at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0 Timecounters tick every 1.000 msec acd0: CDROM <CD-224E/1.9A> at ata1-master UDMA33 aacd0: <RAID 5> on aac0 aacd0: 69199MB (141719552 sectors) SMP: AP CPU #1 Launched! SMP: AP CPU #3 Launched! SMP: AP CPU #5 Launched! SMP: AP CPU #6 Launched! SMP: AP CPU #2 Launched! SMP: AP CPU #4 Launched! SMP: AP CPU #7 Launched! Trying to mount root from ufs:/dev/aacd0s1a On one of them I have put FreeBSD 6.1 amd64, and on another - CentOS 4.3 Linux x86_64. I make MySQL 4.1.19 with patch from ports (patch-sql::mytcpd.h and patch-sql::mysqld.cc) add with this option from src: CFLAGS="-O3 -march=opteron -fno-omit-frame-pointer" export CFLAGS CXXFLAGS="-O3 -march=opteron -fno-omit-frame-pointer -D_THREAD_SAFE" export CXXFLAGS configure \ --with-mysqld-ldflags=-all-static \ --disable-FEATURE \ --without-docs \ --without-bench \ --without-debug \ --without-isam \ --without-extra-tools \ --without-berkeley-db \ --without-libedit \ --enable-local-infile \ --enable-thread-safe-client \ --with-readline \ --with-libwrap \ --with-innodb \ --with-vio \ --with-charset=cp1251 I get congif for MySQL share - my-innodb-heavy-4G.cnf and make same changes in InnoBD section (I use MySQL 4.1.19 on my FreeBSD 4.11 i386 servers in heavy mode). I make slave mode transaction for MySQL database. If I give loading in 80-100 connections in a second the server hangs and ceases to process inquiries. First I have thought on a hard disk and have made a disk in memory (mdconfig -a -t malloc -s 2g + mount). I have placed on it InnoDB bases and InnoDB log files. The result was same... And on CentOS 4.3 Linux x86_64 at me all works normally and stably. In what a problem? WBR, Mike L. Rogalsky http://www.auto.ru
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?049101c67837$b791d500$0132a8c0>