After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 640546 - Use cron jobs to automatically process Piwik stats
Use cron jobs to automatically process Piwik stats
Status: RESOLVED FIXED
Product: sysadmin
Classification: Infrastructure
Component: Other
unspecified
Other Linux
: Normal normal
: ---
Assigned To: GNOME Sysadmins
GNOME Sysadmins
Depends on:
Blocks:
 
 
Reported: 2011-01-25 14:46 UTC by Jean-François Fortin Tam
Modified: 2012-02-20 09:34 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Jean-François Fortin Tam 2011-01-25 14:46:59 UTC 
webstats.gnome.org is *dogslow* when accessing stats the first time. For such a big website, on-demand number crunching should be disabled and replaced by a cron job (this is the official method). See:

http://piwik.org/docs/setup-auto-archiving/
http://piwik.org/faq/general/#faq_38

To increase perf, it is also possible to purge raw logs older than 30 days:
http://piwik.org/faq/troubleshooting/#faq_42
Comment 1 Jean-François Fortin Tam 2012-02-19 14:42:29 UTC 
Bump?
Comment 2 Andrea Veri 2012-02-20 09:34:32 UTC 
Done. I ran archive.sh manually for the very first run (it took some hours) and then setup a cronjob for doing the archiving every hour.

Let me know if you need anything else.