From owner-freebsd-amd64@FreeBSD.ORG Thu May 20 16:57:03 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B9C0316A4CE for ; Thu, 20 May 2004 16:57:03 -0700 (PDT) Received: from multiplay.co.uk (www1.multiplay.co.uk [212.42.16.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1D3E743D1D for ; Thu, 20 May 2004 16:57:03 -0700 (PDT) (envelope-from killing@multiplay.co.uk) Received: from vader ([212.135.219.179]) by multiplay.co.uk (multiplay.co.uk [212.42.16.7]) (MDaemon.PRO.v7.1.0.R) with ESMTP id md50000223708.msg for ; Fri, 21 May 2004 00:54:17 +0100 Message-ID: <007701c43ec5$ff0a6fd0$b3db87d4@multiplay.co.uk> From: "Steven Hartland" To: References: <200405202235.46755.Gregor.Bittel@GMX.de> <5.2.0.9.2.20040520122752.015eec60@mail.ojoink.com> <5.2.0.9.2.20040520122752.015eec60@mail.ojoink.com> <5.2.0.9.2.20040520141038.0432d130@mail.ojoink.com> Date: Fri, 21 May 2004 00:55:56 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Spam-Processed: multiplay.co.uk, Fri, 21 May 2004 00:54:17 +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-amd64@freebsd.org X-MDAV-Processed: multiplay.co.uk, Fri, 21 May 2004 00:54:18 +0100 Subject: Re: Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 May 2004 23:57:03 -0000 Ok some results for the pile: Server spec: CPU: AMD Opteron(tm) Processor 248 (2193.17-MHz 686-class CPU) Origin = "AuthenticAMD" Id = 0xf58 Stepping = 8 Features=0x78bfbff AMD Features=0xe0500000 real memory = 4227268608 (4031 MB) avail memory = 4113244160 (3922 MB) ACPI APIC Table: FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 FreeBSD freebsd32 5.2.1-RELEASE-p6 FreeBSD 5.2.1-RELEASE-p6 #1: Mon May 10 05:14:51 BST 2004 root@freebsd32:/usr/src/sys/i386/compile/MPUK_SMP_200HZ i386 mysql40 built using: make BUILD_OPTIMIZED=yes BUILD_STATIC=yes; make install Local test: Generating 500000 records... Creation of 500000 records took 21 seconds. Average of 23809.523809524 records per second. Creating records for 10 seconds... Created 231597 records in 10 seconds. Average of 23159.7 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 2 seconds. Average of 25000 records per second. Creating random md5 hash records for 10 seconds... Created 186818 random records in 10 seconds. Average of 18681.8 records per second. Your databases overall average score is 22662.755952381 records per second. remote test1: FreeBSD yoda.multiplay.co.uk 5.1-RELEASE-p14 FreeBSD 5.1-RELEASE-p14 #1: Wed Mar 10 21:26:06 GMT 2004 root@yoda.multiplay.co.uk:/usr/src/sys/i386/compile/YODA i386 Generating 500000 records... Creation of 500000 records took 248 seconds. Average of 2016.1290322581 records per second. Creating records for 10 seconds... Created 18406 records in 10 seconds. Average of 1840.6 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 27 seconds. Average of 1851.8518518519 records per second. Creating random md5 hash records for 10 seconds... Created 17930 random records in 10 seconds. Average of 1793 records per second. Your databases overall average score is 1875.3952210275 records per second. remote test2 P4 2.4Ghz WinXP @ 100Mb: Generating 500000 records... Creation of 500000 records took 191 seconds. Average of 2617.80104712 records per second. Creating records for 10 seconds... Created 23486 records in 10 seconds. Average of 2348.6 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 19 seconds. Average of 2631.57894737 records per second. Creating random md5 hash records for 10 seconds... Created 24087 random records in 10 seconds. Average of 2408.7 records per second. Your databases overall average score is 2501.66999862 records per second remote test2 P4 2.4Ghz WinXP @ 1Gb Generating 500000 records... Creation of 500000 records took 145 seconds. Average of 3448.27586207 records per second. Creating records for 10 seconds... Created 34275 records in 10 seconds. Average of 3427.5 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 15 seconds. Average of 3333.33333333 records per second. Creating random md5 hash records for 10 seconds... Created 29175 random records in 10 seconds. Average of 2917.5 records per second. Your databases overall average score is 3281.65229885 records per second. local again removing $end = time() from 500000 loop: Generating 500000 records... Creation of 500000 records took 19 seconds. Average of 26315.789473684 records per second. Creating records for 10 seconds... Created 212340 records in 10 seconds. Average of 21234 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 2 seconds. Average of 25000 records per second. Creating random md5 hash records for 10 seconds... Created 187897 random records in 10 seconds. Average of 18789.7 records per second. Your databases overall average score is 22834.872368421 records per second. While running the remote tests the cpu load on the AMD never went above 15% packets per second peaked on the Gig crossover test @ 3500 Conclusion there is a major IO bottleneck here somewhere. Steve / K ================================================ 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.