From owner-freebsd-hackers Tue Sep 10 10:34:23 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 C71DE37B400 for ; Tue, 10 Sep 2002 10:34:20 -0700 (PDT) Received: from search.sparks.net (d-207-5-180-136.gwi.net [207.5.180.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6AE8E43E65 for ; Tue, 10 Sep 2002 10:34:20 -0700 (PDT) (envelope-from dmiller@sparks.net) Received: by search.sparks.net (Postfix, from userid 100) id EDCEFD984; Tue, 10 Sep 2002 13:30:23 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id E98E8D983; Tue, 10 Sep 2002 13:30:23 -0400 (EDT) Date: Tue, 10 Sep 2002 13:30:23 -0400 (EDT) From: hackers@d.sparks.net X-Sender: dmiller@search.sparks.net To: Dominic Marks Cc: freebsd-hackers@freebsd.org Subject: Re: Dell 2650 SMP perf question In-Reply-To: <20020910172724.GB889@gallium> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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, 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 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message