From owner-freebsd-threads@FreeBSD.ORG Wed Oct 31 09:45:15 2007 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C75CF16A469 for ; Wed, 31 Oct 2007 09:45:15 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by mx1.freebsd.org (Postfix) with ESMTP id 43C6F13C4A8 for ; Wed, 31 Oct 2007 09:45:14 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: by nf-out-0910.google.com with SMTP id b2so68361nfb for ; Wed, 31 Oct 2007 02:44:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=xlSN08ARxGEr+BpR3noxMa1K5foe0rTduf+Fw+RB86Y=; b=OevGHLJx8zdTky4QqlDYQsazlyynfkaPNXyCiAIfswuHdfhSCyC5d8NoluoGzK9FpSHnCfjsLsc7ZWta7gbzeOImPH3X361uwj9epOpZP+J/86x6C8fIAV3eKPO5kGMSzpnxBWGF6ChnitfJXCLkDS3W/InFqG5AJahHcbVghhQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Oz0RfS0mEG7s9agfhooTwP8aUjqbWqn5ume8ZYKxUxLQrwU5ZbFE2h8rCxlJG78voZgd5MkmLZYsI30ytFBNsSRWsSwXrD9FzR/95Y1LjkHXNKCUlgHnCL4nq3KtI4yaCW13hFR0F5ksIZ4dNWIZsHfSgCiEGHRcFw68xv9nAeM= Received: by 10.86.99.9 with SMTP id w9mr6446689fgb.1193822252326; Wed, 31 Oct 2007 02:17:32 -0700 (PDT) Received: by 10.86.2.1 with HTTP; Wed, 31 Oct 2007 02:17:32 -0700 (PDT) Message-ID: <499c70c0710310217k3e55b66en23d32c2f6a613c99@mail.gmail.com> Date: Wed, 31 Oct 2007 12:17:32 +0300 From: "Abdullah Ibn Hamad Al-Marri" To: "David Xu" In-Reply-To: <4727E907.4090308@freebsd.org> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4727E907.4090308@freebsd.org> Cc: freebsd-threads@freebsd.org Subject: Re: PTHREAD_YIELDLOOPS boosts mysql super-smack performance X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 31 Oct 2007 09:45:15 -0000 On Oct 31, 2007 5:31 AM, David Xu wrote: > I did a simple mysql super-smack benchmark test on a Intel XEON machine, > the CPU has 4 cores: > CPU: Intel(R) Xeon(R) CPU 5130 @ 2.00GHz (1997.03-MHz) > > > I have set environment variable LIBPTHREAD_YIELDLOOPS to 30 and start > mysql server: > > setenv LIBPTHREAD_YIELDLOOPS 30 > /usr/local/etc/rc.d/mysql-server start > > and repeat doing > #super-smack ./select-key.smack 10 20000 > > The result is very surprising: > > # /usr/src/tools/tools/ministat/ministat normal.txt yield_30.txt > > x normal.txt > + yield_30.txt > +-----------------------------------------------------------------------------------------------------------------------------------------------------------+ > | x x x > + > | > | x xxxx > + + ++ > | > |x x xxxxx x > + + + ++ + > | > |x x xxxxxxx x x > + + + ++++++ ++++ +++ ++ > +| > | |___A___| > |________M_A_________| > | > +-----------------------------------------------------------------------------------------------------------------------------------------------------------+ > N Min Max Median Avg Stddev > x 30 44790.57 48609.38 45831.065 45910.616 745.54679 > + 30 60521.95 73090.6 66008.135 66254.815 1953.4324 > Difference at 95.0% confidence > 20344.2 +/- 764.241 > 44.3126% +/- 1.66463% > (Student's t, pooled s = 1478.47) > > it seems over 44% performance is improved. > > > Regards, > David Xu > > _______________________________________________ > freebsd-threads@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-threads > To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" > David thank you! }:) When could you please commit these changes of libthr will hit RELENG_7 so we could benefit of these improvements? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/