FreeBSD MySQL still WAY slower than Linux
Jon Dama
jd at ugcs.caltech.edu
Sat Jun 11 02:06:46 GMT 2005
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 at 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"
>
More information about the freebsd-stable
mailing list