Created attachment 430591 [details] [diff] [review] Patch The affiliates processing code that deals with the new_points_tally table takes sufficiently long enough to run that it takes the database slaves several hours to replicate it. I tracked this down to a lack of indexes on the new_points_tally temporary table. When I added an index to this table in the database earlier tonight, it completely caught up within minutes instead of continuing to lag for several more hours. Unfortunately, as this is a temporary table, this problem will repeat itself every time the processing code runs, since the index I added will go away when it resets the table. The attached patch causes the index to get added when the table is recreated.
Attachment #430591 - Flags: review?(buchanae)
Comment on attachment 430591 [details] [diff] [review] Patch r63771
Attachment #430591 - Flags: review?(buchanae) → review+
r63772 on production. Justdave, want to svn up this one?
filed bug 551246 for updating production
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Product: Websites → Websites Graveyard
You need to log in before you can comment on or make changes to this bug.