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 From owner-freebsd-database@FreeBSD.ORG Tue May 16 18:37:30 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 C66BD16AFB1 for ; Tue, 16 May 2006 18:37:24 +0000 (UTC) (envelope-from thecoba@gmail.com) Received: from infinity.severen.ru (severen.ru [194.135.30.45]) by mx1.FreeBSD.org (Postfix) with ESMTP id C3AE343D48 for ; Tue, 16 May 2006 18:37:22 +0000 (GMT) (envelope-from thecoba@gmail.com) Received: from dummy.name; Tue, 16 May 2006 22:28:44 +0400 Message-ID: <446A1BD0.8000709@gmail.com> Date: Tue, 16 May 2006 22:37:04 +0400 From: thecoba@gmail.com User-Agent: Thunderbird 1.5.0.2 (X11/20060510) MIME-Version: 1.0 To: "Mike L. Rogalsky" References: <20060516120048.C159E16A51D@hub.freebsd.org> In-Reply-To: <20060516120048.C159E16A51D@hub.freebsd.org> Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: freebsd-database Digest, Vol 95, Issue 1 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: Tue, 16 May 2006 18:38:04 -0000 I got same problem on freebsd 6.0r-p7 with mysql 4.1.18. and same on 4.1.17.. and now seems even on 4.1.19. :-/ recently tried to play with innodb configs but no luck. I have hangs, cores and so on.. ;( > Message: 1 > Date: Mon, 15 May 2006 19:53:31 +0400 > From: "Mike L. Rogalsky" > Subject: MySQL 4.1.19 and FreeBSD 6.1 amd64 > To: > Message-ID: <049101c67837$b791d500$0132a8c0@AUTORU.AUTO> > Content-Type: text/plain; charset="koi8-r" > 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 From owner-freebsd-database@FreeBSD.ORG Thu May 18 14:24:41 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 6CA0216A47F for ; Thu, 18 May 2006 14:24:41 +0000 (UTC) (envelope-from atencio@dksound.de) Received: from bnf.fr (public-gprs25493.centertel.pl [87.96.99.149]) by mx1.FreeBSD.org (Postfix) with SMTP id 2123A43D45 for ; Thu, 18 May 2006 14:24:07 +0000 (GMT) (envelope-from atencio@dksound.de) Message-ID: <000001c67a86$39b11230$aad6a8c0@rhz98> From: "Ireland Atencio" To: freebsd-database@freebsd.org Date: Thu, 18 May 2006 07:20:33 -0700 MIME-Version: 1.0 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Antivirus: avast! (VPS 0620-2, 2006-05-18), Outbound message X-Antivirus-Status: Clean Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: crdit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Ireland Atencio List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 18 May 2006 14:24:54 -0000 Dear Home 0vvner, Your crredit doesn't matter to us! If you OVVN reeal essttate and want IMMEDlATE cassh to sppend ANY way you like, or simply wish to LOVVER your monthly paayments by a third or more, here are the deeals we have TOdDAY: $ 490 , 000 as lovv as 3 , 65 % $ 370 , 000 as lovv as 3 , 90 % $ 250 , 000 as lovv as 3 , 35 % $ 200 , 000 as lovv as 3 , 55 % go to the web site =20 Ireland Atencio , Apprroval Mannager =20 Come on! said Bilbo. I am waiting! He tried to sound bold and cheerful, but he did not feel at all sure how the game was going to end, whether Gollum guessed right or not. Times up! he said.