From owner-freebsd-performance@FreeBSD.ORG Mon May 19 16:12:42 2008 Return-Path: Delivered-To: performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9449E106566C; Mon, 19 May 2008 16:12:42 +0000 (UTC) (envelope-from ian@bulinfo.net) Received: from xpcl.grogy.com (c-67-188-149-140.hsd1.ca.comcast.net [67.188.149.140]) by mx1.freebsd.org (Postfix) with ESMTP id 3BB4B8FC1B; Mon, 19 May 2008 16:12:42 +0000 (UTC) (envelope-from ian@bulinfo.net) Received: from xpcl.grogy.com (localhost [127.0.0.1]) by xpcl.grogy.com (8.14.2/8.14.2) with ESMTP id m4JFjfaX083214; Mon, 19 May 2008 08:45:41 -0700 (PDT) (envelope-from ian@bulinfo.net) Message-ID: <4831A0A5.6040808@bulinfo.net> Date: Mon, 19 May 2008 08:45:41 -0700 From: Yani Brankov User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: questions@freebsd.org, performance@freebsd.org Content-Type: multipart/mixed; boundary="------------010205040807060702000408" X-Mailman-Approved-At: Mon, 19 May 2008 16:33:19 +0000 Cc: Subject: Low/Jerky performance in FreeBSD 7 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: Mon, 19 May 2008 16:12:42 -0000 This is a multi-part message in MIME format. --------------010205040807060702000408 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hey guys, I recently updated to FreeBSD 7 and noticed that my box started to perform as windows does under heavier loads. The mouse starts to be jerky when compiling, window updates/redraws are slow and bump the CPU usage up to 100%. I attributed this to the mga driver which comes with the distro in the beginning. However, I later noticed the same happens even when X has not been started. For instance, I start a kernel compile and the console mouse becomes jumpy. All these have never happened before with FreeBSD on this box. It has enough memory (1.5G) and relatively fast CPU (2.5GHz). I started to think this may be originating from kernel level (irq handling, long times in giant locked code during syscalls, etc). I am wondering whether it is only me who has hit this problem or it is more common. It may be also related to hardware configuration, etc. I'm trying to figure out. Attaching my dmesg output in case it's important. Yani --------------010205040807060702000408 Content-Type: text/plain; name="dmesg" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="dmesg" Copyright (c) 1992-2008 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 is a registered trademark of The FreeBSD Foundation. FreeBSD 7.0-RELEASE #0: Sun Feb 24 19:59:52 UTC 2008 root@logan.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC Timecounter "i8254" frequency 1193182 Hz quality 0 CPU: Intel(R) Pentium(R) 4 CPU 2.53GHz (2539.10-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0xf27 Stepping = 7 Features=0xbfebfbff Features2=0x400 real memory = 1610547200 (1535 MB) avail memory = 1564446720 (1491 MB) ACPI APIC Table: ioapic0 irqs 0-23 on motherboard kbd1 at kbdmux0 ath_hal: 0.9.20.3 (AR5210, AR5211, AR5212, RF5111, RF5112, RF2413, RF5413) hptrr: HPT RocketRAID controller driver v1.1 (Feb 24 2008 19:59:27) acpi0: on motherboard acpi0: [ITHREAD] acpi0: Power Button (fixed) acpi0: reservation of 0, a0000 (3) failed acpi0: reservation of 100000, 5fef0000 (3) failed Timecounter "ACPI-fast" frequency 3579545 Hz quality 1000 acpi_timer0: <24-bit timer at 3.579545MHz> port 0x408-0x40b on acpi0 cpu0: on acpi0 p4tcc0: on cpu0 acpi_button0: on acpi0 pcib0: port 0xcf8-0xcff on acpi0 pci0: on pcib0 agp0: on hostb0 pcib1: at device 1.0 on pci0 pci1: on pcib1 vgapci0: mem 0xe4000000-0xe5ffffff,0xe6000000-0xe6003fff,0xe7000000-0xe77fffff irq 16 at device 0.0 on pci1 uhci0: port 0xd800-0xd81f irq 16 at device 29.0 on pci0 uhci0: [GIANT-LOCKED] uhci0: [ITHREAD] usb0: on uhci0 usb0: USB revision 1.0 uhub0: on usb0 uhub0: 2 ports with 2 removable, self powered uhci1: port 0xd000-0xd01f irq 19 at device 29.1 on pci0 uhci1: [GIANT-LOCKED] uhci1: [ITHREAD] usb1: on uhci1 usb1: USB revision 1.0 uhub1: on usb1 uhub1: 2 ports with 2 removable, self powered uhci2: port 0xd400-0xd41f irq 18 at device 29.2 on pci0 uhci2: [GIANT-LOCKED] uhci2: [ITHREAD] usb2: on uhci2 usb2: USB revision 1.0 uhub2: on usb2 uhub2: 2 ports with 2 removable, self powered ehci0: mem 0xe9100000-0xe91003ff irq 23 at device 29.7 on pci0 ehci0: [GIANT-LOCKED] ehci0: [ITHREAD] usb3: EHCI version 1.0 usb3: companion controllers, 2 ports each: usb0 usb1 usb2 usb3: on ehci0 usb3: USB revision 2.0 uhub3: on usb3 uhub3: 6 ports with 6 removable, self powered uhub4: on uhub3 uhub4: single transaction translator uhub4: 2 ports with 1 removable, self powered uhub5: on uhub4 uhub5: multiple transaction translators uhub5: 4 ports with 3 removable, self powered umass0: on uhub5 umass1: on uhub3 pcib2: at device 30.0 on pci0 pci2: on pcib2 rl0: port 0xc000-0xc0ff mem 0xe9000000-0xe90000ff irq 18 at device 6.0 on pci2 miibus0: on rl0 rlphy0: PHY 0 on miibus0 rlphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto rl0: Ethernet address: 00:30:1b:ac:d2:33 rl0: [ITHREAD] fwohci0: port 0xc400-0xc47f mem 0xe9001000-0xe90017ff irq 19 at device 7.0 on pci2 fwohci0: [FILTER] fwohci0: OHCI version 1.0 (ROM=1) fwohci0: No. of Isochronous channels is 8. fwohci0: EUI64 00:30:1b:ac:00:00:d2:97 fwohci0: Phy 1394a available S400, 3 ports. fwohci0: Link S400, max_rec 2048 bytes. firewire0: on fwohci0 fwe0: on firewire0 if_fwe0: Fake Ethernet address: 02:30:1b:00:d2:97 fwe0: Ethernet address: 02:30:1b:00:d2:97 fwip0: on firewire0 fwip0: Firewire address: 00:30:1b:ac:00:00:d2:97 @ 0xfffe00000000, S400, maxrec 2048 sbp0: on firewire0 dcons_crom0: on firewire0 dcons_crom0: bus_addr 0x14b4000 fwohci0: Initiate bus reset fwohci0: BUS reset fwohci0: node_id=0xc800ffc0, gen=1, CYCLEMASTER mode isab0: at device 31.0 on pci0 isa0: on isab0 atapci0: port 0x1f0-0x1f7,0x3f6,0x170-0x177,0x376,0xf000-0xf00f at device 31.1 on pci0 ata0: on atapci0 ata0: [ITHREAD] ata1: on atapci0 ata1: [ITHREAD] pci0: at device 31.3 (no driver attached) pcm0: port 0xe000-0xe0ff,0xe400-0xe43f mem 0xe9101000-0xe91011ff,0xe9102000-0xe91020ff irq 17 at device 31.5 on pci0 pcm0: [ITHREAD] pcm0: acpi_tz0: on acpi0 fdc0: port 0x3f0-0x3f5,0x3f7 irq 6 drq 2 on acpi0 fdc0: [FILTER] sio0: <16550A-compatible COM port> port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0 sio0: type 16550A sio0: [FILTER] sio1: <16550A-compatible COM port> port 0x2f8-0x2ff irq 3 on acpi0 sio1: type 16550A sio1: [FILTER] atkbdc0: port 0x60,0x64 irq 1 on acpi0 atkbd0: irq 1 on atkbdc0 kbd0 at atkbd0 atkbd0: [GIANT-LOCKED] atkbd0: [ITHREAD] psm0: irq 12 on atkbdc0 psm0: [GIANT-LOCKED] psm0: [ITHREAD] psm0: model IntelliMouse Explorer, device ID 4 pmtimer0 on isa0 orm0: at iomem 0xc0000-0xc8fff,0xcc000-0xd3fff pnpid ORM0000 on isa0 ppc0: at port 0x378-0x37f irq 7 on isa0 ppc0: Generic chipset (NIBBLE-only) in COMPATIBLE mode ppbus0: on ppc0 ppbus0: [ITHREAD] plip0: on ppbus0 lpt0: on ppbus0 lpt0: Interrupt-driven port ppi0: on ppbus0 ppc0: [GIANT-LOCKED] ppc0: [ITHREAD] sc0: at flags 0x100 on isa0 sc0: VGA <16 virtual consoles, flags=0x300> vga0: at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0 Timecounter "TSC" frequency 2539103340 Hz quality 800 Timecounters tick every 1.000 msec hptrr: no controller detected. firewire0: 1 nodes, maxhop <= 0, cable IRM = 0 (me) firewire0: bus manager 0 (me) ad0: 476940MB at ata0-master UDMA100 umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR cd0 at umass-sim1 bus 1 target 0 lun 0 cd0: Removable CD-ROM SCSI-0 device cd0: 40.000MB/s transfers cd0: Attempt to query device size failed: NOT READY, Medium not present - tray closed umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR (da0:umass-sim0:0:0:0): got CAM status 0x4 (da0:umass-sim0:0:0:0): fatal error, failed to attach to device (da0:umass-sim0:0:0:0): lost device (da0:umass-sim0:0:0:0): removing device entry da1 at umass-sim0 bus 0 target 0 lun 1 da1: Removable Direct Access SCSI-0 device da1: 40.000MB/s transfers da1: Attempt to query device size failed: NOT READY, Medium not present umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR umass0: BBB reset failed, IOERROR Trying to mount root from ufs:/dev/ad0s1a rl0: link state changed to UP --------------010205040807060702000408-- From owner-freebsd-performance@FreeBSD.ORG Mon May 19 20:52:57 2008 Return-Path: Delivered-To: performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B78411065674; Mon, 19 May 2008 20:52:57 +0000 (UTC) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from wojtek.tensor.gdynia.pl (wojtek.tensor.gdynia.pl [IPv6:2001:4070:101:2::1]) by mx1.freebsd.org (Postfix) with ESMTP id 8EE008FC20; Mon, 19 May 2008 20:52:55 +0000 (UTC) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from wojtek.tensor.gdynia.pl (localhost [IPv6:::1]) by wojtek.tensor.gdynia.pl (8.14.2/8.14.2) with ESMTP id m4JKqj3O007824; Mon, 19 May 2008 22:52:45 +0200 (CEST) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from localhost (wojtek@localhost) by wojtek.tensor.gdynia.pl (8.14.2/8.14.2/Submit) with ESMTP id m4JKqjgg007821; Mon, 19 May 2008 22:52:45 +0200 (CEST) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Date: Mon, 19 May 2008 22:52:45 +0200 (CEST) From: Wojciech Puchar To: Yani Brankov In-Reply-To: <4831A0A5.6040808@bulinfo.net> Message-ID: <20080519225105.C7752@wojtek.tensor.gdynia.pl> References: <4831A0A5.6040808@bulinfo.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Mailman-Approved-At: Mon, 19 May 2008 20:56:39 +0000 Cc: questions@freebsd.org, performance@freebsd.org Subject: Re: Low/Jerky performance in FreeBSD 7 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: Mon, 19 May 2008 20:52:57 -0000 > windows does under heavier loads. The mouse starts to be jerky when > compiling, window updates/redraws are slow and bump the CPU usage up to 100%. it is especially like that when you have heavy disk I/O, with lots of writes. > beginning. However, I later noticed the same happens even when X has not been > started. For instance, I start a kernel compile and the console mouse becomes > jumpy. All these have never happened before with FreeBSD on this box. It has > enough memory (1.5G) and relatively fast CPU (2.5GHz). I started to think that's why i keep 6.3 everywhere. From owner-freebsd-performance@FreeBSD.ORG Mon May 19 21:45:46 2008 Return-Path: Delivered-To: performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 17AF71065674; Mon, 19 May 2008 21:45:46 +0000 (UTC) (envelope-from jhary@unsane.co.uk) Received: from unsane.co.uk (unsane-pt.tunnel.tserv5.lon1.ipv6.he.net [IPv6:2001:470:1f08:110::2]) by mx1.freebsd.org (Postfix) with ESMTP id 8D2118FC0A; Mon, 19 May 2008 21:45:45 +0000 (UTC) (envelope-from jhary@unsane.co.uk) Received: from crab.unsane.co.uk (crab.unsane.co.uk [10.0.0.111]) (authenticated bits=0) by unsane.co.uk (8.14.0/8.14.0) with ESMTP id m4JLjQeQ078172 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 19 May 2008 22:45:26 +0100 (BST) (envelope-from jhary@unsane.co.uk) Message-ID: <4831F4F9.2000302@unsane.co.uk> Date: Mon, 19 May 2008 22:45:29 +0100 From: Vince Hoffman User-Agent: Thunderbird 2.0.0.14 (X11/20080507) MIME-Version: 1.0 To: Yani Brankov References: <4831A0A5.6040808@bulinfo.net> In-Reply-To: <4831A0A5.6040808@bulinfo.net> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mailman-Approved-At: Mon, 19 May 2008 22:16:24 +0000 Cc: questions@freebsd.org, performance@freebsd.org Subject: Re: Low/Jerky performance in FreeBSD 7 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: Mon, 19 May 2008 21:45:46 -0000 Yani Brankov wrote: > Hey guys, Hi > > I recently updated to FreeBSD 7 and noticed that my box started to > perform as windows does under heavier loads. The mouse starts to be > jerky when compiling, window updates/redraws are slow and bump the CPU > usage up to 100%. I attributed this to the mga driver which comes with > the distro in the beginning. However, I later noticed the same happens > even when X has not been started. For instance, I start a kernel compile > and the console mouse becomes jumpy. All these have never happened > before with FreeBSD on this box. It has enough memory (1.5G) and > relatively fast CPU (2.5GHz). I started to think this may be originating > from kernel level (irq handling, long times in giant locked code during > syscalls, etc). > > I am wondering whether it is only me who has hit this problem or it is > more common. It may be also related to hardware configuration, etc. I'm > trying to figure out. > Not just you, http://wiki.freebsd.org/JeremyChadwick/Commonly_reported_issues Vince > Attaching my dmesg output in case it's important. > > Yani > > > ------------------------------------------------------------------------ > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" From owner-freebsd-performance@FreeBSD.ORG Tue May 20 09:16:34 2008 Return-Path: Delivered-To: performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5D35C106566C; Tue, 20 May 2008 09:16:34 +0000 (UTC) (envelope-from alexander@leidinger.net) Received: from redbull.bpaserver.net (redbullneu.bpaserver.net [213.198.78.217]) by mx1.freebsd.org (Postfix) with ESMTP id 115CE8FC2E; Tue, 20 May 2008 09:16:34 +0000 (UTC) (envelope-from alexander@leidinger.net) Received: from outgoing.leidinger.net (p54A57A8F.dip.t-dialin.net [84.165.122.143]) by redbull.bpaserver.net (Postfix) with ESMTP id C38D72E262; Tue, 20 May 2008 10:57:25 +0200 (CEST) Received: from webmail.leidinger.net (webmail.leidinger.net [192.168.1.102]) by outgoing.leidinger.net (Postfix) with ESMTP id E917510F61A; Tue, 20 May 2008 10:57:21 +0200 (CEST) Received: (from www@localhost) by webmail.leidinger.net (8.14.2/8.13.8/Submit) id m4K8vGp4058153; Tue, 20 May 2008 10:57:16 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from pslux.cec.eu.int (pslux.cec.eu.int [158.169.9.14]) by webmail.leidinger.net (Horde Framework) with HTTP; Tue, 20 May 2008 10:57:15 +0200 Message-ID: <20080520105715.18366zzylwkcqzgg@webmail.leidinger.net> X-Priority: 3 (Normal) Date: Tue, 20 May 2008 10:57:15 +0200 From: Alexander Leidinger To: Vince Hoffman References: <4831A0A5.6040808@bulinfo.net> <4831F4F9.2000302@unsane.co.uk> In-Reply-To: <4831F4F9.2000302@unsane.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.2-RC2) / FreeBSD-8.0 X-BPAnet-MailScanner-Information: Please contact the ISP for more information X-BPAnet-MailScanner: Found to be clean X-BPAnet-MailScanner-SpamCheck: not spam, ORDB-RBL, SpamAssassin (not cached, score=-14.9, required 6, BAYES_00 -15.00, RDNS_DYNAMIC 0.10) X-BPAnet-MailScanner-From: alexander@leidinger.net X-Spam-Status: No Cc: Yani Brankov , questions@freebsd.org, performance@freebsd.org Subject: Re: Low/Jerky performance in FreeBSD 7 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: Tue, 20 May 2008 09:16:34 -0000 Quoting Vince Hoffman (from Mon, 19 May 2008 22:45:29 +0100): > > Yani Brankov wrote: >> Hey guys, > Hi >> >> I recently updated to FreeBSD 7 and noticed that my box started to >> perform as windows does under heavier loads. The mouse starts to be Which scheduler? ULE or BSD? Try the other one you use currently. Bye, Alexander. -- Gleemites, n.: Petrified deposits of toothpaste found in sinks. -- Rich Hall & Friends, "Sniglets" http://www.Leidinger.net Alexander @ Leidinger.net: PGP ID = B0063FE7 http://www.FreeBSD.org netchild @ FreeBSD.org : PGP ID = 72077137 From owner-freebsd-performance@FreeBSD.ORG Tue May 20 13:35:45 2008 Return-Path: Delivered-To: performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9DEEA106566C; Tue, 20 May 2008 13:35:45 +0000 (UTC) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from wojtek.tensor.gdynia.pl (wojtek.tensor.gdynia.pl [IPv6:2001:4070:101:2::1]) by mx1.freebsd.org (Postfix) with ESMTP id B498A8FC13; Tue, 20 May 2008 13:35:44 +0000 (UTC) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from wojtek.tensor.gdynia.pl (localhost [IPv6:::1]) by wojtek.tensor.gdynia.pl (8.14.2/8.14.2) with ESMTP id m4KDZWxd016918; Tue, 20 May 2008 15:35:32 +0200 (CEST) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from localhost (wojtek@localhost) by wojtek.tensor.gdynia.pl (8.14.2/8.14.2/Submit) with ESMTP id m4KDZWuS016915; Tue, 20 May 2008 15:35:32 +0200 (CEST) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Date: Tue, 20 May 2008 15:35:32 +0200 (CEST) From: Wojciech Puchar To: Alexander Leidinger In-Reply-To: <20080520105715.18366zzylwkcqzgg@webmail.leidinger.net> Message-ID: <20080520153457.V16901@wojtek.tensor.gdynia.pl> References: <4831A0A5.6040808@bulinfo.net> <4831F4F9.2000302@unsane.co.uk> <20080520105715.18366zzylwkcqzgg@webmail.leidinger.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Mailman-Approved-At: Tue, 20 May 2008 13:37:17 +0000 Cc: Yani Brankov , Vince Hoffman , questions@freebsd.org, performance@freebsd.org Subject: Re: Low/Jerky performance in FreeBSD 7 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: Tue, 20 May 2008 13:35:45 -0000 >>> I recently updated to FreeBSD 7 and noticed that my box started to perform >>> as windows does under heavier loads. The mouse starts to be > > Which scheduler? ULE or BSD? Try the other one you use currently. with any it's slower than 6.3. From owner-freebsd-performance@FreeBSD.ORG Wed May 21 13:28:15 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 42D921065676 for ; Wed, 21 May 2008 13:28:15 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 73BA18FC14 for ; Wed, 21 May 2008 13:28:13 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: (qmail 12016 invoked by uid 45007); 21 May 2008 13:01:32 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 13:01:32 -0000 Received: from 195.149.231.62 (Poczta WWW Kei.pl authenticated user t.pajor@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 15:01:32 +0200 (CEST) Message-ID: From: To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 15:01:32 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 195.149.231.62 X-Http-User-Agent: Opera/9.50 (X11; Linux i686; U; en) X-Mailman-Approved-At: Wed, 21 May 2008 13:37:14 +0000 Subject: mysql performance on freebsd 7 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: Wed, 21 May 2008 13:28:15 -0000 Hello, I'm using mysql 5.1.24-rc in 5 separate jails. Question: 10= clients are pushing queries (10 separate machines). 2 clients to 1 mysql d= aemon. One client is performing an update on param_stat_short_level_1_0, se= cond on param_stat_short_level_1_1. Each client needs to push 150000 que= ries (client is spawning 15 forks to push the 150000, so each fork is pushi= ng 10000, each fork is opening it's own mysql connection). query to push= : INSERT INTO param_stat_short_level_1_0 SET param =3D '10311', object = =3D '10311', value =3D '4283' ON DUPLICATE KEY UPDATE param =3D '10311', ob= ject =3D '10311', value =3D '4283', min =3D IF(4283max,4283,max), counter =3D counter+1; Always a different param, = and object values, value is rand(1,10000). Stats for the operations are = in http://p1.kei.pl/stats. Stats are collected after each clients pushes 1= 50000, 100 times. My point here is that MySQL on Linux (p5) performs 150= 000 queries in an average of 18.1099, when the same queries on FreeBSD (p1)= takes 28.7643. Did I misconfigured something or this are the proper res= ult and FreeBSD just could not give more? My configs below, thanks for Y= our time. http://p1.kei.pl/TLD http://p1.kei.pl/dmesg http://p1.kei.pl= /boot_loader_conf http://p1.kei.pl/sysctl_conf http://p1.kei.pl/my_cnf h= ttp://p1.kei.pl/stats From owner-freebsd-performance@FreeBSD.ORG Wed May 21 14:10:29 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9E16F1065672 for ; Wed, 21 May 2008 14:10:29 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from marvin.harmless.hu (www.ssl.harmless.hu [195.56.55.205]) by mx1.freebsd.org (Postfix) with ESMTP id 525B98FC14 for ; Wed, 21 May 2008 14:10:29 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from fw.publishing.hu ([82.131.181.62] helo=twoflower.in.publishing.hu) by marvin.harmless.hu with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69 (FreeBSD)) (envelope-from ) id 1Jyome-000LEU-7K; Wed, 21 May 2008 15:55:12 +0200 Date: Wed, 21 May 2008 15:55:08 +0200 From: CZUCZY Gergely To: Message-ID: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> In-Reply-To: References: Organization: Harmless Digital X-Mailer: Claws Mail 3.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.2) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/=Rf2Coto30j9VmefrbqNFj6"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 14:10:29 -0000 --Sig_/=Rf2Coto30j9VmefrbqNFj6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable May I ask whether you are using innodb or myisam? both on freebsd and Linux. And what filesystem are you using for mysql's data files? UFS, ZFS or anyth= ing else? IIRC there's some hack to reduce gettimeofday()'s precision in advance to enhance it's performance, that could also help a bit. Have you built your m= ysql with linking it against libthr? On Wed, 21 May 2008 15:01:32 +0200 wrote: > Hello, >=20 > I'm using mysql 5.1.24-rc in 5 separate jails. >=20 > Question: >=20 > 10 clients are pushing queries (10 separate machines). 2 clients to 1 mys= ql > daemon. One client is performing an update on param_stat_short_level_1_0, > second on param_stat_short_level_1_1. >=20 > Each client needs to push 150000 queries (client is spawning 15 forks to = push > the 150000, so each fork is pushing 10000, each fork is opening it's own > mysql connection). >=20 > query to push: >=20 > INSERT INTO param_stat_short_level_1_0 SET param =3D '10311', object =3D = '10311', > value =3D '4283' ON DUPLICATE KEY UPDATE param =3D '10311', object =3D '1= 0311', > value =3D '4283', min =3D IF(4283max,4283= ,max), > counter =3D counter+1; >=20 > Always a different param, and object values, value is rand(1,10000). >=20 > Stats for the operations are in http://p1.kei.pl/stats. > Stats are collected after each clients pushes 150000, 100 times. >=20 > My point here is that MySQL on Linux (p5) performs 150000 queries in an > average of 18.1099, when the same queries on FreeBSD (p1) takes 28.7643. >=20 > Did I misconfigured something or this are the proper result and FreeBSD j= ust > could not give more? >=20 > My configs below, thanks for Your time. >=20 > http://p1.kei.pl/TLD > http://p1.kei.pl/dmesg > http://p1.kei.pl/boot_loader_conf > http://p1.kei.pl/sysctl_conf > http://p1.kei.pl/my_cnf > http://p1.kei.pl/stats >=20 >=20 >=20 > _______________________________________________ > 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" --=20 =C3=9Cdv=C3=B6lettel, Czuczy Gergely Harmless Digital Bt mailto: gergely.czuczy@harmless.hu Tel: +36-30-9702963 --Sig_/=Rf2Coto30j9VmefrbqNFj6 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFINCm+zrC0WyuMkpsRAsBgAJ4+LMK+SgnSftn4uIvfdQKcF+YrYwCfdOfW KdZsmdSgUCozao6LAgdWf1w= =KZ7r -----END PGP SIGNATURE----- --Sig_/=Rf2Coto30j9VmefrbqNFj6-- From owner-freebsd-performance@FreeBSD.ORG Wed May 21 14:22:15 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4C70A10656B3 for ; Wed, 21 May 2008 14:22:15 +0000 (UTC) (envelope-from _pppp@mail.ru) Received: from mx45.mail.ru (mx45.mail.ru [194.67.23.236]) by mx1.freebsd.org (Postfix) with ESMTP id 7FF258FC3A for ; Wed, 21 May 2008 14:22:13 +0000 (UTC) (envelope-from _pppp@mail.ru) Received: from f191.mail.ru (f191.mail.ru [194.67.57.166]) by mx45.mail.ru (mPOP.Fallback_MX) with ESMTP id 2A6B0E00258C for ; Wed, 21 May 2008 18:07:40 +0400 (MSD) Received: from mail by f191.mail.ru with local id 1Jyoyg-000BBM-00; Wed, 21 May 2008 18:07:38 +0400 Received: from [89.175.97.158] by koi.mail.ru with HTTP; Wed, 21 May 2008 18:07:38 +0400 From: Dmitriy <_pppp@mail.ru> To: t.pajor@kei.pl Mime-Version: 1.0 X-Mailer: mPOP Web-Mail 2.19 X-Originating-IP: [89.175.97.158] Date: Wed, 21 May 2008 18:07:38 +0400 References: In-Reply-To: Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 8bit Message-Id: X-Spam: Not detected X-Mras: OK Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Dmitriy <_pppp@mail.ru> List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 May 2008 14:22:15 -0000 > I'm using mysql 5.1.24-rc in 5 separate jails. > > Question: > > 10 clients are pushing queries (10 separate machines). 2 clients to 1 mysql daemon. One client is performing an update on param_stat_short_level_1_0, second on param_stat_short_level_1_1. > > Each client needs to push 150000 queries (client is spawning 15 forks to push the 150000, so each fork is pushing 10000, each fork is opening it's own mysql connection). > > query to push: > > INSERT INTO param_stat_short_level_1_0 SET param = '10311', object = '10311', value = '4283' ON DUPLICATE KEY UPDATE param = '10311', object = '10311', value = '4283', min = IF(4283max,4283,max), counter = counter+1; > > Always a different param, and object values, value is rand(1,10000). > > Stats for the operations are in http://p1.kei.pl/stats. > Stats are collected after each clients pushes 150000, 100 times. > > My point here is that MySQL on Linux (p5) performs 150000 queries in an average of 18.1099, when the same queries on FreeBSD (p1) takes 28.7643. > > Did I misconfigured something or this are the proper result and FreeBSD just could not give more? It would be very helpful if you provided I/O usage as well. I guess the FreeBSD box appears to be I/O-bound. Re-run your benchmarks with noatime mount option on the partition which holds database files (or even make that partition async as some Linux filesystems do). I think Linux outperforms FreeBSD that much in the test because of it's variable sized disk buffer cache (vs FreeBSD's fixed sized one). You can figure out how much data has to be actually written to disk and set vfs.hibufspace, vfs.lobufspace and vfs.maxbufspace sysctls in the /boot/loader.conf appropriately. Other vfs.* sysctls can also be helpful. Regards, Dmitriy. > My configs below, thanks for Your time. > > http://p1.kei.pl/TLD > http://p1.kei.pl/dmesg > http://p1.kei.pl/boot_loader_conf > http://p1.kei.pl/sysctl_conf > http://p1.kei.pl/my_cnf > http://p1.kei.pl/stats From owner-freebsd-performance@FreeBSD.ORG Wed May 21 14:45:10 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 147A0106567A for ; Wed, 21 May 2008 14:45:10 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 447F68FC1E for ; Wed, 21 May 2008 14:45:08 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: (qmail 18251 invoked by uid 45007); 21 May 2008 14:45:07 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 14:45:07 -0000 References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> In-Reply-To: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> Received: from 195.149.231.62 (Poczta WWW Kei.pl authenticated user t.pajor@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 16:45:07 +0200 (CEST) Message-ID: <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> From: To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 16:45:07 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 195.149.231.62 X-Http-User-Agent: Opera/9.50 (X11; Linux i686; U; en) X-Mailman-Approved-At: Wed, 21 May 2008 15:27:10 +0000 Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 14:45:10 -0000 > May I ask whether you are using innodb or myisam? both on freebsd and Lin= ux. > And what filesystem are you using for mysql's data files? UFS, ZFS o= r anything > else? MySQL engine used is MEMORY, filesystem is ufs, but = it's not relevant. =20 > IIRC there's some hack to reduce gettimeofday()'= s precision in advance to > enhance it's performance, that could also help= a bit. What do You mean? > Have you built your mysql with linking it= against libthr? It's a standard build from ports-current. Stats are = at http://p1.kei.pl/mon/ From owner-freebsd-performance@FreeBSD.ORG Wed May 21 16:25:35 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B779F106564A for ; Wed, 21 May 2008 16:25:35 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from marvin.harmless.hu (www.ssl.harmless.hu [195.56.55.205]) by mx1.freebsd.org (Postfix) with ESMTP id 684648FC22 for ; Wed, 21 May 2008 16:25:35 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from pool-0461.adsl.interware.hu ([213.178.101.205] helo=mort.in.publishing.hu) by marvin.harmless.hu with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1Jyr8A-000Ocz-20; Wed, 21 May 2008 18:25:34 +0200 Date: Wed, 21 May 2008 18:25:30 +0200 From: CZUCZY Gergely To: Message-ID: <20080521182530.23c8f787@mort.in.publishing.hu> In-Reply-To: <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> Organization: Harmless Digital Bt X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.1; i386-portbld-freebsd6.3) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/_mRAHXFx=3V+x4cE_FebhMm"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Sender: Czuczy Gergely Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 16:25:35 -0000 --Sig_/_mRAHXFx=3V+x4cE_FebhMm Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 21 May 2008 16:45:07 +0200 wrote: > > May I ask whether you are using innodb or myisam? both on freebsd > > and Linux. And what filesystem are you using for mysql's data > > files? UFS, ZFS or anything else? >=20 > MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant. sure it is relevant. check my results: http://phoemix.harmless.hu/dbtests/ =20 > > IIRC there's some hack to reduce gettimeofday()'s precision in > > advance to enhance it's performance, that could also help a bit. >=20 > What do You mean? I mean what I've told you, no more, no less. google://freebsd+gettimeofday+mysql+tuning > > Have you built your mysql with linking it against libthr? >=20 > It's a standard build from ports-current. Standard build from ports"-current" pops up a dialog called "OPTIONS", where you can set these options. How have you set them? >=20 > Stats are at http://p1.kei.pl/mon/ >=20 >=20 >=20 > _______________________________________________ > 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" --=20 Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. --Sig_/_mRAHXFx=3V+x4cE_FebhMm Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINEz8zrC0WyuMkpsRAjC+AJwLfldpgS7ZwLjEw56C6D6pM5i+mwCcDO/d r+zsKMtyiKOURpvIYDGz9vs= =/rl2 -----END PGP SIGNATURE----- --Sig_/_mRAHXFx=3V+x4cE_FebhMm-- From owner-freebsd-performance@FreeBSD.ORG Wed May 21 17:03:58 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D0D24106567C for ; Wed, 21 May 2008 17:03:58 +0000 (UTC) (envelope-from nikon@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 10E0B8FC0C for ; Wed, 21 May 2008 17:03:57 +0000 (UTC) (envelope-from nikon@kei.pl) Received: (qmail 4187 invoked by uid 45007); 21 May 2008 17:03:55 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 17:03:55 -0000 References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu><3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> <20080521182530.23c8f787@mort.in.publishing.hu> In-Reply-To: <20080521182530.23c8f787@mort.in.publishing.hu> Received: from 77.236.13.109 (Poczta WWW Kei.pl authenticated user nikon@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 19:03:55 +0200 (CEST) Message-ID: <78f2745340c587cd4f000ffac8b3e85f.nikon@kei.pl> From: Tomasz Pajor To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 19:03:55 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 77.236.13.109 X-Http-User-Agent: Opera/9.50 (Windows NT 6.0; U; pl) Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 17:03:58 -0000 > > > May I ask whether you are using innodb or myisam? both on freebsd > = > > and Linux. And what filesystem are you using for mysql's data > > > fi= les? UFS, ZFS or anything else? > >=20 > > MySQL engine used is MEMORY, f= ilesystem is ufs, but it's not relevant. > sure it is relevant. check my r= esults: > http://phoemix.harmless.hu/dbtests/ How the filesystem is rel= evant when tables are in memory? > Standard build from ports"-current" p= ops up a dialog called "OPTIONS", > where you can set these options. How h= ave you set them? env BUILD_OPTIMIZED BUILD_STATIC make install clean From owner-freebsd-performance@FreeBSD.ORG Wed May 21 17:28:48 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 721C1106566C for ; Wed, 21 May 2008 17:28:48 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from marvin.harmless.hu (www.ssl.harmless.hu [195.56.55.205]) by mx1.freebsd.org (Postfix) with ESMTP id 256F18FC12 for ; Wed, 21 May 2008 17:28:48 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from pool-0461.adsl.interware.hu ([213.178.101.205] helo=mort.in.publishing.hu) by marvin.harmless.hu with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1Jys7K-000PvS-LG; Wed, 21 May 2008 19:28:46 +0200 Date: Wed, 21 May 2008 19:28:43 +0200 From: CZUCZY Gergely To: Tomasz Pajor Message-ID: <20080521192843.30ca3833@mort.in.publishing.hu> In-Reply-To: <78f2745340c587cd4f000ffac8b3e85f.nikon@kei.pl> References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> <20080521182530.23c8f787@mort.in.publishing.hu> <78f2745340c587cd4f000ffac8b3e85f.nikon@kei.pl> Organization: Harmless Digital Bt X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.1; i386-portbld-freebsd6.3) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/hpnHH.TjDehp0Y1Xj/gBITA"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Sender: Czuczy Gergely Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 17:28:48 -0000 --Sig_/hpnHH.TjDehp0Y1Xj/gBITA Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 21 May 2008 19:03:55 +0200 Tomasz Pajor wrote: > > > > May I ask whether you are using innodb or myisam? both on > > > > freebsd and Linux. And what filesystem are you using for > > > > mysql's data files? UFS, ZFS or anything else? > > >=20 > > > MySQL engine used is MEMORY, filesystem is ufs, but it's not > > > relevant. > > sure it is relevant. check my results: > > http://phoemix.harmless.hu/dbtests/ >=20 > How the filesystem is relevant when tables are in memory? first, they somehow have to be put into the memory second, for consistency (yeah, this word is missing from toysql-users' vocabulary) it has to write the data to the disk. otherwise you'd lose anything on a crash --=20 Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. --Sig_/hpnHH.TjDehp0Y1Xj/gBITA Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINFvNzrC0WyuMkpsRAgu3AJ495QlJDJBFMQ0vjrSw6BDd3krGhACfR6vR 849K1AWPnxY5TuYldxD8u1o= =vlar -----END PGP SIGNATURE----- --Sig_/hpnHH.TjDehp0Y1Xj/gBITA-- From owner-freebsd-performance@FreeBSD.ORG Wed May 21 17:33:59 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1A310106564A for ; Wed, 21 May 2008 17:33:59 +0000 (UTC) (envelope-from nikon@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 4F3D58FC19 for ; Wed, 21 May 2008 17:33:57 +0000 (UTC) (envelope-from nikon@kei.pl) Received: (qmail 23232 invoked by uid 45007); 21 May 2008 17:33:56 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 17:33:56 -0000 References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu><3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl><20080521182530.23c8f787@mort.in.publishing.hu><78f2745340c587cd4f000ffac8b3e85f.nikon@kei.pl> <20080521192843.30ca3833@mort.in.publishing.hu> In-Reply-To: <20080521192843.30ca3833@mort.in.publishing.hu> Received: from 77.236.13.109 (Poczta WWW Kei.pl authenticated user nikon@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 19:33:56 +0200 (CEST) Message-ID: <257034819c08b52542969ccbf90207fc.nikon@kei.pl> From: Tomasz Pajor To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 19:33:56 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 77.236.13.109 X-Http-User-Agent: Opera/9.50 (Windows NT 6.0; U; pl) Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 17:33:59 -0000 > > How the filesystem is relevant when tables are in memory? > first, the= y somehow have to be put into the memory > second, for consistency (yeah, = this word is missing from toysql-users' > vocabulary) it has to write the = data to the disk. otherwise you'd lose > anything on a crash http://dev= =2Emysql.com/doc/refman/5.1/en/memory-storage-engine.html "As indicated = by the name, MEMORY tables are stored in memory. They use hash indexes by d= efault, which makes them very fast, and very useful for creating temporary = tables. However, when the server shuts down, all rows stored in MEMORY tabl= es are lost. The tables themselves continue to exist because their definiti= ons are stored in .frm files on disk, but they are empty when the server re= starts." so only the structure is in file not data From owner-freebsd-performance@FreeBSD.ORG Wed May 21 18:41:14 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 352A7106566B for ; Wed, 21 May 2008 18:41:14 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from marvin.harmless.hu (www.ssl.harmless.hu [195.56.55.205]) by mx1.freebsd.org (Postfix) with ESMTP id DE88E8FC19 for ; Wed, 21 May 2008 18:41:13 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from pool-0461.adsl.interware.hu ([213.178.101.205] helo=mort.in.publishing.hu) by marvin.harmless.hu with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1JytFQ-0001YX-QE; Wed, 21 May 2008 20:41:12 +0200 Date: Wed, 21 May 2008 20:41:09 +0200 From: CZUCZY Gergely To: Tomasz Pajor Message-ID: <20080521204109.3c9e601d@mort.in.publishing.hu> In-Reply-To: <257034819c08b52542969ccbf90207fc.nikon@kei.pl> References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> <20080521182530.23c8f787@mort.in.publishing.hu> <78f2745340c587cd4f000ffac8b3e85f.nikon@kei.pl> <20080521192843.30ca3833@mort.in.publishing.hu> <257034819c08b52542969ccbf90207fc.nikon@kei.pl> Organization: Harmless Digital Bt X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.1; i386-portbld-freebsd6.3) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/LOU3Dci9Ysd2w.jSnmKkyHa"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Sender: Czuczy Gergely Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 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: Wed, 21 May 2008 18:41:14 -0000 --Sig_/LOU3Dci9Ysd2w.jSnmKkyHa Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable ahh, sorry. missunderstood that. i've seen many places they've put the data into memory disks. i've thought that's being done here also. On Wed, 21 May 2008 19:33:56 +0200 Tomasz Pajor wrote: > > > How the filesystem is relevant when tables are in memory? =20 > > first, they somehow have to be put into the memory > > second, for consistency (yeah, this word is missing from > > toysql-users' vocabulary) it has to write the data to the disk. > > otherwise you'd lose anything on a crash =20 >=20 > http://dev.mysql.com/doc/refman/5.1/en/memory-storage-engine.html >=20 > "As indicated by the name, MEMORY tables are stored in memory. They > use hash indexes by default, which makes them very fast, and very > useful for creating temporary tables. However, when the server shuts > down, all rows stored in MEMORY tables are lost. The tables > themselves continue to exist because their definitions are stored > in .frm files on disk, but they are empty when the server restarts." >=20 > so only the structure is in file not data --=20 Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. --Sig_/LOU3Dci9Ysd2w.jSnmKkyHa Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINGzHzrC0WyuMkpsRAnvlAJ4oYq4nozf1y6rrphr4r+dvll293QCeNTS2 dY2tsbpTGouuU3ssGg8OVMU= =15Bd -----END PGP SIGNATURE----- --Sig_/LOU3Dci9Ysd2w.jSnmKkyHa--