Is it possible to archive too often/too many times? I’m running the archiving with console every 15 minutes. I got 130k actions daily on 10 sites.
I just run this command : > egrep “Done|Start” piwik-console-cron217-1.log
And see few weird things like 3 “Done” in a row without any start:
INFO [2017-02-23 09:45:01] Starting Piwik reports archiving...
INFO [2017-02-23 09:49:30] Done archiving!
INFO [2017-02-23 10:00:01] Starting Piwik reports archiving...
INFO [2017-02-23 10:04:37] Done archiving!
INFO [2017-02-23 10:15:01] Starting Piwik reports archiving...
INFO [2017-02-23 10:19:30] Done archiving!
INFO [2017-02-23 10:30:02] Starting Piwik reports archiving...
INFO [2017-02-23 11:27:36] Starting Piwik reports archiving...
INFO [2017-02-23 11:27:36] Starting Piwik reports archiving...
INFO [2017-02-23 11:27:36] Starting Piwik reports archiving...
INFO [2017-02-23 11:28:49] Done archiving!
INFO [2017-02-23 11:28:58] Done archiving!
INFO [2017-02-23 11:29:24] Done archiving!
INFO [2017-02-23 11:30:01] Starting Piwik reports archiving...
INFO [2017-02-23 11:30:21] Done archiving!
INFO [2017-02-23 11:31:19] Done archiving!
INFO [2017-02-23 11:45:02] Starting Piwik reports archiving...
INFO [2017-02-23 11:49:45] Done archiving!
INFO [2017-02-23 12:00:02] Starting Piwik reports archiving...
INFO [2017-02-23 12:05:18] Done archiving!
Should I limit archiving to every 30 minutes or every hour at max? Maybe it’s the cause of a bigger problem I got : Blob table 4x bigger before doing purge-old-archive-data · Issue #11322 · matomo-org/piwik · GitHub
Any suggestions ?