From owner-freebsd-stable@FreeBSD.ORG Fri Jan 11 11:09:58 2008 Return-Path: Delivered-To: stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9B7BB16A420; Fri, 11 Jan 2008 11:09:58 +0000 (UTC) (envelope-from krassi@bulinfo.net) Received: from mx.bulinfo.net (mx.bulinfo.net [193.194.156.1]) by mx1.freebsd.org (Postfix) with ESMTP id 1F59413C43E; Fri, 11 Jan 2008 11:09:58 +0000 (UTC) (envelope-from krassi@bulinfo.net) Received: from localhost (localhost [127.0.0.1]) by mx.bulinfo.net (Postfix) with ESMTP id E67573569B; Fri, 11 Jan 2008 13:09:56 +0200 (EET) Received: from mx.bulinfo.net ([127.0.0.1]) by localhost (mx.bulinfo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 92371-06; Fri, 11 Jan 2008 13:09:55 +0200 (EET) Received: from [192.168.2.188] (pythia.bulinfo.net [212.72.195.5]) by mx.bulinfo.net (Postfix) with ESMTP id 2ED9635697; Fri, 11 Jan 2008 13:09:55 +0200 (EET) Message-ID: <47874E82.8060905@bulinfo.net> Date: Fri, 11 Jan 2008 13:09:54 +0200 From: Krassimir Slavchev User-Agent: Thunderbird 2.0.0.9 (X11/20071122) MIME-Version: 1.0 To: Kris Kennaway References: <476A5EE1.9000003@bulinfo.net> <476FF662.6050604@FreeBSD.org> <477BB7C0.3060603@bulinfo.net> <477C1FA3.2070904@FreeBSD.org> <477CC7DC.6060801@bulinfo.net> <47840D21.6060807@FreeBSD.org> <47847681.9040304@bulinfo.net> <478479CA.7070000@FreeBSD.org> <4784A4B0.5070403@bulinfo.net> <4784A817.2080305@FreeBSD.org> <4784C0B1.3060108@bulinfo.net> <47851797.8050200@FreeBSD.org> <4785D308.2080903@bulinfo.net> <47867FE7.70403@FreeBSD.org> In-Reply-To: <47867FE7.70403@FreeBSD.org> X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at mx.bulinfo.net Cc: stable@freebsd.org Subject: Re: Performance! X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Jan 2008 11:09:58 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kris Kennaway wrote: > Krassimir Slavchev wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Kris Kennaway wrote: >>> Krassimir Slavchev wrote: >>>> -----BEGIN PGP SIGNED MESSAGE----- >>>> Hash: SHA1 >>>> >>>> Hello, >>>> >>>> Kris Kennaway wrote: >>>>> Krassimir Slavchev wrote: >>>>>> -----BEGIN PGP SIGNED MESSAGE----- >>>>>> Hash: SHA1 >>>>>> >>>>>> Hello, >>>>>> >>>>>> Here are lock profiling results with select patch applied. >>>>> OK, you are doing I/O over TCP. Are you sure you are using TCP on >>>>> both >>>>> systems? Linux may not be defaulting to TCP transport for local >>>>> queries. >>>>> >>>>> Add --pgsql-host="" to your sysbench command line to make it >>>>> communicate >>>>> over a local domain socket, which is much more efficient. >>>>> >>>>> Kris >>>>> >>>> Hmm, Yes linux uses local domain sockets! >>>> Here are results using local domain sockets on FreeBSD too: >>>> #threads #tranzactions/sec >>>> 1 728 >>>> 5 2996 >>>> 10 5301 >>>> 20 3931 >>>> 40 2466 >>>> 60 1852 >>>> 80 1424 >>>> 100 1216 >>>> >>>> Just to remember: >>>> Linux (2.6.18) >>>> #threads #transactions/sec >>>> 1 693 >>>> 5 3539 >>>> 10 5789 >>>> 20 5791 >>>> 40 5661 >>>> 60 5517 >>>> 80 5401 >>>> 100 5319 >>>> >>>> I have results using Fedora 8 on the same hardware: >>>> Linux (2.6.23) >>>> #threads #transactions/sec >>>> 1 740 >>>> 5 2675 >>>> 10 6486 >>>> 20 6893 >>>> 40 6623 >>>> 60 6623 >>>> 80 6522 >>>> 100 6417 >>>> >>>> If we look at the results with up to 10 threads the performance of >>>> FreeBSD is very good. >>>> May be something can be tuned for number of threads > number of CPUs? >>>> >>>> Are you interested in lock profiling statistics with more threads than >>>> the number of CPUs? >>> Yes, it's still performing anomalously. Glad we're making progress >>> though :) >>> >>> Kris >>> >> >> Okay, but how many threads will be more useful to test with? > > Let's start with 8 and say 40. The two problems seem to be slightly > lower peak and poor scaling above peak. They might be the same, or they > might be different. > > kris > > I sent to you the results with 8 and 40 threads. The lower peak may be caused by differences in installations like different partitions I use ... The most important is keeping performance above this peak. Best Regards -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQFHh06CxJBWvpalMpkRAjosAJ0djbiU/foRiI+/ne1YyuqnVjKOaACfRCpV fI3vb0m1I+fIZ1M7cHCBjR8= =jiPg -----END PGP SIGNATURE-----