From owner-freebsd-stable@FreeBSD.ORG Sat Jun 11 02:06:46 2005 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9D70D16A41C for ; Sat, 11 Jun 2005 02:06:46 +0000 (GMT) (envelope-from jd@ugcs.caltech.edu) Received: from cruzeiro.ugcs.caltech.edu (cruzeiro.ugcs.caltech.edu [131.215.176.113]) by mx1.FreeBSD.org (Postfix) with ESMTP id 54FAB43D1F for ; Sat, 11 Jun 2005 02:06:46 +0000 (GMT) (envelope-from jd@ugcs.caltech.edu) Received: by cruzeiro.ugcs.caltech.edu (Postfix, from userid 3640) id AA6DF88036; Fri, 10 Jun 2005 19:06:43 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by cruzeiro.ugcs.caltech.edu (Postfix) with ESMTP id 7B3B136806; Fri, 10 Jun 2005 19:06:43 -0700 (PDT) Date: Fri, 10 Jun 2005 19:06:43 -0700 (PDT) From: Jon Dama To: Tom Gidden In-Reply-To: <4B1B3966-97A7-4EE7-8C8B-E1941EEC0C1F@lonres.com> Message-ID: References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> <20050610171758.GB91671@xor.obsecurity.org> <4B1B3966-97A7-4EE7-8C8B-E1941EEC0C1F@lonres.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Cc: freebsd-stable@freebsd.org, Kris Kennaway Subject: Re: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 11 Jun 2005 02:06:46 -0000 Try linking mysql with ptmalloc2 (instead of the system malloc obviously). Doing this has the side-benefit of ensuring that you don't need to mess with MAXDSIZ. Try linking mysql with david xu's threading library. -Jon On Fri, 10 Jun 2005, Tom Gidden wrote: > Hi Kris, > > On 10 Jun 2005, at 18:17, Kris Kennaway wrote: > > > Show your kernel config etc. > > I've been working with Steve on this project. We've been playing > with various tuning factors, including kernel changes, different > stripe sizes on the RAID, "my.cnf" tuning, libmap.conf, and although > we can gain a bit here and there, we can't account for the doubling > of performance with Gentoo. Anyway, I've included the dmesg and > kernel config. > > The Gentoo install was pretty vanilla-flavoured, as neither Steve or > I had installed Gentoo before, and both of us are pretty rusty on any > form of Linux. > > Incidentally, this does not seem to be I/O-bound. The data is big > enough to stay in the table cache anyway. > > I just noticed these particular tests were done on FreeBSD without > HTT, whereas the Gentoo test was. However, I can tell you that in > earlier runs, the difference between HTT and non-HTT on FreeBSD for > this benchmark was negligible. > > Regards, > Tom > > --- [snip] --- > > 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-STABLE #0: Thu Jun 9 09:13:03 BST 2005 > root@lithium.lonres.com:/usr/src/sys/i386/compile/PE2850_i386_4 > Timecounter "i8254" frequency 1193182 Hz quality 0 > CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2793.01-MHz 686-class CPU) > Origin = "GenuineIntel" Id = 0xf41 Stepping = 1 > > Features=0xbfebfbff ,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE> > real memory = 3489398784 (3327 MB) > avail memory = 3418517504 (3260 MB) > ACPI APIC Table: > ioapic0: Changing APIC ID to 7 > ioapic1: Changing APIC ID to 8 > ioapic1: WARNING: intbase 32 != expected base 24 > ioapic2: Changing APIC ID to 9 > ioapic2: WARNING: intbase 64 != expected base 56 > ioapic3: Changing APIC ID to 10 > ioapic3: WARNING: intbase 96 != expected base 88 > ioapic0 irqs 0-23 on motherboard > ioapic1 irqs 32-55 on motherboard > ioapic2 irqs 64-87 on motherboard > ioapic3 irqs 96-119 on motherboard > npx0: on motherboard > npx0: INT 16 interface > acpi0: on motherboard > acpi0: Power Button (fixed) > Timecounter "ACPI-fast" frequency 3579545 Hz quality 1000 > acpi_timer0: <24-bit timer at 3.579545MHz> port 0x808-0x80b on acpi0 > cpu0: on acpi0 > pcib0: port 0xcf8-0xcff on acpi0 > pci0: on pcib0 > pcib1: at device 2.0 on pci0 > pci1: on pcib1 > pcib2: at device 0.0 on pci1 > pci2: on pcib2 > amr0: mem 0xdfec0000-0xdfefffff, > 0xd80f0000-0xd80fffff irq 46 at device 14.0 on pci2 > amr0: Firmware 513O, BIOS H418, 256MB RAM > pcib3: at device 0.2 on pci1 > pci3: on pcib3 > pcib4: at device 4.0 on pci0 > pci4: on pcib4 > pcib5: at device 5.0 on pci0 > pci5: on pcib5 > pcib6: at device 0.0 on pci5 > pci6: on pcib6 > em0: port > 0xecc0-0xecff mem 0xdfbe0000-0xdfbfffff irq 64 at device 7.0 on pci6 > em0: Ethernet address: 00:11:43:ec:b1:7f > em0: Speed:N/A Duplex:N/A > pcib7: at device 0.2 on pci5 > pci7: on pcib7 > em1: port > 0xdcc0-0xdcff mem 0xdf9e0000-0xdf9fffff irq 65 at device 8.0 on pci7 > em1: Ethernet address: 00:11:43:ec:b1:80 > em1: Speed:N/A Duplex:N/A > pcib8: at device 6.0 on pci0 > pci8: on pcib8 > pcib9: at device 0.0 on pci8 > pci9: on pcib9 > pcib10: at device 0.2 on pci8 > pci10: on pcib10 > pcib11: at device 30.0 on pci0 > pci11: on pcib11 > pci11: at device 13.0 (no driver attached) > isab0: at device 31.0 on pci0 > isa0: on isab0 > atapci0: port 0xfc00-0xfc0f, > 0x376,0x170-0x177,0x3f6,0x1f0-0x1f7 at device 31.1 on pci0 > ata0: channel #0 on atapci0 > ata1: channel #1 on atapci0 > atkbdc0: port 0x64,0x60 irq 1 on acpi0 > atkbd0: irq 1 on atkbdc0 > kbd0 at atkbd0 > sio0: <16550A-compatible COM port> port 0x3f8-0x3ff irq 4 flags 0x10 > on acpi0 > sio0: type 16550A > orm0: at iomem 0xec000-0xeffff,0xc0000-0xcafff 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 > sio1: configured irq 3 not in bitmap of probed irqs 0 > sio1: port may not be enabled > Timecounter "TSC" frequency 2793011648 Hz quality 800 > Timecounters tick every 10.000 msec > acd0: CDROM at ata0-master PIO4 > amrd0: on amr0 > amrd0: 419700MB (859545600 sectors) RAID 5 (optimal) > ses0 at amr0 bus 0 target 6 lun 0 > ses0: Fixed Processor SCSI-2 device > ses0: SAF-TE Compliant Device > Mounting root from ufs:/dev/amrd0s1a > em0: Link is up 100 Mbps Full Duplex > > --- [snip] --- > > # $FreeBSD: src/sys/i386/conf/GENERIC,v 1.413 2004/08/11 01:34:18 > rwatson Exp $ > > machine i386 > cpu I686_CPU > ident PE2850_i386_4 > > options MAXDSIZ=(2048UL*1024*1024) > > options SCHED_4BSD > 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 MSDOSFS # MSDOS Filesystem > 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=2000 # 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 > options ADAPTIVE_GIANT # Giant mutex is adaptive. > > options CPU_FASTER_5X86_FPU > options SMP # Symmetric MultiProcessor Kernel > device apic # I/O APIC > > device isa > device pci > > device ata > device atadisk # ATA disk drives > device atapicd # ATAPI CDROM drives > options ATA_STATIC_ID # Static device numbering > > device scbus # SCSI bus (required for SCSI) > device da # Direct Access (disks) > device cd # CD > device pass # Passthrough device (direct SCSI access) > device ses # SCSI Environmental Services (and SAF-TE) > > device amr # AMI MegaRAID (incl. PERC 4/Di, 4e/Di?) > > device atkbdc # AT keyboard controller > device atkbd # AT keyboard > > device vga # VGA video card driver > device sc > device agp # support several AGP chipsets > > device npx > > device sio # 8250, 16[45]50 based serial ports > > # PCI Ethernet NICs. > device miibus # MII bus support > device em # PowerEdge 2850 onboard > device fxp > device xl > > device loop # Network loopback > device mem # Memory and kernel memory devices > device io # I/O device > device random # Entropy device > device ether # Ethernet support > device ppp # Kernel PPP > device tun # Packet tunnel. > device pty # Pseudo-ttys (telnet etc) > device md # Memory "disks" > device gif # IPv6 and IPv4 tunneling > device bpf > > > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >