From owner-freebsd-database@FreeBSD.ORG Mon May 15 15:56:03 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E948316AAE1 for ; Mon, 15 May 2006 15:56:02 +0000 (UTC) (envelope-from autoinfo@auto.ru) Received: from auto.ru (auto.ru [81.176.76.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4874C43DB8 for ; Mon, 15 May 2006 15:55:25 +0000 (GMT) (envelope-from autoinfo@auto.ru) Received: from auto.ru (root@localhost) by auto.ru (8.13.6/8.13.6) with SMTP id k4FFtIRw083906 for ; Mon, 15 May 2006 19:55:18 +0400 (MSD) Received: from workstation361 (217-15-50-220.intinform.ru [217.15.50.220] (may be forged)) (authenticated bits=0) by auto.ru (8.13.6/8.13.6) with ESMTP id k4FFtH6N083888 for ; Mon, 15 May 2006 19:55:18 +0400 (MSD) From: "Mike L. Rogalsky" To: Date: Mon, 15 May 2006 19:53:31 +0400 Organization: AUTO.RU Ltd. Message-ID: <049101c67837$b791d500$0132a8c0@AUTORU.AUTO> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2663 thread-index: AcZ4N7c0D2W7ETCJQJSrquW4ucJ33g== Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by auto.ru id k4FFtH6N083888 X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.2/RELEASE, bases: 15052006 #182066, status: clean Subject: MySQL 4.1.19 and FreeBSD 6.1 amd64 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 15 May 2006 15:56:11 -0000 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 Features2=0x649d> AMD Features=0x20100800 AMD Features2=0x1 Cores per package: 2 Logical CPUs per core: 2 real memory = 9395240960 (8960 MB) avail memory = 8294051840 (7909 MB) ACPI APIC Table: 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 irqs 0-23 on motherboard ioapic1 irqs 24-47 on motherboard ioapic2 irqs 48-71 on motherboard kbd0 at kbdmux0 acpi0: 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: on acpi0 cpu1: on acpi0 cpu2: on acpi0 cpu3: on acpi0 pcib0: port 0xcf8-0xcff on acpi0 pci0: on pcib0 pci0: at device 0.1 (no driver attached) pci0: at device 1.0 (no driver attached) pcib1: irq 16 at device 2.0 on pci0 pci1: on pcib1 pcib2: at device 0.0 on pci1 pci2: on pcib2 em0: port 0x2000-0x203f mem 0xd4200000-0xd421ffff irq 30 at device 3.0 on pci2 em0: Ethernet address: 00:30:48:2e:a5:5c em1: port 0x2040-0x207f mem 0xd4220000-0xd423ffff irq 31 at device 3.1 on pci2 em1: Ethernet address: 00:30:48:2e:a5:5d pci1: at device 0.1 (no driver attached) pcib3: at device 0.2 on pci1 pci3: on pcib3 aac0: 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: on aac0 aacp1: on aac0 aacp2: on aac0 pci1: at device 0.3 (no driver attached) pcib4: irq 16 at device 4.0 on pci0 pci4: on pcib4 pcib5: irq 16 at device 6.0 on pci0 pci5: on pcib5 uhci0: port 0x1400-0x141f irq 16 at device 29.0 on pci0 uhci0: [GIANT-LOCKED] usb0: 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: port 0x1420-0x143f irq 19 at device 29.1 on pci0 uhci1: [GIANT-LOCKED] usb1: 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: port 0x1440-0x145f irq 18 at device 29.2 on pci0 uhci2: [GIANT-LOCKED] usb2: 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: port 0x1460-0x147f irq 16 at device 29.3 on pci0 uhci3: [GIANT-LOCKED] usb3: 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: 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: on ehci0 usb4: 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: at device 30.0 on pci0 pci6: on pcib6 pci6: at device 1.0 (no driver attached) isab0: at device 31.0 on pci0 isa0: on isab0 atapci0: port 0x1f0-0x1f7,0x3f6,0x170-0x177,0x376,0x14a0-0x14af at device 31.1 on pci0 ata0: on atapci0 ata1: on atapci0 pci0: at device 31.3 (no driver attached) acpi_button0: on acpi0 atkbdc0: port 0x60,0x64 irq 1 on acpi0 fdc0: port 0x3f0-0x3f5,0x3f7 irq 6 drq 2 on acpi0 fdc0: [FAST] fd0: <1440-KB 3.5" drive> on fdc0 drive 0 orm0: at iomem 0xc0000-0xc7fff,0xc8000-0xc8fff,0xc9000-0xccfff on isa0 sc0: at flags 0x100 on isa0 sc0: VGA <16 virtual consoles, flags=0x300> vga0: at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0 Timecounters tick every 1.000 msec acd0: CDROM at ata1-master UDMA33 aacd0: 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