We are using PHP 5.6.27 and Apache 2.4.x running under Solaris 11.3. Before upgrading the machine ran without any issues under Piwik 2.16.2. Even the hourly cronjob for archiving did not result in any problems. After upgrading the load increased in maximum up to 240 which resulted in semi-responsive machine. The website traffic did not change.
Here are two excerpts from the archiver’s logs:
Version 2.16.2:
SUMMARY
Total visits for today across archived websites: 37323
Archived today’s reports for 8 websites
Archived week/month/year for 8 websites
Skipped 0 websites
- 0 skipped because no new visit since the last script execution
- 0 skipped because existing daily reports are less than 3600 seconds old
- 0 skipped because existing week/month/year periods reports are less than 3600 seconds old
Total API requests: 32
done: 8/8 100%, 37323 vtoday, 8 wtoday, 8 wperiods, 32 req, 251212 ms, no error
Time elapsed: 251.213s
And here’s the new 2.17.1:
SUMMARY
Total visits for today across archived websites: 10989
Archived today’s reports for 8 websites
Archived week/month/year for 8 websites
Skipped 0 websites
- 0 skipped because no new visit since the last script execution
- 0 skipped because existing daily reports are less than 3600 seconds old
- 0 skipped because existing week/month/year periods reports are less than 3600 seconds old
Total API requests: 32
done: 8/8 100%, 10989 vtoday, 8 wtoday, 8 wperiods, 32 req, 891597 ms, no error
Time elapsed: 891.598s
When taking a deeper look inside the logs we can see that the time for the daily stats does not really change, but the annual stats has a massive increase. I.E.:
OLD:
Archived website id = 6, period = year, 0 segments, 1021430 visits in last 2 years, 535738 visits this year, Time elapsed: 13.301s
Archived website id = 6, 4 API requests, Time elapsed: 26.024s [6/8 done]
New:
Archived website id = 6, period = year, 0 segments, 1029363 visits in last 2 years, 543671 visits this year, Time elapsed: 143.110s
Archived website id = 6, 4 API requests, Time elapsed: 161.837s [6/8 done]
Please note that there is only a time span of ~1 week between both logs.
Is there anybody out there with a similar problem? Any help will be appreciated.