From owner-freebsd-amd64@FreeBSD.ORG Fri May 21 11:32:20 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 643AE16A4CE for ; Fri, 21 May 2004 11:32:20 -0700 (PDT) Received: from mail.mikehost.net (lvs-1.voxel.net [207.99.115.72]) by mx1.FreeBSD.org (Postfix) with ESMTP id 33FE843D1D for ; Fri, 21 May 2004 11:32:20 -0700 (PDT) (envelope-from mike@mike2k.com) Received: by mail.mikehost.net (Postfix, from userid 502) id D02F91BBEB; Fri, 21 May 2004 11:32:11 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by mail.mikehost.net (Postfix) with ESMTP id CEE8A1BA76 for ; Fri, 21 May 2004 11:32:11 -0700 (PDT) Date: Fri, 21 May 2004 11:32:11 -0700 (PDT) From: mike X-X-Sender: mike@sql01.internal.mikehost.net To: freebsd-amd64@freebsd.org Message-ID: mike: yes MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: Re: Why is MySQL nearly twice as fast on Linux/AMD64Vs.FreeBSD/AMD64? (fwd) 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 18:32:20 -0000 On Fri, 21 May 2004, Steven Hartland wrote: > As the benchmark is still looking network dependent 0 -> 6ms RR times > I'd try the bge tweak Andrew suggested: > > Without adding an interface, I'd just suggest doing something > like changing sc->bge_rx_max_coal_bds from 64 to 1 around like 2350 of > dev/bge/if_bge.c, rebuilding the driver, and seeing what changes. I'm > betting that will turn off recv interrupt coalescing and reduce your > latency some. > > It may be the source of your issue. > > Also compare local to local and see how that shapes up, as it will > give an indication of where any issue lies i.e. threading / process > or network. > > Steve / K this is what i'm saying. i *KNOW* that there is a problem with threading. we need to resolve mysql issues on the local box before we worry about possible network overhead or anything. check my benchmarks. i am posting the same complaints here. http://mikehost.com/~mike/tmp/bench.htm out of the box debian blows the hell out of the freebsd setup in most tests - all running through the local file socket (not over the network) and compiled the same way. there is definately a problem here with threading/etc. let's conquer one issue at a time. threading issues first. when i can run mysql here on the same machine and it sports relatively the same numbers as the linux installation, then you can start running remote benchmarks and see if there's additional issues with network overhead (either internal to mysql or network drivers or something) once again, i will provide access to my machine if anyone wants to come in and optimize it/do whatever, as well as pay someone some cash to help expedite this issue. - mike