From owner-freebsd-hackers@FreeBSD.ORG Mon Nov 15 20:50:38 2004 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1E8D116A4CE for ; Mon, 15 Nov 2004 20:50:38 +0000 (GMT) Received: from bsdhosting.net (bsdhosting.net [65.39.221.113]) by mx1.FreeBSD.org (Postfix) with SMTP id 90A6543D4C for ; Mon, 15 Nov 2004 20:50:37 +0000 (GMT) (envelope-from jhopper@bsdhosting.net) Received: (qmail 3896 invoked from network); 15 Nov 2004 20:48:48 -0000 Received: from unknown (HELO ?192.168.1.2?) (jhopper@bsdhosting.net@65.39.221.113) by bsdhosting.net with SMTP; 15 Nov 2004 20:48:48 -0000 From: Justin Hopper To: freebsd-hackers@freebsd.org Content-Type: text/plain Message-Id: <1100551835.5412.641.camel@work.gusalmighty.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Mon, 15 Nov 2004 12:50:35 -0800 Content-Transfer-Encoding: 7bit Subject: MySQL benchmarks X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 15 Nov 2004 20:50:38 -0000 Here are the results of the brief benchmarks that I ran. I posted the best and worse results out of running each test 5 times. ----------------- System: Dual Opteron 244s RAM 1GB 3 x 36GB U320 SCSI RAID-5 on Adaptec 2120s ----------------- OS: FreeBSD 5.3-RELEASE FreeBSD 5.3-RELEASE #2: Mon Nov 15 10:35:13 PST 2004 i386 ----------------------------------------------------------- MySQL 4.1.7 WITH_OPENSSL BUILD_OPTIMIZED ----------------------------------------------------------- master# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=15ms min=4ms avg= 8ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 3 0 4365.04 update_index 300000 4 0 4365.04 master# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=12ms min=0ms avg= 7ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 3 0 4799.58 update_index 300000 3 0 4799.58 master# super-smack select-key.smack 30 10000 Query Barrel Report for client smacker1 connect: max=10ms min=7ms avg= 9ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 600000 3 0 10614.75 master# super-smack select-key.smack 30 10000 Query Barrel Report for client smacker1 connect: max=10ms min=6ms avg= 7ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 600000 4 0 10666.14 ----------------------------------------------------------- MySQL 4.0.22 WITH_OPENSSL BUILD_OPTIMIZED ----------------------------------------------------------- master# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=13ms min=9ms avg= 11ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 3 0 4839.98 update_index 300000 3 0 4839.98 master# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=22ms min=0ms avg= 17ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 3 0 4963.34 update_index 300000 2 0 4963.34 master# super-smack select-key.smack 30 10000 Query Barrel Report for client smacker1 connect: max=19ms min=5ms avg= 9ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 600000 2 0 12387.57 master# super-smack select-key.smack 30 10000 Query Barrel Report for client smacker1 connect: max=15ms min=0ms avg= 7ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 600000 2 0 13201.30 -------------------------------------------------------------- It seems 4.0.22 is faster in each benchmark. Around a 20% increase. I wonder why this is? -- Justin Hopper UNIX Systems Engineer BSDHosting.net Hosting Division of Digital Oasys Inc. http://www.bsdhosting.net