From owner-freebsd-performance@FreeBSD.ORG Wed Jul 5 01:20:47 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0F8C616A4DD for ; Wed, 5 Jul 2006 01:20:47 +0000 (UTC) (envelope-from danial_thom@yahoo.com) Received: from web33306.mail.mud.yahoo.com (web33306.mail.mud.yahoo.com [68.142.206.121]) by mx1.FreeBSD.org (Postfix) with SMTP id A05E243D46 for ; Wed, 5 Jul 2006 01:20:46 +0000 (GMT) (envelope-from danial_thom@yahoo.com) Received: (qmail 47949 invoked by uid 60001); 5 Jul 2006 01:20:46 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=i1JvmmG934VkBQSN/1JT8/C7tpt+zSD4d73sC3rjY7FUh1Qh5cP5zy7KeCVBjbWB9N4BIcpFU3w7H58JH4hUFB7qXRXtrxVFkjbtlGLh57KxRQTE7uwZIZZT+pxFoW+D51LPLw2zA/uLKzPRAuHjLq2CffNYIdf7btJhDJyaO+U= ; Message-ID: <20060705012046.47947.qmail@web33306.mail.mud.yahoo.com> Received: from [24.46.186.215] by web33306.mail.mud.yahoo.com via HTTP; Tue, 04 Jul 2006 18:20:46 PDT Date: Tue, 4 Jul 2006 18:20:46 -0700 (PDT) From: Danial Thom To: Hugo Silva , freebsd-performance@freebsd.org In-Reply-To: <44A894B0.3010506@barafranca.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: Subject: Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: danial_thom@yahoo.com List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jul 2006 01:20:47 -0000 --- Hugo Silva wrote: > Today I decided to benchmark MySQL 5 > performance on FreeBSD 6.1-STABLE. > This server is a Dual Xeon 2.8GHz, 4GB of RAM > and 2x73GB SCSI disks that > do 320MB/s > > For all the tests, I restarted mysqld prior to > starting the test, > waited for about 1 minute for it to settle > down, and ran super smack. > For the consecutive runs, I executed > super-smack right after the > previous run ended. > > Switching from HTT to no HTT was achieved by > machdep.hyperthreading_allowed, and switching > from/to libpthread/libthr > was done via libmap.conf. > > System: > > FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: > Mon Jul 3 03:10:35 UTC > 2006 ??@??:/usr/obj/usr/src/sys/DATABASE > i386 > > Here are the results: > > > MySQL 5.0.22, built with BUILD_OPTIMIZED=yes > and WITH_PROC_SCOPE_PTH=yes > > > === 4BSD + libthr + HTT on === > > Run #1 > connect: max=4ms min=1ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 20405.86 > > Run #2 > connect: max=3ms min=1ms avg= 2ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 20253.53 > > Run #3 > connect: max=4ms min=2ms avg= 2ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 20270.33 > > > > > === 4BSD + libthr + HTT off === > > Run #1 > connect: max=5ms min=2ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 18253.60 > > Run #2 > connect: max=6ms min=1ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 18350.27 > > Run #3 > connect: max=4ms min=1ms avg= 2ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 18529.71 > > > === 4BSD + libpthread + HTT on === > > Run #1: > connect: max=17ms min=2ms avg= 7ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 5 0 > 3935.94 > > > Run #2: > connect: max=18ms min=1ms avg= 8ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 2 0 > 3919.89 > > Run #3: > connect: max=22ms min=1ms avg= 13ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 2 0 > 3911.66 > > > === 4BSD + libpthread + HTT off === > connect: max=12ms min=1ms avg= 5ms from 10 > clients > > Run #1: > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 11193.40 > > Run #2: > connect: max=6ms min=4ms avg= 5ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 11428.30 > > Run #3: > connect: max=7ms min=4ms avg= 5ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 1 0 > 13714.02 > > > > > > > > > > > > === ULE + libthr + HTT on === > Run #1: > connect: max=2ms min=0ms avg= 0ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 1 0 > 16179.09 > > Run #2: > connect: max=14ms min=0ms avg= 7ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 17451.31 > > Run #3: > connect: max=5ms min=1ms avg= 3ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 1 0 > 15787.02 > > > === ULE + libthr + HTT off === > > Run #1: > connect: max=6ms min=6ms avg= 6ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 11588.19 > > Run #2: > connect: max=220ms min=2ms avg= 46ms from 10 > clients > Query_type num_queries max_time > min_time q_per_s > select_index 200000 0 0 > 10651.16 > > Run #3: > connect: max=10ms min=0ms avg= 5ms from 10 > clients > Query_type num_queries max_time > min_time === message truncated === Instead of wasting your time with BS benchmarks, why not write a little script that does actual queries that you might be doing on a real, fully populated database? And make sure you test with 1 cpu. I don't see any "scaling" from 1 cpu to 2, so I can't get too excited about supersmack's miniscule scaling. The only scaling I see going from 1 cpu to 2 is about 300 extra dollars for the dual-core cpu. Besides, HTT will slow everything else on the system down, so its not practical to turn it on. For every benchmark that shows a tiny bit of improvement there are 5 that show degradation. DT __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com