From owner-freebsd-amd64@FreeBSD.ORG Wed Jun 22 23:27:19 2005 Return-Path: X-Original-To: freebsd-amd64@FreeBSD.org Delivered-To: freebsd-amd64@FreeBSD.org Received: from [127.0.0.1] (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 828D516A41C; Wed, 22 Jun 2005 23:27:18 +0000 (GMT) (envelope-from davidxu@freebsd.org) Message-ID: <42B9F3D6.3040509@freebsd.org> Date: Thu, 23 Jun 2005 07:27:18 +0800 From: David Xu User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.7.8) Gecko/20050605 X-Accept-Language: en-us, en MIME-Version: 1.0 To: ray@redshift.com References: <3.0.1.32.20050622104159.00a55450@pop.redshift.com> <3.0.1.32.20050622160137.00a87c38@pop.redshift.com> In-Reply-To: <3.0.1.32.20050622160137.00a87c38@pop.redshift.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-amd64@FreeBSD.org Subject: Re: Slower MySQL inserts for AMD64/Opteron? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Jun 2005 23:27:19 -0000 MySQL's default table type MYISAM is not designed for concurrent insertion from multiple threads, can you test it against InnoDB type ? David Xu ray@redshift.com wrote: >I think it's just a little odd that the AMD would be twice as fast with selects >yet 20% slower on inserts. As far as variables, both machines are running >pretty much the same config. I'm going to install i386 on the AMD and re-run >the tests to see if the problem has to do with something in i386 vs. AMD64. > >