Forwarded response from Micheal. I haven't tested it yet (have to wait till
I have more data to move), but this sounds about right.
Thanks!
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Thursday, July 09, 2009 1:22 PM
To: Walton Hoops
Subject: Re: Lock
Nope, Nathan is right: INSERT...SELECT is a locking statement due to
statement-based replication. There's lots of info on this if you
google it. The common solution is to dump to disk and load back in
with SELECT INTO OUTFILE and LOAD DATA INFILE.
- Perrin
On Thu, Jul 9, 2009 at 3:55 PM,