Re: Why would it make such a difference to move mysqld to anothermachine?

2008-07-07 Thread John Almberg
Yes, that could be the case if the database was transferred by doing mysqldump on the first machine and then loading the dump on the second. This is indeed what I did. Odd that you ask this question, because my very first guess about this issue was that the database was corrupted in some wa

Re: Why would it make such a difference to move mysqld to anothermachine?

2008-07-07 Thread Matthew Seaman
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Bob McConnell wrote: | On Behalf Of Mel | On Sunday 06 July 2008 10:58:54 Matthew Seaman wrote: | |>> I suspect that you could have achieved a pretty good speed-up simply | by |>> adding another hard drive to your server and moving all of the |

RE: Why would it make such a difference to move mysqld to anothermachine?

2008-07-07 Thread Bob McConnell
On Behalf Of Mel On Sunday 06 July 2008 10:58:54 Matthew Seaman wrote: >> I suspect that you could have achieved a pretty good speed-up simply by >> adding another hard drive to your server and moving all of the database >> onto it, separate from the web root and any other areas which apache >> wo