Hi Christ,

I have generating 100k records and wants to know how much time took for my
Master and a Slave to complete the process. I have attached logs one from
each of them, one is called  slon_master.log and slon_DB1.log. from what you
have told me on where should I looking at to find the start time and ending
time. But the story seems like a little bit different on master. I insert
100k records to master but master don't have log like this one "DEBUG2
remoteHelperThread_1_1: inserts=110105 updates=0 deletes=110005" 

Also, since I am inserting 100k records all at once the "DEBUG1:
remoteWorkerThread_%d: SYNC %d processing" won't wait for all 10k inserted
then generated a record. It breaking up into many smaller logs, generate
each line of log for every hundreds of transactions been done. 

could you take a look at my log and pointing out from each server log, when
did the 100k transaction started and when did it end?  or can anyone else
help me find it out.
Thanks,
http://www.nabble.com/file/p25378427/slon_master.log slon_master.log 
http://www.nabble.com/file/p25378427/slon_DB1.log slon_DB1.log 




Huang



Christopher Browne wrote:
> 
> 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>
> -- 
> 
> 

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