Date: Fri, 21 May 2004 00:55:56 +0100 From: "Steven Hartland" <killing@multiplay.co.uk> To: <freebsd-amd64@freebsd.org> Subject: Re: Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64? Message-ID: <007701c43ec5$ff0a6fd0$b3db87d4@multiplay.co.uk> References: <200405202235.46755.Gregor.Bittel@GMX.de> <5.2.0.9.2.20040520122752.015eec60@mail.ojoink.com> <Pine.LNX.4.53.0405201129570.22287@sql01.internal.mikehost.net> <5.2.0.9.2.20040520122752.015eec60@mail.ojoink.com> <5.2.0.9.2.20040520141038.0432d130@mail.ojoink.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,MMX,FXSR,SSE,SSE2>
AMD Features=0xe0500000<NX,AMIE,LM,DSP,3DNow!>
real memory = 4227268608 (4031 MB)
avail memory = 4113244160 (3922 MB)
ACPI APIC Table: <PTLTD APIC >
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?007701c43ec5$ff0a6fd0$b3db87d4>