Anyone ? I just want to know how to read the log of the insert time start and
finish on Master. 
For each process, It contain different logs on master then on slaves. 
I read the docunment the chapter that all talks about logs and I do found
also what Christopher said on how to find starting and ending time on slave,
but that doesn't applied on master. Message logs in Master and in slave are
some how different.

Appreciate for any guidence.

Huang


roctaiwan wrote:
> 
> 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
> 
> 

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