Slower MySQL inserts for AMD64/Opteron?

[ray at redshift.com]

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 at 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.
| >  
| >
| 
| 
|