Date: Thu, 23 Jun 2005 07:27:18 +0800 From: David Xu <davidxu@freebsd.org> To: ray@redshift.com Cc: freebsd-amd64@FreeBSD.org Subject: Re: Slower MySQL inserts for AMD64/Opteron? Message-ID: <42B9F3D6.3040509@freebsd.org> In-Reply-To: <3.0.1.32.20050622160137.00a87c38@pop.redshift.com> References: <3.0.1.32.20050622104159.00a55450@pop.redshift.com> <3.0.1.32.20050622160137.00a87c38@pop.redshift.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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. > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42B9F3D6.3040509>