Our site’s average daily traffic:
Piwik has been running well on our site, but recently we found that it was very slow to visit the analytic data. We have no idea what happened.
When we set “Allow Piwik archiving to trigger when reports are viewed from the browser” to Yes, the page of the analytics reports will keep loading, furthermore, the number of apache requests on our server will also keep increasing and the report page still won’t show.
When we set ”Allow Piwik archiving to trigger when reports are viewed from the browser” to No and enable the automatic analytics function (cron), the analytic progress will keep running for a long time (half a day, one day or even two days) but still cannot get a final result.
Remarks: The analytic script didn’t generate any error info (misc/cron/archive.sh).
As for our site with such visiting traffic and the problems we encountered, is there anything about the Piwik settings we should pay special attention to? Or can you offer us any suggestions for optimization? Can you help us figure out why the analytic progress cannot be completed successfully?