Organize CKPool addresses without duplicating worker hashrate
Address totals and the workers underneath them are hierarchical views of the same work. Adding both duplicates hashrate. A payout-address change also requires separating observations before and after the transition.
What to check
Store the pool, BTC address, worker and time window for each record. Link only identifiable workers to physical devices. If the source exposes address totals only, keep that aggregate scope rather than copying it to every machine. Five-minute and one-hour rates are alternative averages, not independent work quantities to sum.
Example
Example: an address total is 100 TH/s and its two workers show 40 and 60. The total remains 100, not 200. After an address change, inspect the old record’s last-share time before including its historical average.