2010-08-23 11:52:49 |
Данило Шеган |
bug |
|
|
added bug |
2010-08-23 13:03:27 |
Stuart Bishop |
launchpad-foundations: status |
New |
Invalid |
|
2010-08-23 13:10:56 |
Stuart Bishop |
launchpad-foundations: status |
Invalid |
Confirmed |
|
2010-08-23 13:11:15 |
Stuart Bishop |
launchpad-foundations: importance |
Undecided |
Medium |
|
2010-08-23 13:11:56 |
Данило Шеган |
launchpad-foundations: status |
Confirmed |
New |
|
2010-08-23 13:12:15 |
Данило Шеган |
launchpad-foundations: status |
New |
Confirmed |
|
2010-12-23 16:46:27 |
Curtis Hovey |
launchpad: status |
Confirmed |
Triaged |
|
2011-02-07 12:08:45 |
Stuart Bishop |
launchpad: status |
Triaged |
Won't Fix |
|
2011-05-06 08:19:20 |
Robert Collins |
launchpad: status |
Won't Fix |
Triaged |
|
2011-05-06 08:19:23 |
Robert Collins |
launchpad: importance |
Medium |
High |
|
2011-05-06 08:19:44 |
Robert Collins |
summary |
DBLoopTuner stalls over DB slave rebuilds |
rebuilding replicas causes all background tasks to stall |
|
2012-01-05 05:56:23 |
Robert Collins |
description |
We use DBLoopTuner for all of our data model migration scripts. However, when a single slave in a replication set is being rebuilt, entire cluster lag skyrockets and any migration job we are doing stalls for ~12h or so (the time it takes to fully rebuild a slave).
While this is bad for migration scripts, it makes DBLoopTuner unusable for regular cronscripts. I've even have a case where it makes the script underperform when using DBLoopTuner: cronscripts/rosetta-pofile-stats-daily.py takes ages to finish even though it processes a relatively small number of rows (bug 622668). |
We use DBLoopTuner for all of our data model migration scripts. However, when a single slave in a replication set is being rebuilt, entire cluster lag skyrockets and any migration job we are doing stalls for ~12h or so (the time it takes to fully rebuild a slave).
While this is bad for migration scripts, it makes DBLoopTuner unusable for regular cronscripts. I've even have a case where it makes the script underperform when using DBLoopTuner: cronscripts/rosetta-pofile-stats-daily.py takes ages to finish even though it processes a relatively small number of rows (bug 622668).
Solutions
=========
* Allow DBLoopTuner to be configured to ignore lag, for things that should well, ignore lag. |
|
2012-01-16 20:36:04 |
Robert Collins |
summary |
rebuilding replicas causes all background tasks to stall |
rebuilding replicas causes all background tasks to stall (no differentiation between latency sensitive tasks and others) |
|
2013-08-12 05:09:38 |
William Grant |
launchpad: status |
Triaged |
Fix Released |
|