I had a load problem on my webstats machine and I found the problem to be that the archiving script was running several times simultaneously out of cron. I killed all of them, shut it off in cron and ran ‘su www-data -c “/usr/bin/php5 /var/www/piwik/misc/cron/archive.php – url=http://webstats.gwtc.net/”’ manually. It ran overnight and only had the following this morning
[2012-11-13 23:32:31] [62e58b3b] ---------------------------
[2012-11-13 23:32:31] [62e58b3b] INIT
[2012-11-13 23:32:31] [62e58b3b] Querying Piwik API at: Sign in
[2012-11-13 23:32:31] [62e58b3b] Running as Super User: admin
[2012-11-13 23:32:31] [62e58b3b] Notes
[2012-11-13 23:32:31] [62e58b3b] - Reports for today will be processed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-11-13 23:32:31] [62e58b3b] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-11-13 23:32:31] [62e58b3b] --force-all-periods was detected: we will process websites with visits in the last 7 days 0 hours
[2012-11-13 23:32:31] [62e58b3b] Will process 45 websites with new visits since 7 days 0 hours , IDs: 8, 9, 10, 11, 79, 80, 82, 83, 112, 113, 114, 115, 117, 118, 119, 120, 121, 122, 124, 126, 127, 129, 130, 132, 133, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 147,148, 149, 151, 152, 153, 154, 155, 156, 157
[2012-11-13 23:32:31] [62e58b3b] Will process 12 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 4, 6, 7, 81, 116, 125, 128, 131, 134, 138, 146, 150
[2012-11-13 23:32:31] [62e58b3b] ---------------------------
[2012-11-13 23:32:31] [62e58b3b] START
[2012-11-13 23:32:31] [62e58b3b] Starting Piwik reports archiving…
Is it supposed to output more information? None of the websites are showing historical information after November 5.