From owner-freebsd-amd64@FreeBSD.ORG Wed Jun 22 23:30:53 2005 Return-Path: X-Original-To: freebsd-amd64@FreeBSD.org 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 E92D316A41C; Wed, 22 Jun 2005 23:30:53 +0000 (GMT) (envelope-from ray@redshift.com) Received: from outgoing.redshift.com (outgoing.redshift.com [207.177.231.8]) by mx1.FreeBSD.org (Postfix) with ESMTP id D378843D49; Wed, 22 Jun 2005 23:30:53 +0000 (GMT) (envelope-from ray@redshift.com) Received: from workstation (216-228-19-21.dsl.redshift.com [216.228.19.21]) by outgoing.redshift.com (Postfix) with SMTP id 1F9B397098; Wed, 22 Jun 2005 16:30:52 -0700 (PDT) Message-Id: <3.0.1.32.20050622163104.00a7b0c8@pop.redshift.com> X-Mailer: na X-Sender: redshift.com Date: Wed, 22 Jun 2005 16:31:04 -0700 To: David Xu From: ray@redshift.com In-Reply-To: <42B9F3D6.3040509@freebsd.org> References: <3.0.1.32.20050622160137.00a87c38@pop.redshift.com> <3.0.1.32.20050622104159.00a55450@pop.redshift.com> <3.0.1.32.20050622160137.00a87c38@pop.redshift.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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:30:54 -0000 Hi David, Sorry, I forgot to mention my benchmarks were done using InnoDB tables and I configured MySQL on both machines to use InnoDB. BTW, I did not compile in Linux threads on either machine and I don't believe they are there by default. I can send my little benchmark program to anyone that would like to test it on their config. It just has 1 table and a couple of PHP scripts that do inserts, updates, etc. I did compile in APC on my machines, but I don't think that's the bottle neck here, so I doubt if it would impact the results either way. Thanks! Ray At 07:27 AM 6/23/2005 +0800, David Xu wrote: | 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. | > | > | | |