MySQL 4.1.19 and FreeBSD 6.1 amd64

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



_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[email protected]"