From owner-freebsd-threads@FreeBSD.ORG Sun May 23 12:15:02 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0E15D16A4CE for ; Sun, 23 May 2004 12:15:02 -0700 (PDT) Received: from geri.cc.fer.hr (geri.cc.fer.hr [161.53.72.107]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2559F43D48 for ; Sun, 23 May 2004 12:15:01 -0700 (PDT) (envelope-from ivoras@fer.hr) Received: from [127.0.0.1] (root@geri.cc.fer.hr [161.53.72.107]) by geri.cc.fer.hr (8.12.9p2/8.12.8) with ESMTP id i4NJDqUh062087; Sun, 23 May 2004 21:13:52 +0200 (CEST) (envelope-from ivoras@fer.hr) Message-ID: <40B0F813.3010903@fer.hr> Date: Sun, 23 May 2004 21:14:27 +0200 From: Ivan Voras User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: JG References: <5.2.0.9.2.20040523084628.016296b0@mail.ojoink.com> <5.2.0.9.2.20040523100537.014613a8@mail.ojoink.com> In-Reply-To: <5.2.0.9.2.20040523100537.014613a8@mail.ojoink.com> X-Enigmail-Version: 0.84.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig9429D9AEF482A7FB23F39E7E" cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 23 May 2004 19:15:02 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig9429D9AEF482A7FB23F39E7E Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit JG wrote: > I'm just getting frustrated here having to go from list to list and > repeat everything that has already been posted each time as > each group wants to push the problem on another group... > starting to remind me of the Healthcare system, but none of us > can fix that problem :P The worst thing is, this is not a new problem - various users have reported performance troubles with libpthread and/or mysql, including at this thread in freebsd-current: From: Alex.Kovalenko@verizon.net (Alexandre Sunny Kovalenko) Subject: Is it possible to make -lpthread program to use 100% CPU? Message-ID: <20040429111355.7eb83170.Alex.Kovalenko@verizon.net> Date: 29 Apr 2004 15:13:55 GMT It appears similar to your problems: quote: "I have turned off hyperthreading and got result, which muddles me rather -- try as I might, with -lpthread I could not get past 50% CPU utilization (as reported by 'top') and number of computations per second matching that (number is very close to that for running single-threaded). Top report with thread view enabled shows that both KSE are bound to CPU 0 (if I am interpreting C column properly). " His application is custom, doing "heavy duty computation on relatively small amount of data". -- C isn't that hard: void (*(*f[])())() defines f as an array of unspecified size, of pointers to functions that return pointers to functions that return void. --------------enig9429D9AEF482A7FB23F39E7E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAsPgcldnAQVacBcgRAm9MAKDwlEujwYdk3NqsrHKiAYCM5a4VngCgw338 IvJ4koWZkjDlQfN2cFPbk4E= =/rXv -----END PGP SIGNATURE----- --------------enig9429D9AEF482A7FB23F39E7E--