From owner-freebsd-current@FreeBSD.ORG Wed Oct 26 09:14:36 2005 Return-Path: X-Original-To: current@freebsd.org 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 DB59F16A41F for ; Wed, 26 Oct 2005 09:14:36 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from crivens.unixoid.de (crivens.unixoid.de [81.169.171.191]) by mx1.FreeBSD.org (Postfix) with ESMTP id E5FEE43D7D for ; Wed, 26 Oct 2005 09:14:16 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from localhost (localhost [127.0.0.1]) by crivens.unixoid.de (Postfix) with ESMTP id 7BE973F28 for ; Wed, 26 Oct 2005 11:14:15 +0200 (CEST) Received: from crivens.unixoid.de ([127.0.0.1]) by localhost (crivens.unixoid.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21067-14 for ; Wed, 26 Oct 2005 11:14:02 +0200 (CEST) Received: from [192.168.100.10] (p54BDD77B.dip.t-dialin.net [84.189.215.123]) by crivens.unixoid.de (Postfix) with ESMTP id 6147A3F26 for ; Wed, 26 Oct 2005 11:14:02 +0200 (CEST) Message-ID: <435F48DA.6060009@kernel32.de> Date: Wed, 26 Oct 2005 11:14:02 +0200 From: Marian Hettwer User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: current@freebsd.org Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at unixoid.de Cc: Subject: MySQL Performance 6.0rc1 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 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: Wed, 26 Oct 2005 09:14:37 -0000 Hi Folks, I'm using RC1 on some of my test servers and workstations. So far, it runs very good (as in stable and fast) :) However, I thought of doing a small benchmark of MySQL in comparison to Linux 2.6.8 (Debian Sarge) and the results are kinda... shocking. On FreeBSD I took a pretty much generic kernel, I just removed debugging options, added SMP and changed the scheduler from BSD to ULE. I used super-smack to do a select-key test. MySQL 4.1 was build from ports with BUILD_OPTIMIZED and BUILD_STATIC super-smack gave me these numbers: Query Barrel Report for client smacker1 connect: max=15ms min=1ms avg= 12ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 2 0 3673.36 My Kernel Config: http://unixoid.de/rabauke/freebsd/EDGECRUSHER My dmesg: http://unixoid.de/rabauke/freebsd/dmesg.freebsd6rc1 Since I have an identical second disk in my Dual Xeon BOX, I installed a Debian Sarge with Linux SMP Kernel 2.6.8, installed mysql-server41 (which is 4.1.11) and did the same super-smack test. Results: Query Barrel Report for client smacker1 connect: max=35ms min=0ms avg= 9ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 200000 0 0 14736.23 Whut? 14700 queries/second compared to only 3600 q/s on FreeBSD? I do know, that rc1 is not about performance, this will be -RELEASE then. I do know too, that it was just a quick shot and probably I should compile my own version of the MySQL server from sources on FreeBSD and Debian to have the very same mysql version. However, I can't imagine that I would gain 4 to 5 times the performance on FreeBSD just by compiling mysql myself... Any Ideas where this huge difference comes from? Did I oversee some debugging features still active in RC1 ? Best regards and keep up the good work on 6.x! - Marian