From owner-freebsd-performance@FreeBSD.ORG Sat Jun 25 17:26:31 2005 Return-Path: X-Original-To: performance@freebsd.org Delivered-To: freebsd-performance@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D8BC916A41C for ; Sat, 25 Jun 2005 17:26:31 +0000 (GMT) (envelope-from shawnm@iodamedia.net) Received: from kcmop04.iodamedia.net (kcmop04.iodamedia.net [66.39.199.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id 41D3543D53 for ; Sat, 25 Jun 2005 17:26:31 +0000 (GMT) (envelope-from shawnm@iodamedia.net) Received: from localhost (localhost.iodamedia.net [127.0.0.1]) by kcmop04.iodamedia.net (Postfix) with ESMTP id 9BD26204F46; Sat, 25 Jun 2005 12:26:28 -0500 (CDT) Received: from kcmop04.iodamedia.net ([127.0.0.1]) by localhost (kcmop04.iodamedia.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14287-06; Sat, 25 Jun 2005 12:26:23 -0500 (CDT) Received: from zeus (CPE-65-30-37-142.kc.res.rr.com [65.30.37.142]) by kcmop04.iodamedia.net (Postfix) with ESMTP id 42DAD204E1F; Sat, 25 Jun 2005 12:26:23 -0500 (CDT) From: "Shawn Mitchell" To: "'Michael Vince'" , "'Steve Roome'" Date: Sat, 25 Jun 2005 12:26:22 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 In-reply-to: <42BD64F1.4080001@roq.com> Thread-Index: AcV5jzI7npYbBzO7QdWJDwdYsulbqQAGmNXQ Message-Id: <20050625172623.42DAD204E1F@kcmop04.iodamedia.net> X-Virus-Scanned: amavisd-new at kcmop04.iodamedia.net Cc: performance@freebsd.org Subject: RE: FreeBSD MySQL still WAY slower than Linux X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 25 Jun 2005 17:26:32 -0000 I tested a MySQL install on a Dell 6600. It's specs were 8 GB ram, 12 x 73 15k rpm drives (Ultra320) on a RAID5, 4 Xeon MP w/ 2 meg of cache, HT enabled so the OS saw 8 CPU's. Every time, a stock linux install (SuSE, CentOS, and Fedora) were always faster than FreeBSD stock, or custom kernel utilizing different options. I never could fully benchmark it running on Linux; as I never got the server to max out before my benchmarking machine maxed out. If your using 4.x, add these to your config file options MAXDSIZ="(256*1024*1024)" options MAXSSIZ="(256*1024*1024)" options DFLDSIZ="(256*1024*1024)" I noticed a HUGE difference on FreeBSD with those added, but it still doesn't crank up there with Linux. Also, default linux install's do not make it use more ram. You still have to copy one of the my-xxx.cnf files over to /etc/my.cnf or /usr/local/etc/my.cnf MySQL is developed on Linux, and ported to FreeBSD. That's the best explanation you'll get probably. -----Original Message----- From: owner-freebsd-performance@freebsd.org [mailto:owner-freebsd-performance@freebsd.org] On Behalf Of Michael Vince Sent: Saturday, June 25, 2005 9:07 AM To: Steve Roome Cc: performance@freebsd.org Subject: Re: FreeBSD MySQL still WAY slower than Linux Your posting a lot of configuration here except the most easily important one for performance in MySQL, thats your my.cnf configuration file You will more then double your performance if you just start off by copying /usr/local/share/mysql/my-large.cnf to /var/db/mysql MySQL out of the box setup to use a tiny amount of ram and it wouldn't surprise me if a lot of Linux distributions have a much more high performance my.cnf file since most distributions are aimed at people who don't know what they are doing. Steve Roome wrote: >Oops, here's what I was supposed to attach to the email with test results in it. > >Sorry about that, > > Steve Roome > >######################################################################## >/etc/make.conf >######################################################################## > >WITHOUT_X11=yes >WITHOUT_NLS=yes > >CFLAGS?=-O3 -pipe >CPUTYPE?=p4 >KERNCONF?=PE2650_i386_steve >NO_PROFILE=true > >MASTER_SITE_BACKUP?= ftp://ftp.uk.freebsd.org/pub/FreeBSD/ports/distfiles/${DIST_SUBDIR}/ >MASTER_SITE_OVERRIDE?= ${MASTER_SITE_BACKUP} > >SUP_UPDATE=yes >SUP=/usr/local/bin/cvsup >SUPFLAGS=-g -L 2 >SUPHOST=cvsup.uk.FreeBSD.org >SUPFILE=/usr/src/supfile >PORTSSUPFILE=/usr/ports/ports-supfile ># added by use.perl 2005-06-23 10:21:11 >PERL_VER=5.8.6 >PERL_VERSION=5.8.6 > > >######################################################################## ># Kernel configuration >######################################################################## ># $FreeBSD: src/sys/i386/conf/GENERIC,v 1.413.2.8 2004/10/24 17:42:08 scottl Exp $ > >machine i386 >cpu I686_CPU >ident PE2650_i386_1 > >options MAXDSIZ=(2048UL*1024*1024) > >options SCHED_4BSD # 4BSD scheduler >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 ># can be dynamically loaded: options NFSCLIENT # Network Filesystem Client ># can be dynamically loaded: options NFSSERVER # Network Filesystem Server ># can be dynamically loaded: options MSDOSFS # MSDOS Filesystem ># can be dynamically loaded: options CD9660 # ISO 9660 Filesystem ># can be dynamically loaded: 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=1000 # 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 SMP >device apic # I/O APIC > >device isa >device pci > >device fdc > >device ata >device atapicd # ATAPI CDROM drives >options ATA_STATIC_ID # Static device numbering > >device scbus # SCSI bus (required for SCSI) ># can be dynamically loaded: device ch # SCSI media changers >device da # Direct Access (disks) ># can be dynamically loaded: device sa # Sequential Access (tape etc) >device pass # Passthrough device (direct SCSI access) ># can be dynamically loaded: device ses # SCSI Environmental Services (and SAF-TE) > >device aac # Adaptec FSA RAID >device aacp # SCSI passthrough for aac (requires CAM) > >device atkbdc # AT keyboard controller >device atkbd # AT keyboard > >device vga # VGA video card driver >device sc ># can be dynamically loaded: device agp # support several AGP chipsets >device npx >device sio # 8250, 16[45]50 based serial ports > >device miibus # MII bus support >device bge # Broadcom BCM570xx Gigabit Ethernet > >device loop # Network loopback >device mem # Memory and kernel memory devices >device io # I/O device >device random # Entropy device >device ether # Ethernet support ># can be dynamically loaded: device ppp # Kernel PPP ># can be dynamically loaded: device tun # Packet tunnel. >device pty # Pseudo-ttys (telnet etc) >device md # Memory "disks" >device gif # IPv6 and IPv4 tunneling >device bpf # Berkeley packet filter >device amr >device em > > >######################################################################## ># dmesg output >######################################################################## > > >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 6.0-CURRENT #2: Wed Jun 22 17:30:47 BST 2005 > root@unoctbium.lonres.com:/usr/obj/usr/src/sys/PE2650_i386_steve >ACPI APIC Table: >Timecounter "i8254" frequency 1193182 Hz quality 0 >CPU: Intel(R) Xeon(TM) CPU 2.80GHz (2793.01-MHz 686-class CPU) > Origin = "GenuineIntel" Id = 0xf34 Stepping = 4 > Features=0xbfebfbff > Features2=0x441d> >real memory = 3489398784 (3327 MB) >avail memory = 3419168768 (3260 MB) >FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs > cpu0 (BSP): APIC ID: 0 > cpu1 (AP): APIC ID: 6 >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: [FAST] >npx0: on motherboard >npx0: INT 16 interface >acpi0: on motherboard >acpi0: Power Button (fixed) >pci_link0: irq 7 on acpi0 >pci_link1: irq 5 on acpi0 >pci_link2: irq 10 on acpi0 >pci_link3: on acpi0 >pci_link4: on acpi0 >pci_link5: on acpi0 >pci_link6: on acpi0 >pci_link7: on acpi0 >Timecounter "ACPI-fast" frequency 3579545 Hz quality 1000 >acpi_timer0: <24-bit timer at 3.579545MHz> port 0x808-0x80b on acpi0 >cpu0: on acpi0 >cpu1: 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 0xd80f0000-0xd80fffff,0xdfec0000-0xdfefffff 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:33:9c:e3 >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:33:9c:e4 >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 0x1f0-0x1f7,0x3f6,0x170-0x177,0x376,0xfc00-0xfc0f at device 31.1 on pci0 >ata0: on atapci0 >ata1: on atapci0 >fdc0: port 0x3f0-0x3f5,0x3f7 irq 6 drq 2 on acpi0 >fdc0: [FAST] >fd0: <1440-KB 3.5" drive> on fdc0 drive 0 >atkbdc0: port 0x60,0x64 irq 1 on acpi0 >atkbd0: irq 1 on atkbdc0 >kbd0 at atkbd0 >atkbd0: [GIANT-LOCKED] >sio0: <16550A-compatible COM port> port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0 >sio0: type 16550A >orm0: at iomem 0xc0000-0xcafff,0xec000-0xeffff 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 >Timecounters tick every 1.000 msec >acd0: CDROM at ata0-master UDMA33 >pass0 at amr0 bus 0 target 6 lun 0 >pass0: Fixed Processor SCSI-2 device >amrd0: on amr0 >amrd0: 69360MB (142049280 sectors) RAID 5 (optimal) >amrd1: on amr0 >amrd1: 69360MB (142049280 sectors) RAID 5 (optimal) >SMP: AP CPU #1 Launched! >Trying to mount root from ufs:/dev/amrd0s1a >em0: link state changed to UP >_______________________________________________ >freebsd-performance@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-performance >To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org" > > _______________________________________________ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"