MySQL Forums :: Performance :: Bulk updates on live database


Advanced Search

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 3597 Jack Toering 05/06/2009 04:18PM
Re: Bulk updates on live database 1796 Rick James 05/06/2009 07:31PM
Re: Bulk updates on live database 1805 Jack Toering 05/07/2009 06:51AM
Re: Bulk updates on live database 1348 Rick James 05/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.