Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 23 May 2004 21:14:27 +0200
From:      Ivan Voras <ivoras@fer.hr>
To:        JG <amd64list@jpgsworld.com>
Cc:        freebsd-threads@freebsd.org
Subject:   Re: Why is MySQL nearly twice as fast on Linux?
Message-ID:  <40B0F813.3010903@fer.hr>
In-Reply-To: <5.2.0.9.2.20040523100537.014613a8@mail.ojoink.com>
References:  <5.2.0.9.2.20040523084628.016296b0@mail.ojoink.com> <5.2.0.9.2.20040523100537.014613a8@mail.ojoink.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?40B0F813.3010903>