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)
Websites Graveyard
spreadfirefox.com
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: justdave, Unassigned)
Details
Attachments
(1 file)
520 bytes,
patch
|
abuchanan
:
review+
|
Details | Diff | Splinter 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)
Comment 1•15 years ago
|
||
Attachment #430591 -
Flags: review?(buchanae) → review+
Comment 3•15 years ago
|
||
filed bug 551246 for updating production
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Assignee | ||
Updated•14 years ago
|
Product: Websites → Websites Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•