From owner-freebsd-current@FreeBSD.ORG Fri Oct 22 07:55:41 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D60C016A4CE for ; Fri, 22 Oct 2004 07:55:41 +0000 (GMT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id D365143D39 for ; Fri, 22 Oct 2004 07:55:36 +0000 (GMT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=ganbold.micom.mng.net) by publicd.ub.mng.net with asmtp (Exim 4.41 (FreeBSD)) id 1CKuIy-000Ozk-4B for freebsd-current@freebsd.org; Fri, 22 Oct 2004 15:57:46 +0800 Message-Id: <6.1.2.0.2.20041022154756.02b67090@202.179.0.80> X-Sender: ganbold@micom.mng.net@202.179.0.80 X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Fri, 22 Oct 2004 15:55:08 +0900 To: freebsd-current@freebsd.org From: Ganbold Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: mysql super-smack test on FreeBSD 5.3-RC1 amd64 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 22 Oct 2004 07:55:41 -0000 Here's benchmark I just did... ----------------------------------------------------------------------- System Specs: IBM @server 325 type 8835 Dual AMD Opteron 2.1ghz 4GB (2x2GB) PC-2700 ECC memory 6x36GB hot swap RAID5 Ultra 320 SCSI HDD ServeRAID 6M controller ------------------------------------------------------------------------- OS / Software Configuration: FreeBSD amd.micom.mng.net 5.3-RC1 FreeBSD 5.3-RC1 #1: Fri Oct 22 12:17:38 ULAT 2004 root@amd.micom.mng.net:/usr/obj/usr/src/sys/AMD amd64 MySQL Compiled from mysql40-server port with: BUILD_OPTIMIZED=yes BUILD_STATIC=yes amd# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=14ms min=5ms avg= 7ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 3 0 4231.18 update_index 300000 3 0 4231.18 amd# super-smack select-key.smack 30 10000 Query Barrel Report for client smacker1 connect: max=18ms min=5ms avg= 11ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 600000 4 0 10030.74 regards, Ganbold