I found that to find the ending time on Master is the hardest... 
Anyone can tell me how? here is another 100k data insert I generated on
master.
http://www.nabble.com/file/p25380890/slon_master.log slon_master.log 

It got bunch of "SYNC" in the log. but which one is starting and which one
is the last piece of data that insert into it?

2009-09-10 18:06:22 CST DEBUG2 localListenThread: Received event 1,645 SYNC
2009-09-10 18:06:22 CST DEBUG2 remoteListenThread_2: queue event 2,204 SYNC
2009-09-10 18:06:22 CST DEBUG2 remoteListenThread_2: UNLISTEN
2009-09-10 18:06:22 CST DEBUG2 remoteWorkerThread_2: Received event 2,204
SYNC
2009-09-10 18:06:22 CST DEBUG2 calc sync size - last time: 1 last length:
10007 ideal: 5 proposed size: 3
2009-09-10 18:06:22 CST DEBUG2 remoteWorkerThread_2: SYNC 204 processing
2009-09-10 18:06:22 CST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event



Huang


Christopher Browne wrote:
> 
> roctaiwan <nettreeinc at gmail.com> writes:
>> I have pay attention on the remotehelperthread log and I have this
>> "2009-09-08 18:13:25 CST DEBUG2 remoteHelperThread_1_1: inserts=110105
>> updates=0 deletes=110005"
>>
>> what does it mean insert=110105? does that tells me number of records got
>> insert and deletes, in this case 110105-110005=100 which says there
>> should
>> have 100 records in my table? (this is correct. I do only have 100
>> records
>> in that table)
> 
> Yes, this indicates that in the present SYNC, 110105 tuples were
> inserted, and 110005 tuples were deleted.  (There isn't any breakdown on
> a per-table basis.)
> 
>> The time up there, is that the exact time for this slaves end SYNC all
>> records? 
> 
> The timestamp indicates when this was logged, and that normally takes
> place just a moment before processing of the SYNC was completed.
> 
>> if I want to find out when did it started where should I pay attention
>> to?
> 
> Look for:
>      "DEBUG1: remoteWorkerThread_%d: SYNC %d processing"
> 
> With 220K updates involved in this SYNC, I expect that the start time is
> quite a while before the end time.
> 
> There is more documentation on reading the logs here:
>    <http://main.slony.info/documentation/loganalysis.html>
> -- 
> let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@"
> [name;tld];;
> Christopher Browne
> "Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
> phasers on the Heffalump, Piglet, meet me in transporter room three"
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

-- 
View this message in context: http://www.nabble.com/where-to-find-data-transaction-log--tp25272928p25380890.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.