Date: Mon, 21 Feb 2005 07:38:40 +0800 From: David Xu <davidxu@freebsd.org> To: Robert Watson <rwatson@freebsd.org> Cc: threads@freebsd.org Subject: Re: libpthread vs libthread, simply mysql benchmark (fwd) Message-ID: <42191F80.9030207@freebsd.org> In-Reply-To: <Pine.NEB.3.96L.1050219133332.67347W-100000@fledge.watson.org> References: <Pine.NEB.3.96L.1050219133332.67347W-100000@fledge.watson.org>
next in thread | previous in thread | raw e-mail | index | archive | help
May I import the library into tree ? I remembered that someone said if it is not in cvs tree, few of people will try it. if people tried it, and find it is not valuable, I can remove it from tree. David Xu Robert Watson wrote: >FYI. > >Robert N M Watson > >---------- Forwarded message ---------- >Date: Sat, 19 Feb 2005 13:16:06 +0000 (GMT) >From: Robert Watson <rwatson@FreeBSD.org> >To: performance@FreeBSD.org >Subject: libpthread vs libthread, simply mysql benchmark > > >In case it's of interest -- I occasionally run MySQL "supersmack" >benchmarks at work on a dual Xeon box there. I ran the select benchmark >on the box a few minutes ago, comparing libpthread and David Xu's new >libthread on the box, and the results are pleasing: > >x 6-SMP-HTT-libpthread >+ 6-SMP-HTT-libthread >+--------------------------------------------------------------------------+ >| x + | >| x ++ | >| xxx +++ | >|xxxxx +++ +| >| |MA| |A| | >+--------------------------------------------------------------------------+ > N Min Max Median Avg Stddev >x 10 8300.25 8442.54 8379.03 8381.652 39.682672 >+ 10 10510.35 10646.98 10547.59 10551.599 39.893907 >Difference at 95.0% confidence > 2169.95 +/- 37.385 > 25.8893% +/- 0.446034% > (Student's t, pooled s = 39.7884) > >In other words, a clear (and healthy) 26% performance improvement on this >simple benchmark. I don't currently have other numbers to compare >against, such as linuxthreads, etc. > >This is a 2.4GHz box with 1gb of memory running MySQL 4.0.23a. Typically, >I get better performance without hyper-threading turned on, but I can't >get into the BIOS of the box remotely so couldn't turn it off properly. I >used the latest 6.x SMP kernel combined with the libthread drop from >David's perforce branch. You can find a URL to his more recent code drops >in the recent threads on freebsd-threads. > >FYI, here's a brief history of HTT performance over the past year as 5.x >and 6.x matured: > >Version Transactions/sec >20040515-UP-4BSD 4862 >20040515-SMP-4BSD 4620 >20040515-SMP-ADMTX-4BSD 4846 > >20040615-UP-4BSD 4899 >20040616-SMP-4BSD 4941 >20040616-SMP-ADMTX-4BSD 4979 > >20040616-netperf-UP-giant-4BSD 4907 >20040616-netperf-UP-mpsafe-4BSD 4939 >20040616-netperf-SMP-giant-4BSD 4587 >20040616-netperf-SMP-mpsafe-4BSD 4609 >20040616-netperf-SMP-ADMTX-giant-4BSD 4662 >20040616-netperf-SMP-ADMTX-mpsafe-4BSD 6425 > >20040713-netperf-SMP-ADMTX-mpsafe-4BSD 7063 > >20040717-netperf-SMP-ADMTX-mpsafe-4BSD 7118 > >As of today, I get about 8400tps with HTT turned on, probably a bit >betterwith it turned off. By combining various factors we've introduced >in the last couple of years, such as MPSAFE network stack, scheduling >improvements, threading improvements, mutex changes, etc, we've improved >performance on mysql by over 100% on SMP, going from quite sub-par >performance in the depths of 5.x development (when all the infrastructure >changes were going in but no optimizations) to quite healthy in 6.x, >especially with the new threading library. > >Robert N M Watson > >_______________________________________________ >freebsd-performance@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-performance >To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org" > >_______________________________________________ >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" > > > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42191F80.9030207>