Closed Bug 550451 Opened 15 years ago Closed 15 years ago

database slaves can't keep up with affiliates processing, lack of index on temporary table

Categories

(Websites Graveyard :: spreadfirefox.com, defect)

defect
Not set
critical

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: justdave, Unassigned)

Details

Attachments

(1 file)

Attached patch PatchSplinter Review
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)
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
Closed: 15 years ago
Resolution: --- → FIXED
Product: Websites → Websites Graveyard
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: