From owner-freebsd-smp Sun Jan 7 11:37:14 2001 Delivered-To: freebsd-smp@freebsd.org Received: from mail.gmx.net (pop.gmx.net [194.221.183.20]) by hub.freebsd.org (Postfix) with SMTP id C424637B400 for ; Sun, 7 Jan 2001 11:36:56 -0800 (PST) Received: (qmail 22892 invoked by uid 0); 7 Jan 2001 19:36:55 -0000 Received: from p3e9e21c8.dip.t-dialin.net (HELO 1xp133) (62.158.33.200) by mail.gmx.net (mail04) with SMTP; 7 Jan 2001 19:36:55 -0000 Message-ID: <007e01c078e1$61789100$0400a8c0@1xp133> From: "Gregor Bittel" To: "FreeBSD-SMP-Mailinglist" Subject: SMP-Mainboards-List. Date: Sun, 7 Jan 2001 20:32:53 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hi, (sorry for my bad english). . I have decided to make a new list with all known working SMP-Mainboards. Background: I want to buy an new SMP-Board next time, but many Boards do not yet work under FreeBSD. (Iīve probed the Supermicro-P3DR3, without any success on 4.1-Release, itīs my brothers new Board). So I decided to make a new List with all known working SMP-Boards, who are running under FreeBSD, always updated with the newest Boards and informations, and how to make it run. But - I still need informations, which boards are running, a dmesg-output and mptable-output. I hope, this page should be sometime in future be a HCL (HardwareCompatibilityList) with helpful informations about running SMP-Boards under FreeBSD. Actually, this site is still under development, and is under http://www.bnv-bamberg.de/home/ba3294/smp/index.htm available. -Gregor. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Sun Jan 7 15:59:51 2001 Delivered-To: freebsd-smp@freebsd.org Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.80]) by hub.freebsd.org (Postfix) with ESMTP id 5CF6D37B400 for ; Sun, 7 Jan 2001 15:59:33 -0800 (PST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id ECA4B6A90D; Mon, 8 Jan 2001 10:29:31 +1030 (CST) Date: Mon, 8 Jan 2001 10:29:31 +1030 From: Greg Lehey To: Gregor Bittel Cc: FreeBSD-SMP-Mailinglist Subject: Re: SMP-Mainboards-List. Message-ID: <20010108102931.F83353@wantadilla.lemis.com> References: <007e01c078e1$61789100$0400a8c0@1xp133> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i In-Reply-To: <007e01c078e1$61789100$0400a8c0@1xp133>; from Gregor.Bittel@GMX.de on Sun, Jan 07, 2001 at 08:32:53PM +0100 Organization: LEMIS, PO Box 460, Echunga SA 5153, Australia Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.lemis.com/~grog X-PGP-Fingerprint: 6B 7B C3 8C 61 CD 54 AF 13 24 52 F8 6D A4 95 EF Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Sunday, 7 January 2001 at 20:32:53 +0100, Gregor Bittel wrote: > Hi, > (sorry for my bad english). > . > I have decided to make a new list with all known working > SMP-Mainboards. > Background: > I want to buy an new SMP-Board next time, but many Boards do not yet > work under FreeBSD. (Iīve probed the Supermicro-P3DR3, without any > success on 4.1-Release, itīs my brothers new Board). I haven't heard of any motherboards which "don't work" under FreeBSD. There's a difference between "without success" and "it don't work". > So I decided to make a new List with all known working SMP-Boards, > who are running under FreeBSD, always updated with the newest Boards > and informations, and how to make it run. I think it would be better to find out which ones don't work, and to fix them. > But - I still need informations, which boards are running, a > dmesg-output and mptable-output. I'll send you the one from my BP6 separately. Greg -- Finger grog@lemis.com for PGP public key See complete headers for address and phone numbers To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Mon Jan 8 21:49:34 2001 Delivered-To: freebsd-smp@freebsd.org Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.80]) by hub.freebsd.org (Postfix) with ESMTP id 5ACC337B400 for ; Mon, 8 Jan 2001 21:49:17 -0800 (PST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 6F67B6A913; Tue, 9 Jan 2001 16:19:15 +1030 (CST) Date: Tue, 9 Jan 2001 16:19:15 +1030 From: Greg Lehey To: FreeBSD SMP list Subject: Allocating mutexes dynamically and WITNESS Message-ID: <20010109161915.C51397@wantadilla.lemis.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i Organization: LEMIS, PO Box 460, Echunga SA 5153, Australia Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.lemis.com/~grog X-PGP-Fingerprint: 6B 7B C3 8C 61 CD 54 AF 13 24 52 F8 6D A4 95 EF Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org I'm about to add a lock mutex to Vinum RAID-[45] plexes. Each plex gets its own mutex, since it only applies to a specific plex. That's fine in the normal case: I just add a MUTEX_DECLARE to the plex struct definition and all is fine and dandy. But if I do this with WITNESS defined, it tries to initialize it. Any thoughts about how to DTRT here? Greg -- Finger grog@lemis.com for PGP public key See complete headers for address and phone numbers To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Mon Jan 8 22: 9: 8 2001 Delivered-To: freebsd-smp@freebsd.org Received: from fw.wintelcom.net (ns1.wintelcom.net [209.1.153.20]) by hub.freebsd.org (Postfix) with ESMTP id 70AD237B401 for ; Mon, 8 Jan 2001 22:08:52 -0800 (PST) Received: (from bright@localhost) by fw.wintelcom.net (8.10.0/8.10.0) id f0968lG14715; Mon, 8 Jan 2001 22:08:47 -0800 (PST) Date: Mon, 8 Jan 2001 22:08:47 -0800 From: Alfred Perlstein To: Greg Lehey Cc: FreeBSD SMP list Subject: Re: Allocating mutexes dynamically and WITNESS Message-ID: <20010108220847.L15744@fw.wintelcom.net> References: <20010109161915.C51397@wantadilla.lemis.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010109161915.C51397@wantadilla.lemis.com>; from grog@lemis.com on Tue, Jan 09, 2001 at 04:19:15PM +1030 Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org * Greg Lehey [010108 21:49] wrote: > I'm about to add a lock mutex to Vinum RAID-[45] plexes. Each plex > gets its own mutex, since it only applies to a specific plex. That's > fine in the normal case: I just add a MUTEX_DECLARE to the plex struct > definition and all is fine and dandy. But if I do this with WITNESS > defined, it tries to initialize it. Any thoughts about how to DTRT > here? Have a struct mtx and use mutex_init on it? -- -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org] "I have the heart of a child; I keep it in a jar on my desk." To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Mon Jan 8 22:16:21 2001 Delivered-To: freebsd-smp@freebsd.org Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.80]) by hub.freebsd.org (Postfix) with ESMTP id 2D71437B400 for ; Mon, 8 Jan 2001 22:16:04 -0800 (PST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 35A316A90D; Tue, 9 Jan 2001 16:46:02 +1030 (CST) Date: Tue, 9 Jan 2001 16:46:02 +1030 From: Greg Lehey To: Alfred Perlstein Cc: FreeBSD SMP list Subject: Re: Allocating mutexes dynamically and WITNESS Message-ID: <20010109164602.D51397@wantadilla.lemis.com> References: <20010109161915.C51397@wantadilla.lemis.com> <20010108220847.L15744@fw.wintelcom.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010108220847.L15744@fw.wintelcom.net>; from bright@wintelcom.net on Mon, Jan 08, 2001 at 10:08:47PM -0800 Organization: LEMIS, PO Box 460, Echunga SA 5153, Australia Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.lemis.com/~grog X-PGP-Fingerprint: 6B 7B C3 8C 61 CD 54 AF 13 24 52 F8 6D A4 95 EF Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Monday, 8 January 2001 at 22:08:47 -0800, Alfred Perlstein wrote: > * Greg Lehey [010108 21:49] wrote: >> I'm about to add a lock mutex to Vinum RAID-[45] plexes. Each plex >> gets its own mutex, since it only applies to a specific plex. That's >> fine in the normal case: I just add a MUTEX_DECLARE to the plex struct >> definition and all is fine and dandy. But if I do this with WITNESS >> defined, it tries to initialize it. Any thoughts about how to DTRT >> here? > > Have a struct mtx and use mutex_init on it? Oh. I thought you had to do both. (crawls into corner and dies of shame) Greg -- Finger grog@lemis.com for PGP public key See complete headers for address and phone numbers To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Tue Jan 9 9:48:49 2001 Delivered-To: freebsd-smp@freebsd.org Received: from meow.osd.bsdi.com (meow.osd.bsdi.com [204.216.28.88]) by hub.freebsd.org (Postfix) with ESMTP id 89E4837B6D4 for ; Tue, 9 Jan 2001 09:48:32 -0800 (PST) Received: from laptop.baldwin.cx (john@jhb-laptop.osd.bsdi.com [204.216.28.241]) by meow.osd.bsdi.com (8.11.1/8.9.3) with ESMTP id f09HkKG65174; Tue, 9 Jan 2001 09:46:20 -0800 (PST) (envelope-from jhb@FreeBSD.org) Message-ID: X-Mailer: XFMail 1.4.0 on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <20010109161915.C51397@wantadilla.lemis.com> Date: Tue, 09 Jan 2001 09:48:32 -0800 (PST) From: John Baldwin To: Greg Lehey Subject: RE: Allocating mutexes dynamically and WITNESS Cc: FreeBSD SMP list Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On 09-Jan-01 Greg Lehey wrote: > I'm about to add a lock mutex to Vinum RAID-[45] plexes. Each plex > gets its own mutex, since it only applies to a specific plex. That's > fine in the normal case: I just add a MUTEX_DECLARE to the plex struct > definition and all is fine and dandy. But if I do this with WITNESS > defined, it tries to initialize it. Any thoughts about how to DTRT > here? Don't use MUTEX_DECLARE(). Just do a normal struct mtx foo and mtx_init(&foo); MUTEX_DECLARE doesn't work in structures, it only works for standalone mutexes, and hopefully won't be needed by any more mutexes than already use it. -- John Baldwin -- http://www.FreeBSD.org/~jhb/ PGP Key: http://www.baldwin.cx/~john/pgpkey.asc "Power Users Use the Power to Serve!" - http://www.FreeBSD.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Tue Jan 9 18:53:19 2001 Delivered-To: freebsd-smp@freebsd.org Received: from cmailg3.svr.pol.co.uk (cmailg3.svr.pol.co.uk [195.92.195.173]) by hub.freebsd.org (Postfix) with ESMTP id E5BFF37B400 for ; Tue, 9 Jan 2001 18:53:01 -0800 (PST) Received: from modem-249.connecticut.dialup.pol.co.uk ([62.137.58.249] helo=DEDICATION1) by cmailg3.svr.pol.co.uk with smtp (Exim 3.13 #0) id 14GBNk-00008F-00 for freebsd-smp@freebsd.org; Wed, 10 Jan 2001 02:53:00 +0000 Message-ID: <004f01c07ab0$6fed4f70$01010a0a@DEDICATIONINET.local> From: "Andy Chantrill" To: Subject: SMP on Compaq Proliant 800 Date: Wed, 10 Jan 2001 02:52:56 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hey, I got a Compaq Proliant 800 dual pentium pro (200mhz) box recently. A couple of days ago I installed FreeBSD 4.2 on it, re-compiling the kernel for my ISDN card *and* smp support. SMP seemed to work fine, and so did ISDN after some tinkering ... Today, I nuked the disk partitions and installed Windows to test ISDN (had some problems with the card that are resolved now). The ISDN card is now in another machine. Now, I just formatted the disks and installed FreeBSD. I re-compiled the kernel for smp support without any problems - however, on boot it simply hangs: -- Changing APIC ID for IO APIC #0 from 0 to 2 on chip Programming 24 pins in IOAPIC #0 IOAPIC #0 intpin 2 -> irq 0 -- I visited #freebsd on UnderNet and somebody pointed me towards this --> http://potter.ieee.uh.edu/compaq.html So ... I booted from the Compaq Smartstart CD (v4.70), and had a look around in the hardware configuration for APIC settings ... but guess what, I didn't see anything to do with "APIC" settings. :( I'd very much appreciate some help here ... Thanks, Andy. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Tue Jan 9 21:42: 3 2001 Delivered-To: freebsd-smp@freebsd.org Received: from hedwig.internal.webtrends.com (unknown [206.58.83.57]) by hub.freebsd.org (Postfix) with ESMTP id B545B37B401 for ; Tue, 9 Jan 2001 21:41:46 -0800 (PST) Received: by HEDWIG.internal.webtrends.com with Internet Mail Service (5.5.2653.19) id ; Tue, 9 Jan 2001 21:41:44 -0800 Message-ID: <41B0A5BB45B9D311BB4700508B551D72014616D2@mr-mcfeely.internal.webtrends.com> From: Dustin Harris To: "'freebsd-smp@freebsd.org'" Subject: Compaq DL360 Revisited Date: Tue, 9 Jan 2001 21:41:45 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hi folks, I can't get SMP on my Compaq DL360 to work (http://www.freebsd.org/cgi/query-pr.cgi?pr=24210). I just tried using the patch on a DL360 with 4.2-RELEASE, but that didn't work either. Judging by the fact that several others were able to get this to work in early December after the patch was applied to stable I'd have to say I'm just doing something wrong or don't understand how to properly configure an SMP kernel. Any advice? See the PR link for some details. Thanks, Dustin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Wed Jan 10 0: 9:52 2001 Delivered-To: freebsd-smp@freebsd.org Received: from hedwig.internal.webtrends.com (unknown [206.58.83.57]) by hub.freebsd.org (Postfix) with ESMTP id 7329037B401 for ; Wed, 10 Jan 2001 00:09:35 -0800 (PST) Received: by HEDWIG.internal.webtrends.com with Internet Mail Service (5.5.2653.19) id ; Wed, 10 Jan 2001 00:09:32 -0800 Message-ID: <41B0A5BB45B9D311BB4700508B551D72C7E90C@mr-mcfeely.internal.webtrends.com> From: Dustin Harris To: "'freebsd-smp@freebsd.org'" Subject: RE: Compaq DL360 Revisited Date: Wed, 10 Jan 2001 00:09:34 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Based on some printf tracing in the mp_enable function in mp_machdep.c (v1.115.2.4), it appears to die at or somewhere within the start_all_aps call. I didn't trace it any further than that yet. --dustin -----Original Message----- From: Dustin Harris [mailto:DustinH@webtrends.com] Sent: Tuesday, January 09, 2001 9:42 PM To: 'freebsd-smp@freebsd.org' Subject: Compaq DL360 Revisited Hi folks, I can't get SMP on my Compaq DL360 to work (http://www.freebsd.org/cgi/query-pr.cgi?pr=24210). I just tried using the patch on a DL360 with 4.2-RELEASE, but that didn't work either. Judging by the fact that several others were able to get this to work in early December after the patch was applied to stable I'd have to say I'm just doing something wrong or don't understand how to properly configure an SMP kernel. Any advice? See the PR link for some details. Thanks, Dustin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Wed Jan 10 6: 7:59 2001 Delivered-To: freebsd-smp@freebsd.org Received: from ns.uninet.ee (ns.uninet.ee [194.204.0.1]) by hub.freebsd.org (Postfix) with ESMTP id D905337B402 for ; Wed, 10 Jan 2001 06:07:39 -0800 (PST) Received: from inspiral.net (tigris-isdn-64.uninet.ee [194.204.61.64]) by ns.uninet.ee (Postfix) with ESMTP id EC61D258A6 for ; Wed, 10 Jan 2001 16:07:34 +0200 (EET) Message-ID: <3A5C6C78.341A0440@inspiral.net> Date: Wed, 10 Jan 2001 16:06:48 +0200 From: Lauri Laupmaa Organization: Inspiral.Net X-Mailer: Mozilla 4.76 [en] (Win98; U) X-Accept-Language: en,et MIME-Version: 1.0 To: smp@freebsd.org Subject: Compaq dual processor & broken MP table Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms27DFB381413CEAC369A43700" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org This is a cryptographically signed message in MIME format. --------------ms27DFB381413CEAC369A43700 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > Hi > > On compaq ML350 dual processor kernel says: > APIC_IO: Testing 8254 interrupt delivery > APIC_IO: Broken MP table detected: 8254 is not connected to IOAPIC #0 > intpin 2 > APIC_IO: routing 8254 via 8259 and IOAPIC #0 intpin 0 > > Is it some major problem or just annoying message ? > > TIA > > L. --------------ms27DFB381413CEAC369A43700 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIKKwYJKoZIhvcNAQcCoIIKHDCCChgCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC B7cwggSBMIID6qADAgECAhBRff1uOxqNtD+DymrDYl03MA0GCSqGSIb3DQEBBAUAMIHMMRcw FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5 IFJlZi4sTElBQi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRp dmlkdWFsIFN1YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMB4XDTAxMDEwNzAwMDAw MFoXDTAxMDMwODIzNTk1OVowggEFMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UE CxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9y ZXBvc2l0b3J5L1JQQSBJbmNvcnAuIGJ5IFJlZi4sTElBQi5MVEQoYyk5ODEeMBwGA1UECxMV UGVyc29uYSBOb3QgVmFsaWRhdGVkMSYwJAYDVQQLEx1EaWdpdGFsIElEIENsYXNzIDEgLSBO ZXRzY2FwZTEWMBQGA1UEAxQNTGF1cmkgTGF1cG1hYTEhMB8GCSqGSIb3DQEJARYSbWF1cmlA aW5zcGlyYWwubmV0MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCtwtrfGV1XM4dhgowq QK9fsL+Ip5UthKacaoNORgLX6nxAOXUeLPePFHrUjCVtYRbfrAjCPmE5Zy9Qnpfm4fgf/sK2 5IQ+QoHdY/g6BZ+7dc9Wf3ZszKrw/NT/Wu8Mmvg7Ek34F460CHxgCVxRYPMYt+gK7Ly8ubGE /zXHfMzNYQIDAQABo4IBJjCCASIwCQYDVR0TBAIwADBEBgNVHSAEPTA7MDkGC2CGSAGG+EUB BwEIMCowKAYIKwYBBQUHAgEWHGh0dHBzOi8vd3d3LnZlcmlzaWduLmNvbS9ycGEwEQYJYIZI AYb4QgEBBAQDAgeAMIGGBgpghkgBhvhFAQYDBHgWdmQ0NjUyYmQ2M2YyMDQ3MDI5Mjk4NzYz YzlkMmYyNzUwNjljNzM1OWJlZDFiMDU5ZGE3NWJjNGJjOTcwMTc0N2RhNWQzZjQxNDFiZWFk YjJiZDJlODkyMTZhZDZiZjFkNzExNDk5Y2EyYjk0NWZkZjNlYTQ1MGQwMwYDVR0fBCwwKjAo oCagJIYiaHR0cDovL2NybC52ZXJpc2lnbi5jb20vY2xhc3MxLmNybDANBgkqhkiG9w0BAQQF AAOBgQBcAPAx7vFJmoiGWujs15eHChQjeK/95q6UT+wXqfJ1sa0DUZdipBYq4MANkN2Bcauh J0L22WU64bMsD8K4yPEEf7XEXfOlsn0XEWwWI819pbEnUrDnc4z/D4wbnQwf85v2mHtfw+kD EUR+A4zomDnKek1ZHdjt7WBbLStYoTnVvzCCAy4wggKXoAMCAQICEQDSdi6NFAw9fbKoJV2v 7g11MA0GCSqGSIb3DQEBAgUAMF8xCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5WZXJpU2lnbiwg SW5jLjE3MDUGA1UECxMuQ2xhc3MgMSBQdWJsaWMgUHJpbWFyeSBDZXJ0aWZpY2F0aW9uIEF1 dGhvcml0eTAeFw05ODA1MTIwMDAwMDBaFw0wODA1MTIyMzU5NTlaMIHMMRcwFQYDVQQKEw5W ZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UE CxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJlZi4sTElB Qi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFsIFN1 YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCB iQKBgQC7WkSKBBa7Vf0DeootlE8VeDa4DUqyb5xUv7zodyqdufBou5XZMUFweoFLuUgTVi3H COGEQqvAopKrRFyqQvCCDgLpL/vCO7u+yScKXbawNkIztW5UiE+HSr8Z2vkV6A+HthzjzMaa jn9qJJLj/OBluqexfu/J2zdqyErICQbkmQIDAQABo3wwejARBglghkgBhvhCAQEEBAMCAQYw RwYDVR0gBEAwPjA8BgtghkgBhvhFAQcBATAtMCsGCCsGAQUFBwIBFh93d3cudmVyaXNpZ24u Y29tL3JlcG9zaXRvcnkvUlBBMA8GA1UdEwQIMAYBAf8CAQAwCwYDVR0PBAQDAgEGMA0GCSqG SIb3DQEBAgUAA4GBAIi4Nzvd2pQ3AK2qn+GBAXEekmptL/bxndPKZDjcG5gMB4ZbhRVqD7lJ haSV8Rd9Z7R/LSzdmkKewz60jqrlCwbe8lYq+jPHvhnXU0zDvcjjF7WkSUJj7MKmFw9dWBpJ PJBcVaNlIAD9GCDlX4KmsaiSxVhqwY0DPOvDzQWikK5uMYICPDCCAjgCAQEwgeEwgcwxFzAV BgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3Jr MUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkg UmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAxIENBIEluZGl2 aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0ZWQCEFF9/W47Go20P4PKasNi XTcwCQYFKw4DAhoFAKCBsTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJ BTEPFw0wMTAxMTAxNDA2NTBaMCMGCSqGSIb3DQEJBDEWBBQMDmCXbsge+CaYgDSwy9ytk0Xn vTBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDAHBgUrDgMC BzANBggqhkiG9w0DAgIBQDANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgAfmsbjM 1hoEVCIEBcgGE4QeR6BcwKwIZrZuWPlzSXo2OByCxkPnkZuIpXCbZQk4+644j+2iEKd+Vqym bkfv0bangvRgD62s69s2dCwULPQWpcJVNlPi3eDHE0vRVO0rv/oQiz0wPEjdvDVWPlW7neTB 6rQpTJTQGOw6EtkSUbQo --------------ms27DFB381413CEAC369A43700-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Wed Jan 10 6:38:48 2001 Delivered-To: freebsd-smp@freebsd.org Received: from ns.uninet.ee (ns.uninet.ee [194.204.0.1]) by hub.freebsd.org (Postfix) with ESMTP id CFA4837B401; Wed, 10 Jan 2001 06:38:29 -0800 (PST) Received: from inspiral.net (tigris-isdn-64.uninet.ee [194.204.61.64]) by ns.uninet.ee (Postfix) with ESMTP id 5B51325821; Wed, 10 Jan 2001 16:38:02 +0200 (EET) Message-ID: <3A5C7393.40EB4D13@inspiral.net> Date: Wed, 10 Jan 2001 16:37:08 +0200 From: Lauri Laupmaa Organization: Inspiral.Net X-Mailer: Mozilla 4.76 [en] (Win98; U) X-Accept-Language: en,et MIME-Version: 1.0 To: database@#freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: mysql (smp) performance Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------msE5D4CB10671614776A5A48CF" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org This is a cryptographically signed message in MIME format. --------------msE5D4CB10671614776A5A48CF Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi After some fair amount of testing I came to conclusion that unfortunately mysql (both 3.22 and 3.23) performance is considerably slower on freebsd than linux...at least on stock install. I have used 4.x-STABLE systems, both on SMP and singleproc and linux 2.1/2.2 kernels. It seems that on SMP mysql doesn't scale well. (currently testing on dual 833 PIII and running on couple older dual systems) I'm interested if there is some magic to get mysql run faster ? Or should I use 5.x-CURRENT ? TIA L. --------------msE5D4CB10671614776A5A48CF Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIKKwYJKoZIhvcNAQcCoIIKHDCCChgCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC B7cwggSBMIID6qADAgECAhBRff1uOxqNtD+DymrDYl03MA0GCSqGSIb3DQEBBAUAMIHMMRcw FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5 IFJlZi4sTElBQi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRp dmlkdWFsIFN1YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMB4XDTAxMDEwNzAwMDAw MFoXDTAxMDMwODIzNTk1OVowggEFMRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UE CxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9y ZXBvc2l0b3J5L1JQQSBJbmNvcnAuIGJ5IFJlZi4sTElBQi5MVEQoYyk5ODEeMBwGA1UECxMV UGVyc29uYSBOb3QgVmFsaWRhdGVkMSYwJAYDVQQLEx1EaWdpdGFsIElEIENsYXNzIDEgLSBO ZXRzY2FwZTEWMBQGA1UEAxQNTGF1cmkgTGF1cG1hYTEhMB8GCSqGSIb3DQEJARYSbWF1cmlA aW5zcGlyYWwubmV0MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCtwtrfGV1XM4dhgowq QK9fsL+Ip5UthKacaoNORgLX6nxAOXUeLPePFHrUjCVtYRbfrAjCPmE5Zy9Qnpfm4fgf/sK2 5IQ+QoHdY/g6BZ+7dc9Wf3ZszKrw/NT/Wu8Mmvg7Ek34F460CHxgCVxRYPMYt+gK7Ly8ubGE /zXHfMzNYQIDAQABo4IBJjCCASIwCQYDVR0TBAIwADBEBgNVHSAEPTA7MDkGC2CGSAGG+EUB BwEIMCowKAYIKwYBBQUHAgEWHGh0dHBzOi8vd3d3LnZlcmlzaWduLmNvbS9ycGEwEQYJYIZI AYb4QgEBBAQDAgeAMIGGBgpghkgBhvhFAQYDBHgWdmQ0NjUyYmQ2M2YyMDQ3MDI5Mjk4NzYz YzlkMmYyNzUwNjljNzM1OWJlZDFiMDU5ZGE3NWJjNGJjOTcwMTc0N2RhNWQzZjQxNDFiZWFk YjJiZDJlODkyMTZhZDZiZjFkNzExNDk5Y2EyYjk0NWZkZjNlYTQ1MGQwMwYDVR0fBCwwKjAo oCagJIYiaHR0cDovL2NybC52ZXJpc2lnbi5jb20vY2xhc3MxLmNybDANBgkqhkiG9w0BAQQF AAOBgQBcAPAx7vFJmoiGWujs15eHChQjeK/95q6UT+wXqfJ1sa0DUZdipBYq4MANkN2Bcauh J0L22WU64bMsD8K4yPEEf7XEXfOlsn0XEWwWI819pbEnUrDnc4z/D4wbnQwf85v2mHtfw+kD EUR+A4zomDnKek1ZHdjt7WBbLStYoTnVvzCCAy4wggKXoAMCAQICEQDSdi6NFAw9fbKoJV2v 7g11MA0GCSqGSIb3DQEBAgUAMF8xCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5WZXJpU2lnbiwg SW5jLjE3MDUGA1UECxMuQ2xhc3MgMSBQdWJsaWMgUHJpbWFyeSBDZXJ0aWZpY2F0aW9uIEF1 dGhvcml0eTAeFw05ODA1MTIwMDAwMDBaFw0wODA1MTIyMzU5NTlaMIHMMRcwFQYDVQQKEw5W ZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazFGMEQGA1UE CxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5IFJlZi4sTElB Qi5MVEQoYyk5ODFIMEYGA1UEAxM/VmVyaVNpZ24gQ2xhc3MgMSBDQSBJbmRpdmlkdWFsIFN1 YnNjcmliZXItUGVyc29uYSBOb3QgVmFsaWRhdGVkMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCB iQKBgQC7WkSKBBa7Vf0DeootlE8VeDa4DUqyb5xUv7zodyqdufBou5XZMUFweoFLuUgTVi3H COGEQqvAopKrRFyqQvCCDgLpL/vCO7u+yScKXbawNkIztW5UiE+HSr8Z2vkV6A+HthzjzMaa jn9qJJLj/OBluqexfu/J2zdqyErICQbkmQIDAQABo3wwejARBglghkgBhvhCAQEEBAMCAQYw RwYDVR0gBEAwPjA8BgtghkgBhvhFAQcBATAtMCsGCCsGAQUFBwIBFh93d3cudmVyaXNpZ24u Y29tL3JlcG9zaXRvcnkvUlBBMA8GA1UdEwQIMAYBAf8CAQAwCwYDVR0PBAQDAgEGMA0GCSqG SIb3DQEBAgUAA4GBAIi4Nzvd2pQ3AK2qn+GBAXEekmptL/bxndPKZDjcG5gMB4ZbhRVqD7lJ haSV8Rd9Z7R/LSzdmkKewz60jqrlCwbe8lYq+jPHvhnXU0zDvcjjF7WkSUJj7MKmFw9dWBpJ PJBcVaNlIAD9GCDlX4KmsaiSxVhqwY0DPOvDzQWikK5uMYICPDCCAjgCAQEwgeEwgcwxFzAV BgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3Jr MUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkg UmVmLixMSUFCLkxURChjKTk4MUgwRgYDVQQDEz9WZXJpU2lnbiBDbGFzcyAxIENBIEluZGl2 aWR1YWwgU3Vic2NyaWJlci1QZXJzb25hIE5vdCBWYWxpZGF0ZWQCEFF9/W47Go20P4PKasNi XTcwCQYFKw4DAhoFAKCBsTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJ BTEPFw0wMTAxMTAxNDM3MDlaMCMGCSqGSIb3DQEJBDEWBBToUrsPrMIF0lzrPZjuFm9Z/Rfb 5jBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDAHBgUrDgMC BzANBggqhkiG9w0DAgIBQDANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgHqkaQwu 2IeHb/w5En2Smf1I9GfgOx1Z/LXd1+Oig5Tcx0uqa29sADfVDPJC1KapXTsjHq/a7BGHawgq vklM7YkU8PgDOMhPa/bfK6BSIKvGINJ5K55B9fEjArNLffIon08e85EwD0o+n8VnNjsGSqeY R1cSytU+eTMWKLs2TLwV --------------msE5D4CB10671614776A5A48CF-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Wed Jan 10 9:14:33 2001 Delivered-To: freebsd-smp@freebsd.org Received: from solaris.matti.ee (solaris.matti.ee [194.126.98.135]) by hub.freebsd.org (Postfix) with ESMTP id 6907637B400 for ; Wed, 10 Jan 2001 09:14:16 -0800 (PST) Received: from myhakas.matti.ee (myhakas.matti.ee [194.126.114.87]) by solaris.matti.ee (Postfix) with ESMTP id 04BC62CE48; Wed, 10 Jan 2001 19:21:08 +0200 (EET) Received: (from vallo@localhost) by myhakas.matti.ee (8.11.1/8.11.1) id f0AHECG00638; Wed, 10 Jan 2001 19:14:12 +0200 (EET) (envelope-from vallo) Date: Wed, 10 Jan 2001 19:14:12 +0200 From: Vallo Kallaste To: Lauri Laupmaa Cc: smp@FreeBSD.ORG Subject: Re: mysql (smp) performance Message-ID: <20010110191412.B265@myhakas.matti.ee> Reply-To: vallo@matti.ee References: <3A5C7393.40EB4D13@inspiral.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.11i In-Reply-To: <3A5C7393.40EB4D13@inspiral.net>; from mauri@inspiral.net on Wed, Jan 10, 2001 at 04:37:08PM +0200 Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Wed, Jan 10, 2001 at 04:37:08PM +0200, Lauri Laupmaa wrote: > After some fair amount of testing I came to conclusion that > unfortunately mysql (both 3.22 and 3.23) performance is considerably > slower on freebsd than linux...at least on stock install. > > I have used 4.x-STABLE systems, both on SMP and singleproc and linux > 2.1/2.2 kernels. > > It seems that on SMP mysql doesn't scale well. (currently testing on > dual 833 PIII and running on couple older dual systems) > > I'm interested if there is some magic to get mysql run faster ? > Or should I use 5.x-CURRENT ? Do not use -current at this time, it's too unstable and doesn't help you anyway. The case is very simple, you'll have to wait for a year or so until SMP support matures, or switch to well-known OS wrt SMP and database applications. I don't want to start flame war, but free x86 Solaris seems reasonable if you have powerful hardware. For second don't know, haven't used Linux for a long time, but I don't believe it'll be better for databases running MP system. For two processors only, who knows.. -- Vallo Kallaste vallo@matti.ee To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Wed Jan 10 9:16: 1 2001 Delivered-To: freebsd-smp@freebsd.org Received: from picalon.gun.de (picalon.gun.de [192.109.159.1]) by hub.freebsd.org (Postfix) with ESMTP id 44B9937B400; Wed, 10 Jan 2001 09:15:28 -0800 (PST) Received: (from uucp@localhost) by picalon.gun.de (8.9.3/8.9.3) id SAA26023; Wed, 10 Jan 2001 18:15:16 +0100 (MET) >Received: (from andreas@localhost) by klemm.gtn.com (8.11.1/8.11.1) id f0AH1ev03728; Wed, 10 Jan 2001 18:01:41 +0100 (CET) (envelope-from andreas) Date: Wed, 10 Jan 2001 18:01:40 +0100 From: Andreas Klemm To: Lauri Laupmaa Cc: database@freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110180139.A3584@titan.klemm.gtn.com> References: <3A5C7393.40EB4D13@inspiral.net> Mime-Version: 1.0 Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A5C7393.40EB4D13@inspiral.net>; from mauri@inspiral.net on Wed, Jan 10, 2001 at 04:37:08PM +0200 X-Operating-System: FreeBSD 4.2-STABLE SMP X-Disclaimer: A free society is one where it is safe to be unpopular Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Wed, Jan 10, 2001 at 04:37:08PM +0200, Lauri Laupmaa wrote: > I have used 4.x-STABLE systems, both on SMP and singleproc and linux > 2.1/2.2 kernels. Which kernel profile ? GENERIC ? Modified ? Ralf Engelschall wrote a paper how to fine tune FreeBSD kernel for high performance load sharing webservers ... Certainly there are things that could be tuned when using databases. Did you already ask on the mysql mailinglist, what they recommend to fine tune to increase performance in general for mysql ? Perhaps they already have some experience with FreeBSD ? Already searched the archives (www.google.com) ? I looked for: mysql performance tuning And got some links: http://www.tryc.on.ca/archives/mysql/December1999/0009.html What disks are you using SCSI or IDE ? What driver settings in the kernel ... Some kernel options might give a difference. Maybe the Linux machines have some performance knobs turned on, in certain areas FreeBSD is more restrictive in turning on such knobs per default, with the sake to support more (crappy) hardware. Andreas /// -- Andreas Klemm - Powered by FreeBSD 4.2 SMP Need a magic printfilter today ? -> http://www.apsfilter.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Wed Jan 10 9:16: 3 2001 Delivered-To: freebsd-smp@freebsd.org Received: from picalon.gun.de (picalon.gun.de [192.109.159.1]) by hub.freebsd.org (Postfix) with ESMTP id 5AAA037B401; Wed, 10 Jan 2001 09:15:28 -0800 (PST) Received: (from uucp@localhost) by picalon.gun.de (8.9.3/8.9.3) id SAA26032; Wed, 10 Jan 2001 18:15:17 +0100 (MET) >Received: (from andreas@localhost) by klemm.gtn.com (8.11.1/8.11.1) id f0AH5Hh03786; Wed, 10 Jan 2001 18:05:17 +0100 (CET) (envelope-from andreas) Date: Wed, 10 Jan 2001 18:05:17 +0100 From: Andreas Klemm To: Lauri Laupmaa Cc: database@freebsd.org, databases@freebsd.org, smp@freebsd.org Subject: Re: mysql (smp) performance Message-ID: <20010110180517.A3741@titan.klemm.gtn.com> References: <3A5C7393.40EB4D13@inspiral.net> Mime-Version: 1.0 Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A5C7393.40EB4D13@inspiral.net>; from mauri@inspiral.net on Wed, Jan 10, 2001 at 04:37:08PM +0200 X-Operating-System: FreeBSD 4.2-STABLE SMP X-Disclaimer: A free society is one where it is safe to be unpopular Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org I found another interesting link for FreeBSD && mysql: http://www.bitmechanic.com/mail-archives/mysql/Nov1997/0425.html +------------------------------------------------------------------- > I've just got a brand new 200Mhz Pentium machine with two 4 gig SCSI > disks for me to use. Its only purpose in life is to be a mysql > server. I want this baby to scream. I'm planning on ccd-ing the two > disks together to get the benefits of having two spindles. What else > should I do? Does anyone have experience and advice with opening up > the server configuration options, like buffers and open files, etc? > > Thanks, > > Nat You want to rebuild a kernel with the following options maxusers 256 options CHILD_MAX=512 options OPEN_MAX=256 # this is with 256 MB RAM adjust these figures based on # how much RAM you have options "MAXDSIZE=(256*1024*1024)" options "DFLDSIZE=(128*1024*1024)" # set this otherwise the kernel only recognizes the first 64 MB options MAXMEM=262144 # 256 MB options NMBCLUSTERS=4096 options COPTFLAGS="-O2 -fexpensive-optimizations -m486 -fomit-frame-pointer" +------------------------------------------------------------------- Note: concerning COPTFLAGS, be careful ... -pipe -O is know to produce the "correctest" code.... First I'd try the other options. Be careful with the settings, if you don't have enough RAM ... Andreas /// -- Andreas Klemm - Powered by FreeBSD 4.2 SMP Need a magic printfilter today ? -> http://www.apsfilter.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Thu Jan 11 8:27: 4 2001 Delivered-To: freebsd-smp@freebsd.org Received: from smtp04.primenet.com (smtp04.primenet.com [206.165.6.134]) by hub.freebsd.org (Postfix) with ESMTP id 9FF0E37B400 for ; Thu, 11 Jan 2001 08:26:46 -0800 (PST) Received: (from daemon@localhost) by smtp04.primenet.com (8.9.3/8.9.3) id JAA08529; Thu, 11 Jan 2001 09:21:56 -0700 (MST) Received: from usr08.primenet.com(206.165.6.208) via SMTP by smtp04.primenet.com, id smtpdAAADXaGpq; Thu Jan 11 09:21:36 2001 Received: (from tlambert@localhost) by usr08.primenet.com (8.8.5/8.8.5) id JAA16987; Thu, 11 Jan 2001 09:26:03 -0700 (MST) From: Terry Lambert Message-Id: <200101111626.JAA16987@usr08.primenet.com> Subject: Re: mysql (smp) performance To: vallo@matti.ee Date: Thu, 11 Jan 2001 16:26:03 +0000 (GMT) Cc: mauri@inspiral.net (Lauri Laupmaa), smp@FreeBSD.ORG In-Reply-To: <20010110191412.B265@myhakas.matti.ee> from "Vallo Kallaste" at Jan 10, 2001 07:14:12 PM X-Mailer: ELM [version 2.5 PL2] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org > > After some fair amount of testing I came to conclusion that > > unfortunately mysql (both 3.22 and 3.23) performance is considerably > > slower on freebsd than linux...at least on stock install. > > > > I have used 4.x-STABLE systems, both on SMP and singleproc and linux > > 2.1/2.2 kernels. > > > > It seems that on SMP mysql doesn't scale well. (currently testing on > > dual 833 PIII and running on couple older dual systems) > > > > I'm interested if there is some magic to get mysql run faster ? > > Or should I use 5.x-CURRENT ? > > Do not use -current at this time, it's too unstable and doesn't help > you anyway. The case is very simple, you'll have to wait for a year > or so until SMP support matures, or switch to well-known OS wrt SMP > and database applications. I don't want to start flame war, but free > x86 Solaris seems reasonable if you have powerful hardware. For > second don't know, haven't used Linux for a long time, but I don't > believe it'll be better for databases running MP system. For two > processors only, who knows.. MySQL uses POSIX threads; on FreeBSD, POSIX threads do not scale to an increased number of processors when running SMP. On Linux, POSIX threads scale poorly to an increased number of processors, when compared to Solaris and similar OS implemenations. As a practical matter, you can install the Linux threads kernel module and library on FreeBSD, and get at least as "good" SMP threads scaling on FreeBSD as you would on Linux, but both platforms are a poor second to even the worst of the commercial SMP systems at this time. POSIX threads also have some serious limitations, where the designers of the API exposed OS implementation issues specific to the reference platforms, all of which were System V UNIX variants. One major example of this is preallocation of fixed size stacks, which is not really necessary even on SVR4 systems, so long as they postdate Steve Baumel's VM work as of SVR4.2 (even on earlier implementations, it's pretty trivial to establish a guard page on a region, and auto-grow it by taking the fault in user space using a signal handler). Really, most people using threads should go back to the drawing board, and select a design that doesn't require threads. In any case, I have to agree here with the Solaris recommendation probably being your best bet for optimum SMP scalability at this time, at least as long as you don't go over 4 processors. For higher scaling, you will need to wait until FreeBSD completes the work already designed, but not yet implemented, or until another SMP OS threads support matures beyond the 4 CPU limit that comes from poor scheduling and too large a conflict domain brought about by unnecessarily over-shared resources. PS: I can't really see ythis being a real problem, if you are using MySQL as your engine; you will hit engine contention limits well before that level of scaling anyway. Terry Lambert terry@lambert.org --- Any opinions in this posting are my own and not those of my present or previous employers. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Fri Jan 12 9:19:44 2001 Delivered-To: freebsd-smp@freebsd.org Received: from viger.playstos.com (viger.playstos.com [194.79.208.10]) by hub.freebsd.org (Postfix) with ESMTP id 05DCB37B400; Fri, 12 Jan 2001 09:19:21 -0800 (PST) Received: from sunshine (gw2.playstos.com [194.79.208.2]) by viger.playstos.com (Postfix) with SMTP id B67D1D60F9; Fri, 12 Jan 2001 18:19:19 +0100 (CET) From: "Alessandro de Manzano" To: "smp@freebsd.org" Cc: "stable@freebsd.org" Date: Fri, 12 Jan 2001 18:20:18 +0100 Reply-To: "Alessandro de Manzano" X-Mailer: PMMail 2000 Professional (2.10.2010) For Windows 2000 (5.0.2195) MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: PR #24059 - USB still broken in SMP ! Message-Id: <20010112171919.B67D1D60F9@viger.playstos.com> Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Hello! I've submitted a PR, number 24059, for the problem I still experience in trying to use USB support with a SMP kernel on a 4.2-stable box. I please the maintainers of USB and SMP sections to read my PR :) If someone else is successfull in using USB with SMP kernel please tell me/us ! :-) Thanks a lot! Alessandro de Manzano Playstos - TIMA S.p.A. Corso Sempione 63 20149 Milano, Italy tel.: +39-023314153 fax: +39-02315678 email: demanzano@playstos.com http://www.playstos.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Fri Jan 12 9:40:58 2001 Delivered-To: freebsd-smp@freebsd.org Received: from pan.ch.intel.com (pan.ch.intel.com [143.182.246.24]) by hub.freebsd.org (Postfix) with ESMTP id 06B5F37B400; Fri, 12 Jan 2001 09:40:39 -0800 (PST) Received: from sedona.intel.com (sedona.ch.intel.com [143.182.218.21]) by pan.ch.intel.com (8.9.1a+p1/8.9.1/d: relay.m4,v 1.33 2000/11/21 19:27:27 smothers Exp $) with ESMTP id KAA21067; Fri, 12 Jan 2001 10:40:11 -0700 (MST) Received: from hip186.ch.intel.com (hip186.ch.intel.com [143.182.225.68]) by sedona.intel.com (8.9.1a/8.9.1/d: sendmail.cf,v 1.14 2001/01/02 18:39:59 steved Exp $) with ESMTP id KAA24293; Fri, 12 Jan 2001 10:40:11 -0700 (MST) X-Envelope-From: jreynold@sedona.ch.intel.com Received: (from jreynold@localhost) by hip186.ch.intel.com (8.9.1a/8.9.1/d: client.m4,v 1.3 1998/09/29 16:36:11 sedayao Exp sedayao $) id MAA25873; Fri, 12 Jan 2001 12:40:10 -0500 (EST) X-Authentication-Warning: hip186.ch.intel.com: jreynold set sender to jreynold@sedona.ch.intel.com using -f From: John Reynolds~ MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14943.16761.965760.182463@hip186.ch.intel.com> Date: Fri, 12 Jan 2001 10:40:09 -0700 (MST) To: "Alessandro de Manzano" Cc: "smp@freebsd.org" , "stable@freebsd.org" Subject: Re: PR #24059 - USB still broken in SMP ! In-Reply-To: <20010112171919.B67D1D60F9@viger.playstos.com> References: <20010112171919.B67D1D60F9@viger.playstos.com> X-Mailer: VM 6.75 under Emacs 20.6.3 Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org [ On Friday, January 12, Alessandro de Manzano wrote: ] > > If someone else is successfull in using USB with SMP kernel please tell > me/us ! :-) > > Thanks a lot! Ok. I've got a P2B-DS motherboard (rev 1.06 I believe with the latest BIOS) and I'm running an SMP kernel using two 500Mhz Pentium III's. I use USB to connect to my Canon S10 digital camera all the time. No problems. I've not used USB for anything other than this though--no mice, keyboards, disks, memory readers, etc. But, it does work for me with SMP. -Jr -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | John Reynolds WCCG, CCE, Higher Levels of Abstraction | | Intel Corporation MS: CH6-210 Phone: 480-554-9092 pgr: 602-868-6512 | | jreynold@sedona.ch.intel.com http://www-aec.ch.intel.com/~jreynold/ | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Fri Jan 12 11:50: 9 2001 Delivered-To: freebsd-smp@freebsd.org Received: from magnesium.net (toxic.magnesium.net [207.154.84.15]) by hub.freebsd.org (Postfix) with SMTP id 76CFD37B402 for ; Fri, 12 Jan 2001 11:49:50 -0800 (PST) Received: (qmail 47022 invoked by uid 1142); 12 Jan 2001 19:49:48 -0000 Date: 12 Jan 2001 11:49:48 -0800 Date: Fri, 12 Jan 2001 11:49:35 -0800 From: Jason Evans To: smp@freebsd.org Subject: State of the SMP project (12 January 2001) Message-ID: <20010112114935.G52004@canonware.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org The SMP project continues. We're still making significant forward progress, though we have yet to hit the point where the payoff of all this work becomes evident. The Giant lock is still protecting the vast majority of the kernel, and the reason that it is taking so long to "push down" locking is that Giant is essentially a code lock, whereas the locking work that we're doing now uses data locks. That means that large amounts of work are necessary to lock all the data structures that are accessed in a particular code path before Giant protection of the code can be removed. John Baldwin (with some help from Jake Burkholder) has been locking accesses to various fields of the proc structure. If this sounds simple, take a look at a recent revision of src/sys/proc.h to get an idea of the complexity, then think about all the places that processes are manipulated in the kernel. =) Jake Burkholder has been working on making the kernel preemptive, and is now doing some major cleanups of the scheduler as part of that and other SMP works in progress. Once he is done with that, we plan to get priority propagation working shortly thereafter. At that point, it will be possible to remove the priority argument to tsleep()/msleep()/cv_*wait*(), since artificial priority boosts won't be necessary anymore. Of course, this will cause a ripple effect through the kernel APIs as we remove the obsolete priority arguments wherever they are passed. The cv (condition variable) code is basically ready to commit, but needs tested again after changes were made due to -arch feedback. John Baldwin and I came up with a shared/exclusive lock API a couple of days ago. It's implemented now, and after I have tested and documented it, I'll send a request for review to -arch. Jake wrote a first cut at a cmpxchgl emulator for 386's so that we can make the atomic.h API fully usable to userland. One of these days I'll do some testing of it and get it committed. As always, the SMP project page is at: http://people.freebsd.org/~jasone/smp/ Right now, we have precious few people doing the heavy lifting, so if you think progress is too slow, think about how you can help to speed things up. Jason Evans SMP Project Manager To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Fri Jan 12 12:36: 9 2001 Delivered-To: freebsd-smp@freebsd.org Received: from libero.sunshine.ale (ppp-225-113.33-151.iol.it [151.33.113.225]) by hub.freebsd.org (Postfix) with ESMTP id 594C837B401; Fri, 12 Jan 2001 12:35:48 -0800 (PST) Received: by libero.sunshine.ale (Postfix, from userid 1001) id B76ED5F2A; Fri, 12 Jan 2001 21:36:10 +0100 (CET) Date: Fri, 12 Jan 2001 21:36:10 +0100 From: Alessandro de Manzano To: John Reynolds~ Cc: Alessandro de Manzano , "smp@freebsd.org" , "stable@freebsd.org" Subject: Re: PR #24059 - USB still broken in SMP ! Message-ID: <20010112213610.E615@libero.sunshine.ale> Reply-To: Alessandro de Manzano References: <20010112171919.B67D1D60F9@viger.playstos.com> <14943.16761.965760.182463@hip186.ch.intel.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <14943.16761.965760.182463@hip186.ch.intel.com>; from jreynold@sedona.ch.intel.com on Fri, Jan 12, 2001 at 10:40:09AM -0700 X-Operating-System: FreeBSD 4.2-STABLE Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org > Ok. I've got a P2B-DS motherboard (rev 1.06 I believe with the latest BIOS) > and I'm running an SMP kernel using two 500Mhz Pentium III's. I use USB to > connect to my Canon S10 digital camera all the time. No problems. I've not > used USB for anything other than this though--no mice, keyboards, disks, > memory readers, etc. Thanks for the answer ! :-) I'm happy to hear USB works for you, so I could only guess some things: 1) we have different USB controllers, the Asus P2B-DS (a MB I have where I work) use Intel chipset and my Microstar MS-6321 use an VIA one. 2) I tried with the mouse only, also if error reports are reported by kernel also if the USB bus is "empty" and idle. I really hope my problem could be resolved in a future evoltion of USB drivers.. ;-) Thanks a lot! -- bye! Ale aledema@iol.it To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Sat Jan 13 19:58:24 2001 Delivered-To: freebsd-smp@freebsd.org Received: from hedwig.internal.webtrends.com (unknown [206.58.83.57]) by hub.freebsd.org (Postfix) with ESMTP id 43DCA37B6AE for ; Sat, 13 Jan 2001 19:58:06 -0800 (PST) Received: by HEDWIG.internal.webtrends.com with Internet Mail Service (5.5.2653.19) id ; Sat, 13 Jan 2001 19:58:02 -0800 Message-ID: <41B0A5BB45B9D311BB4700508B551D7201461706@mr-mcfeely.internal.webtrends.com> From: Dustin Harris To: "'freebsd-smp@freebsd.org'" Subject: RE: Compaq DL360 Revisited Date: Sat, 13 Jan 2001 19:58:04 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org I've traced the problem to the following code in mp_machdep.c in the function start_ap: /* wait for pending status end */ while (lapic.icr_lo & APIC_DELSTAT_MASK) /* spin */ ; It appears that I just "spin". Any ideas? What else can I do to help troubleshoot this? Thanks. --dustin -----Original Message----- From: Dustin Harris [mailto:DustinH@webtrends.com] Sent: Wednesday, January 10, 2001 12:10 AM To: 'freebsd-smp@freebsd.org' Subject: RE: Compaq DL360 Revisited Based on some printf tracing in the mp_enable function in mp_machdep.c (v1.115.2.4), it appears to die at or somewhere within the start_all_aps call. I didn't trace it any further than that yet. --dustin -----Original Message----- From: Dustin Harris [mailto:DustinH@webtrends.com] Sent: Tuesday, January 09, 2001 9:42 PM To: 'freebsd-smp@freebsd.org' Subject: Compaq DL360 Revisited Hi folks, I can't get SMP on my Compaq DL360 to work (http://www.freebsd.org/cgi/query-pr.cgi?pr=24210). I just tried using the patch on a DL360 with 4.2-RELEASE, but that didn't work either. Judging by the fact that several others were able to get this to work in early December after the patch was applied to stable I'd have to say I'm just doing something wrong or don't understand how to properly configure an SMP kernel. Any advice? See the PR link for some details. Thanks, Dustin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Sat Jan 13 20:43:19 2001 Delivered-To: freebsd-smp@freebsd.org Received: from mass.osd.bsdi.com (dhcp45-24.dis.org [216.240.45.24]) by hub.freebsd.org (Postfix) with ESMTP id D08B737B6ED for ; Sat, 13 Jan 2001 20:43:02 -0800 (PST) Received: from mass.osd.bsdi.com (localhost [127.0.0.1]) by mass.osd.bsdi.com (8.11.1/8.11.1) with ESMTP id f0E4cVQ85192; Sat, 13 Jan 2001 20:38:31 -0800 (PST) (envelope-from msmith@mass.osd.bsdi.com) Message-Id: <200101140438.f0E4cVQ85192@mass.osd.bsdi.com> X-Mailer: exmh version 2.1.1 10/15/1999 To: Dustin Harris Cc: "'freebsd-smp@freebsd.org'" Subject: Re: Compaq DL360 Revisited In-reply-to: Your message of "Sat, 13 Jan 2001 19:58:04 PST." <41B0A5BB45B9D311BB4700508B551D7201461706@mr-mcfeely.internal.webtrends.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sat, 13 Jan 2001 20:38:31 -0800 From: Mike Smith Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org > I've traced the problem to the following code in mp_machdep.c in the > function start_ap: > > /* wait for pending status end */ > while (lapic.icr_lo & APIC_DELSTAT_MASK) > /* spin */ ; > > It appears that I just "spin". Any ideas? What else can I do to help > troubleshoot this? Thanks. The problem with the DL360 is actually a BIOS bug. You should pester Compaq for an update (they are aware of the problem if you get through to the right people), or update to -STABLE on your box (where Peter Wemm has committed a workaround). -- ... every activity meets with opposition, everyone who acts has his rivals and unfortunately opponents also. But not because people want to be opponents, rather because the tasks and relationships force people to take different points of view. [Dr. Fritz Todt] V I C T O R Y N O T V E N G E A N C E To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message From owner-freebsd-smp Sat Jan 13 20:50:34 2001 Delivered-To: freebsd-smp@freebsd.org Received: from hedwig.internal.webtrends.com (unknown [206.58.83.57]) by hub.freebsd.org (Postfix) with ESMTP id AA30337B6ED; Sat, 13 Jan 2001 20:50:17 -0800 (PST) Received: by HEDWIG.internal.webtrends.com with Internet Mail Service (5.5.2653.19) id ; Sat, 13 Jan 2001 20:33:50 -0800 Message-ID: <41B0A5BB45B9D311BB4700508B551D7201461707@mr-mcfeely.internal.webtrends.com> From: Dustin Harris To: 'Mike Smith' Cc: "'freebsd-smp@freebsd.org'" Subject: RE: Compaq DL360 Revisited Date: Sat, 13 Jan 2001 20:33:52 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-smp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org I'm aware that Peter did fix the DL360 for most folks, but I appear to have a different problem. My current test platform is 4.2-RELEASE with Peter's patch applied. I've also attempted this with 4.2-STABLE from late last week which included the patch. You are correct though that I should pester Compaq some more... --dustin > -----Original Message----- > From: Mike Smith [mailto:msmith@freebsd.org] > Sent: Saturday, January 13, 2001 8:39 PM > To: Dustin Harris > Cc: 'freebsd-smp@freebsd.org' > Subject: Re: Compaq DL360 Revisited > > > > I've traced the problem to the following code in mp_machdep.c in the > > function start_ap: > > > > /* wait for pending status end */ > > while (lapic.icr_lo & APIC_DELSTAT_MASK) > > /* spin */ ; > > > > It appears that I just "spin". Any ideas? What else can I > do to help > > troubleshoot this? Thanks. > > The problem with the DL360 is actually a BIOS bug. You should pester > Compaq for an update (they are aware of the problem if you > get through to > the right people), or update to -STABLE on your box (where > Peter Wemm has > committed a workaround). > > -- > ... every activity meets with opposition, everyone who acts has his > rivals and unfortunately opponents also. But not because people want > to be opponents, rather because the tasks and relationships force > people to take different points of view. [Dr. Fritz Todt] > V I C T O R Y N O T V E N G E A N C E > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-smp" in the body of the message