MySQL Forums
Forum List  »  Performance

Re: Bulk updates on live database
Posted by: Jack Toering
Date: May 07, 2009 06:51AM

Rick James Wrote:
-------------------------------------------------------
>...load it into a different table, then swap it in<

So the tables being swapped would be locked for a split second, and everything just works after the swap. That's the kind of answer I was hoping for, but didn't know if it would work on a live and busy DB. If I use that method, I may be better off moving the tables to MyISAM since all queries would be read, and there are no back end table relationships nor views established to leverage the strengths of InnoDB.

Thanks tons!

Options: ReplyQuote


Subject
Views
Written By
Posted
4453
May 06, 2009 04:18PM
1937
May 06, 2009 07:31PM
Re: Bulk updates on live database
2024
May 07, 2009 06:51AM
1566
May 07, 2009 09:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.