Date: Fri, 10 Jun 2005 19:06:43 -0700 (PDT) From: Jon Dama <jd@ugcs.caltech.edu> To: Tom Gidden <gid@lonres.com> Cc: freebsd-stable@freebsd.org, Kris Kennaway <kris@obsecurity.org> Subject: Re: FreeBSD MySQL still WAY slower than Linux Message-ID: <Pine.LNX.4.53.0506101901070.10369@cruzeiro.ugcs.caltech.edu> In-Reply-To: <4B1B3966-97A7-4EE7-8C8B-E1941EEC0C1F@lonres.com> References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com> <20050610170537.GA67849@bibipentium.lonres.com> <20050610171758.GB91671@xor.obsecurity.org> <4B1B3966-97A7-4EE7-8C8B-E1941EEC0C1F@lonres.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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<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> > real memory = 3489398784 (3327 MB) > avail memory = 3418517504 (3260 MB) > ACPI APIC Table: <DELL PE BKC > > 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 <Version 2.0> irqs 0-23 on motherboard > ioapic1 <Version 2.0> irqs 32-55 on motherboard > ioapic2 <Version 2.0> irqs 64-87 on motherboard > ioapic3 <Version 2.0> irqs 96-119 on motherboard > npx0: <math processor> on motherboard > npx0: INT 16 interface > acpi0: <DELL PE BKC> 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: <ACPI CPU> on acpi0 > pcib0: <ACPI Host-PCI bridge> port 0xcf8-0xcff on acpi0 > pci0: <ACPI PCI bus> on pcib0 > pcib1: <ACPI PCI-PCI bridge> 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 > amr0: <LSILogic MegaRAID 1.51> mem 0xdfec0000-0xdfefffff, > 0xd80f0000-0xd80fffff irq 46 at device 14.0 on pci2 > amr0: <LSILogic PERC 4e/Di> Firmware 513O, BIOS H418, 256MB RAM > pcib3: <ACPI PCI-PCI bridge> at device 0.2 on pci1 > pci3: <ACPI PCI bus> on pcib3 > pcib4: <ACPI PCI-PCI bridge> at device 4.0 on pci0 > pci4: <ACPI PCI bus> on pcib4 > pcib5: <ACPI PCI-PCI bridge> at device 5.0 on pci0 > pci5: <ACPI PCI bus> on pcib5 > pcib6: <ACPI PCI-PCI bridge> at device 0.0 on pci5 > pci6: <ACPI PCI bus> on pcib6 > em0: <Intel(R) PRO/1000 Network Connection, Version - 1.7.35> 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: <ACPI PCI-PCI bridge> at device 0.2 on pci5 > pci7: <ACPI PCI bus> on pcib7 > em1: <Intel(R) PRO/1000 Network Connection, Version - 1.7.35> 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: <ACPI PCI-PCI bridge> at device 6.0 on pci0 > pci8: <ACPI PCI bus> on pcib8 > pcib9: <ACPI PCI-PCI bridge> at device 0.0 on pci8 > pci9: <ACPI PCI bus> on pcib9 > pcib10: <ACPI PCI-PCI bridge> at device 0.2 on pci8 > pci10: <ACPI PCI bus> on pcib10 > pcib11: <ACPI PCI-PCI bridge> at device 30.0 on pci0 > pci11: <ACPI PCI bus> on pcib11 > pci11: <display, VGA> at device 13.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 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: <Keyboard controller (i8042)> port 0x64,0x60 irq 1 on acpi0 > atkbd0: <AT Keyboard> 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: <ISA Option ROMs> at iomem 0xec000-0xeffff,0xc0000-0xcafff 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 > 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 <SAMSUNG CD-ROM SN-124/N104> at ata0-master PIO4 > amrd0: <LSILogic MegaRAID logical drive> on amr0 > amrd0: 419700MB (859545600 sectors) RAID 5 (optimal) > ses0 at amr0 bus 0 target 6 lun 0 > ses0: <PE/PV 1x6 SCSI BP 1.0> 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" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.LNX.4.53.0506101901070.10369>