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"