From owner-freebsd-amd64@FreeBSD.ORG Wed May 19 10:29:15 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6612216A4CE for ; Wed, 19 May 2004 10:29:15 -0700 (PDT) Received: from mail1.speakeasy.net (mail1.speakeasy.net [216.254.0.201]) by mx1.FreeBSD.org (Postfix) with ESMTP id 296D743D2D for ; Wed, 19 May 2004 10:29:15 -0700 (PDT) (envelope-from jmg@hydrogen.funkthat.com) Received: (qmail 30201 invoked from network); 19 May 2004 17:29:14 -0000 Received: from gate.funkthat.com (HELO hydrogen.funkthat.com) ([69.17.45.168]) (envelope-sender ) by mail1.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 19 May 2004 17:29:14 -0000 Received: from hydrogen.funkthat.com (uzmjkt@localhost.funkthat.com [127.0.0.1])i4JHTEEx058475; Wed, 19 May 2004 10:29:14 -0700 (PDT) (envelope-from jmg@hydrogen.funkthat.com) Received: (from jmg@localhost) by hydrogen.funkthat.com (8.12.10/8.12.10/Submit) id i4JHTE6w058474; Wed, 19 May 2004 10:29:14 -0700 (PDT) Date: Wed, 19 May 2004 10:29:13 -0700 From: John-Mark Gurney To: JG Message-ID: <20040519172913.GU601@funkthat.com> Mail-Followup-To: JG , freebsd-amd64@freebsd.org References: <5.2.0.9.2.20040519052743.04365f78@mail.ojoink.com> <5.2.0.9.2.20040518170424.03c42748@mail.ojoink.com> <200405181359.18291.peter@wemm.org> <5.2.0.9.2.20040518103357.04c6cbb8@mail.ojoink.com> <5.2.0.9.2.20040518103357.04c6cbb8@mail.ojoink.com> <5.2.0.9.2.20040519052743.04365f78@mail.ojoink.com> <5.2.0.9.2.20040519060611.0435f750@mail.ojoink.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5.2.0.9.2.20040519060611.0435f750@mail.ojoink.com> User-Agent: Mutt/1.4.1i X-Operating-System: FreeBSD 4.2-RELEASE i386 X-PGP-Fingerprint: B7 EC EF F8 AE ED A7 31 96 7A 22 B3 D8 56 36 F4 X-Files: The truth is out there X-URL: http://resnet.uoregon.edu/~gurney_j/ X-Resume: http://resnet.uoregon.edu/~gurney_j/resume.html cc: freebsd-amd64@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: John-Mark Gurney List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 May 2004 17:29:15 -0000 JG wrote this message on Wed, May 19, 2004 at 06:07 -0700: > At 04:53 PM 5/19/2004 +0400, you wrote: > >In first time you built MySQL statically. > >Now - dinamically. > > > >What results with statical linked MySQL ? > > > >JG wrote: > > Those results are in earlier posts of this thread. > > I compiled it dynamically to be sure that libpthreads was used. > (so I could use ldd against mysqld) There is a patch to make use of _SYSTEM scoped threads instead of process scoped threads for mysql mentioned ealier.. Also, if you use libmap to remap libpthread to libthr, you'll have similar results... libpthread (aka libkse) is a design for M:N threads, and requires the user of pthreads to create new system scoped threads to make use of multiple cpu's... libthr is a design of 1:1 threads where each thread has it's own process, and will automaticly use multiple cpu's w/o regard to the scope of the thread that is set... Also, when running the tests, make sure that you run vmstat -w 1 or something similar, and make sure that the id drops to 20 or less... If it doesn't, you're probably still using a single execution thread for it... -- John-Mark Gurney Voice: +1 415 225 5579 "All that I will do, has been done, All that I have, has not."