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
Product: sysadmin
Classification: Infrastructure
Component: Other
Other Linux
: Normal normal
: ---
Assigned To: GNOME Sysadmins
GNOME Sysadmins
Depends on:
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 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:

To increase perf, it is also possible to purge raw logs older than 30 days:
Comment 1 Jean-François Fortin Tam 2012-02-19 14:42:29 UTC
Comment 2 Andrea Veri 2012-02-20 09:34:32 UTC
Done. I ran 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.