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