<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><font style="font-family:Courier New, courier, monaco, monospace, sans-serif;" size="2"><font>Hi <br><br>Nothing
of that; but we had one of the slave down for last 8 days and still in
subscribe list. Do you think that has an effect on the other nodes ? <br><br>st_origin
| st_received | st_last_event | st_last_event_ts |
st_last_received | st_last_received_ts |
st_last_received_event_ts | st_lag_num_events | st_lag_time <br>-----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+------------------------<br>
45 | 60 | <span class="yshortcuts" id="lw_1329969164_0">5001958753</span> | 2012-02-22 21:32:02.555943 | <span class="yshortcuts" id="lw_1329969164_1">5001566396</span> | 2012-02-13 19:09:04.346031 | 2012-02-13 12:28:53.968515 | 392357 | 9 days 09:03:09.219735<br> 45 | 67 | 5001958753 | 2012-02-22 21:32:02.555943 | <span class="yshortcuts" id="lw_1329969164_2">5001949595</span> | 2012-02-22 20:47:55.672691 | 2012-02-22 16:18:10.759348 | 9158 | 05:13:52.428902<br> 45
| 66 | 5001958753 | 2012-02-22 21:32:02.555943 | <span class="yshortcuts" id="lw_1329969164_3">5001930109</span> | 2012-02-22
20:46:02.378948 | 2012-02-22 04:19:30.589199 | 28644 | 17:12:32.599051<br><b><br><br></b></font></font><div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Vick Khera <vivek@khera.org><br> <b><span style="font-weight: bold;">To:</span></b> "slony1-general@lists.slony.info" <slony1-general@lists.slony.info> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, February 22, 2012 4:28 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Slony1-general] Replication Lag - fetch 500 from LOG<br> </font> </div> <br>
On Tue, Feb 21, 2012 at 10:30 PM, Brian Trudal <<a ymailto="mailto:dbrb2002-sql@yahoo.com" href="mailto:dbrb2002-sql@yahoo.com">dbrb2002-sql@yahoo.com</a>> wrote:<br>> Anything that am missing ?<br><br>Has your query (mostly write) load changed? Did one of your disks in<br>your array die? You should poke around to see if you're saturating<br>either your network or one of the servers' disk I/O bandwidth.<br>_______________________________________________<br>Slony1-general mailing list<br><a ymailto="mailto:Slony1-general@lists.slony.info" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>http://lists.slony.info/mailman/listinfo/slony1-general<br><br><br> </div> </div> </div></body></html>