MySQL Forums
Forum List  »  Performance

Bulk updates on live database
Posted by: Jack Toering
Date: May 06, 2009 04:18PM

Things are pretty well optimized and happy with the performance of the servers. However, periodically during the hour we do bulk updates that updates the entire contents of a couple tables. InnoDB is handling it as well as can be expected and there are no FK dependencies setup in the DB. The updates are fed in, in PK order. As you would expect, during the several seconds the update occurs, Apache processes go up, and network traffic slows down until the update is complete.

I'm looking for clever ideas on how to eliminate or greatly minimize the impact of the updates.


Options: ReplyQuote

Written By
Bulk updates on live database
May 06, 2009 04:18PM
May 06, 2009 07:31PM
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.