Date: Wed, 22 Jun 2005 16:31:04 -0700 From: ray@redshift.com To: David Xu <davidxu@freebsd.org> Cc: freebsd-amd64@FreeBSD.org Subject: Re: Slower MySQL inserts for AMD64/Opteron? Message-ID: <3.0.1.32.20050622163104.00a7b0c8@pop.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>
next in thread | previous in thread | raw e-mail | index | archive | help
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. | > | > | | |
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3.0.1.32.20050622163104.00a7b0c8>