From owner-freebsd-threads@FreeBSD.ORG Fri May 21 15:55:44 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4FA5216A4CE for ; Fri, 21 May 2004 15:55:44 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1CA6E43D2D for ; Fri, 21 May 2004 15:55:42 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 69501 invoked by uid 89); 21 May 2004 22:59:59 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 21 May 2004 22:59:59 -0000 Message-Id: <5.2.0.9.2.20040521154458.01627688@127.0.0.1> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Fri, 21 May 2004 15:55:42 -0700 To: freebsd-threads@freebsd.org From: JG Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 21 May 2004 22:55:44 -0000 We have a rather long discussion brewing over at the freebsd-amd64 mailing list: Subj: Why is MySQL nearly twice as fast on Linux/AMD64 Vs. FreeBSD/AMD64? @ http://lists.freebsd.org/pipermail/freebsd-amd64/2004-May/thread.html Chris Elsworth also just posted a similar message on the MySQL general users list: http://lists.mysql.com/mysql/165908 He is on i386 architecture, so this problem seems to be universal for FreeBSD. I have been benchmarking many different configurations for several days now, and MySQL under Linux consistently SIGNIFICANTLY outperforms FreeBSD on the same hardware. Most of the time handling twice as many queries or more. After reading the posts at the mailing lists mentioned above, Do you have any suggestions or ideas as to what the problem is? Thanks - Jeremy