Archive.php-Cron: What DB-Table changes?

Support & Bugs
1

Heyho!

I’m trying to split the tracking (piwik.php) and archiving/reporting (archive.php + UI) on different servers because of performance issues. Therefore I’m running mysqldump with all Piwik tables on my tracking server and import the dumpfile on archiving/reporting server. But the dumpfile is getting bigger and bigger.

Which db tables can I exclude from mysqldump without losing any data? Can I limit the rows of “piwik_log_…” for a timerange (last x days)?

Is misc/cron/archive.php changing any tables but “piwik_archive_…”?

Cheers
Malte

2

archive.php will insert new records in archive_ tables only (not change visits/actions/etc), it will read many tables

3

also will insert records in piwik_option table etc.

4

Is the PiwikTracker only using INSERT into log_* table or also UPDATE?

5

it does not insert in log_

6

So so where and how is piwik.php writing all the tracking data?

7

You are confused. piwik.php does not write any archive data (archive.php does)