roctaiwan <[email protected]> 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
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
