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.

Thanks!

Options: ReplyQuote


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