On Mar 5, 2009, at 11:41 AM, Stuart Bishop wrote:

> On Thu, Mar 5, 2009 at 10:59 AM, Jeff <threshar at torgo.978.org> wrote:
>
>> Now, (before you all start saying "bah, buy more disks") things are  
>> fine
>> under low load or smaller crunches, its just when we fire up a  
>> massive job
>> this happens.  We've got some more hardware coming in, but it will  
>> only
>> lessen the problem, not cure it.
>
> If your crunching allows you do do so, you might want to poll the
> current replication lag occasionally and pause the process if you are
> lagged above some threshold of your choosing.

Now that is an interesting idea. I'd probably put it in as a stop-gap  
measure though.
If a crunch is already taking a while, this will just extend that, but  
on the upside, it won't mess up others things as much.


--
Jeff Trout <jeff at jefftrout.com>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/