I still hat die archive.php-CronJob running. Changed to the “new” way of doing the cron - the Shell-Script.
I do also follow this FAQ How to - Analytics Platform - Matomo to remove ALL my old data (year per year) and reprocess ist.
Tested it on an month where I knew it hat “0 visits-Weeks” in one month, and they where re-calculated correctly.
So it will take some hours to re-calculate all the Data since 2009 (DB-Size is round about 3.5 GB). I will write again if it helped out or if it doesn’t.
Thanks for the “new” FAQs and the “new” CronJob (didn’t mind to get noticed about an new way to do the cronjobs).
Update:
Hey Folks,
something really strange: Archiving an small page, from 2010 till now, with just 2916 Visits with 10085 Actions the archiving took 1045 seconds. Its an netcup VPS with 4 GB and one Core CPU. Is it OK to be so slow? Can I tune up some parameters to get faster?
Or is it even fast?
The archiving of the 37 Websites will took a long time, because this page is the smalest one. The archiving-process will re-process pages for two or three years of data with 30.000 Visits per month…
Update 2:
To be more precise:
INFO CoreConsole[2014-07-08 18:46:07] [6b85d] Archived website id = 1, period = day, 2916 visits in last last10000 days, 0 visits today, Time elapsed: 357.521s
INFO CoreConsole[2014-07-08 18:52:35] [6b85d] Archived website id = 1, period = week, 2916 visits in last last10000 weeks, 0 visits this week, Time elapsed: 388.064s
INFO CoreConsole[2014-07-08 18:57:25] [6b85d] Archived website id = 1, period = month, 2916 visits in last last10000 months, 0 visits this month, Time elapsed: 289.688s
INFO CoreConsole[2014-07-08 18:57:36] [6b85d] Archived website id = 1, period = year, 2916 visits in last last10000 years, 0 visits this year, Time elapsed: 10.336s
INFO CoreConsole[2014-07-08 18:57:36] [6b85d] Archived website id = 1, 4 API requests, Time elapsed: 1045.657s [1/37 done]
INFO CoreConsole[2014-07-08 19:11:22] [6b85d] Archived website id = 2, period = day, 43564 visits in last last10000 days, 22 visits today, Time elapsed: 826.186s
INFO CoreConsole[2014-07-08 19:31:22] [6b85d] Archived website id = 2, period = week, 43568 visits in last last10000 weeks, 53 visits this week, Time elapsed: 1199.866s