From owner-freebsd-amd64@FreeBSD.ORG Fri May 21 09:40:53 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 2F7EF16A4CE for ; Fri, 21 May 2004 09:40:53 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id EF2A343D46 for ; Fri, 21 May 2004 09:40:52 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 55832 invoked by uid 89); 21 May 2004 16:44:19 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 21 May 2004 16:44:19 -0000 Message-Id: <5.2.0.9.2.20040521093359.015497f0@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Fri, 21 May 2004 09:39:46 -0700 To: freebsd-amd64@freebsd.org From: JG In-Reply-To: <5.2.0.9.2.20040521071750.0152ac40@mail.ojoink.com> References: <5.2.0.9.2.20040521035925.01463f88@mail.ojoink.com> <017001c43f18$d4ef6400$7b07000a@int.mediasurface.com> <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> <007701c43ec5$ff0a6fd0$b3db87d4@multiplay.co.uk> <00de01c43eeb$f2753220$b3db87d4@multiplay.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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: Fri, 21 May 2004 16:40:53 -0000 Compare the last set of benchmarks to these new ones. Using Linux Mandrake64 and super-smack: -------------------------------------------------------------------- SERVER CONFIG: ** Mandrake64 64-bit** SMP Mon Apr 19 10:48:13 CEST 2004 x86_64 unknown unknown GNU/Linux 2.6.3-9mdksmp MySQL: Ver 4.0.18 for mandrake-linux-gnu on x86_64 (Source distribution) [root@amd64m]# ldd /usr/sbin/mysqld librt.so.1 => /lib64/tls/librt.so.1 (0x0000002a9566d000) libdl.so.2 => /lib64/libdl.so.2 (0x0000002a95786000) libz.so.1 => /lib64/libz.so.1 (0x0000002a9588a000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000002a9599d000) libnsl.so.1 => /lib64/libnsl.so.1 (0x0000002a95ad0000) libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x0000002a95be8000) <-- eh? libstdc++.so.5 => /usr/lib64/libstdc++.so.5 (0x0000002a95cfc000) libm.so.6 => /lib64/tls/libm.so.6 (0x0000002a95eda000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000002a96033000) libc.so.6 => /lib64/tls/libc.so.6 (0x0000002a9613e000) /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2 (0x0000002a95556000) --------------------------------------------------------------------- Each benchmark ran 4 times and highest was shown. --------------------------------------------------------------------- REMOTE (Over 100mbit LAN dc0 to bge0): - Using "Stock" Mandrake64 Install, without my.cnf devbox# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=65ms min=8ms avg= 20ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 4 0 4441.59 update_index 300000 1 0 4441.59 - Using "Stock" Mandrake64 Install, with my-huge.cnf but it compiled about max_connections @ 512 and dropped them to 457... 040521 1:17:42 Warning: setrlimit couldn't increase number of open files to more than 1024 (request: 1134) 040521 1:17:42 Warning: Changed limits: max_connections: 100 table_cache: 457 devbox# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=65ms min=0ms avg= 21ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 5 0 4296.86 update_index 300000 15 0 4296.86 So the results above were the best so far. Strange that using the my-huge.cnf would produce worse results. I guess that's a question for the Mandrake list though. Anyway, the closest FreeBSD came so far was under 32-bit i386 (on AMD64 hardware) :-( - Using my-huge.cnf - Using SCHED_4BSD kernel - Using mysql compiled with linuxthreads - (see a couple posts back for complete details) devbox# super-smack update-select.smack 30 10000 Query Barrel Report for client smacker connect: max=817ms min=37ms avg= 326ms from 30 clients Query_type num_queries max_time min_time q_per_s select_index 300000 2 0 3718.13 update_index 300000 9 0 3718.13