From owner-freebsd-performance@FreeBSD.ORG Thu Apr 20 10:24:58 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 14AD716A402 for ; Thu, 20 Apr 2006 10:24:58 +0000 (UTC) (envelope-from killing@multiplay.co.uk) Received: from multiplay.co.uk (core6.multiplay.co.uk [85.236.96.23]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1E5E243D6A for ; Thu, 20 Apr 2006 10:24:51 +0000 (GMT) (envelope-from killing@multiplay.co.uk) Received: from vader ([212.135.219.179]) by multiplay.co.uk (multiplay.co.uk [85.236.96.23]) (MDaemon.PRO.v8.1.3.R) with ESMTP id md50002486279.msg for ; Thu, 20 Apr 2006 11:24:56 +0100 Message-ID: <00cf01c66464$a3a5ff30$b3db87d4@multiplay.co.uk> From: "Steven Hartland" To: "Steven Hartland" , "Sven Petai" , Date: Thu, 20 Apr 2006 11:24:37 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Spam-Processed: multiplay.co.uk, Thu, 20 Apr 2006 11:24:56 +0100 (not processed: message from valid local sender) X-MDRemoteIP: 212.135.219.179 X-Return-Path: killing@multiplay.co.uk X-MDaemon-Deliver-To: freebsd-performance@freebsd.org X-MDAV-Processed: multiplay.co.uk, Thu, 20 Apr 2006 11:24:56 +0100 Cc: Subject: Re: mysql performance on 4 * dualcore opteron X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Apr 2006 10:24:58 -0000 Just retested on a dual dual core so 2 * as quick as before Dual 265 ( 4 * 1.8 Ghz Cores ) == 4BSD + libthr + ACPI-Fast == super-smack -d mysql select-key.smack 100 10000 Query Barrel Report for client smacker1 connect: max=36ms min=0ms avg= 18ms from 100 clients Query_type num_queries max_time min_time q_per_s select_index 2000000 13 0 38965.71 super-smack -d mysql select-key.smack 10 100000 Query Barrel Report for client smacker1 connect: max=2ms min=0ms avg= 1ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 2000000 0 0 42344.21 Dual 244 ( 2 * 1.8 Ghz Cores ) == 4BSD + libthr + ACPI-Fast == super-smack -d mysql select-key.smack 100 10000 Query Barrel Report for client smacker1 connect: max=107ms min=2ms avg= 45ms from 100 clients Query_type num_queries max_time min_time q_per_s select_index 2000000 13 0 22413.39 super-smack -d mysql select-key.smack 10 100000 Query Barrel Report for client smacker1 connect: max=2ms min=1ms avg= 1ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 2000000 0 0 26841.07 So pretty good scaling there. Steve ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137 or return the E.mail to postmaster@multiplay.co.uk.