From owner-freebsd-hackers Tue Sep 10 10:49:40 2002 Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 677A837B400 for ; Tue, 10 Sep 2002 10:49:38 -0700 (PDT) Received: from host217-41-48-43.in-addr.btopenworld.com (host217-41-48-43.in-addr.btopenworld.com [217.41.48.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id D512B43E75 for ; Tue, 10 Sep 2002 10:49:37 -0700 (PDT) (envelope-from dom@host217-41-48-43.in-addr.btopenworld.com) Received: by host217-41-48-43.in-addr.btopenworld.com (Postfix, from userid 1001) id E9A8C512; Tue, 10 Sep 2002 18:50:13 +0100 (BST) Date: Tue, 10 Sep 2002 18:50:13 +0100 From: Dominic Marks To: hackers@d.sparks.net Cc: freebsd-hackers@freebsd.org Subject: Re: Dell 2650 SMP perf question Message-ID: <20020910175013.GA974@gallium> References: <20020910172724.GB889@gallium> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.1i Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Tue, Sep 10, 2002 at 01:30:23PM -0400, hackers@d.sparks.net wrote: > On Tue, 10 Sep 2002, Dominic Marks wrote: > > > On Tue, Sep 10, 2002 at 01:16:40PM -0400, hackers@d.sparks.net wrote: > > > Hi All; > > > > > > Hyperthreading is turned off, I believe. There aren't any > > > "hyperthreading" swithes in the bios I could find, but the "logical > > > processor" option is turned off. > > > > > > > > > Clues why SMP is so much slower very welcome indeed. > > > > I believe at some point in the not too distant past their have been many > > performance problems for people using MySQL on FreeBSD. These problems > > where mostly related to MySQL's use of threads, I don't know if these > > problems have been fully resolved but it could be that SMP is > > aggrevating this. Watching what MySQL is doing with a trace might show > > some interesting results. > > Threads, mysql, and FreeBSD have been an unsocial group for a while, and > running two processes that access the same tables does seem to slow things > down a lot. Tracing it might show something of interest to someone, and > I'm happy to do it if it will help. I wouldn't have a clue what I was > looking at, and couldn't fix it if I did. > > > I suppose you're running the lastest version of MySQL ? > > I've tried 4.03b, 4.02a, and 3.23.x, all show similar results:( > > Thanks, > > --- David > My very small pool of knowledge about MySQL+FreeBSD is now exhausted. It's not answering the question to ask if you see any better or worse results with different software. But you might like to try with another Database (Postgres ?) to see if the poor performance on SMP appears with it too. Good Luck, -- Dominic Marks Computer & Politics Geek [work]::[npl.co.uk] << dominic.marks at npl.co.uk >> [educ]::[umist.ac.uk] << notyet-known at umist.ac.uk >> [home]::[btinternet] << dominic_marks at btinternet.com >> To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message