2.0.4 beta 4


#1

This versione runs better the 2.0.3, but an issue I see is that - even with 82800 seconds as the “Reports for today (or any other Date Range including today) will be processed at most every” - the widgets in the dashboard take a lot of time before they are presented. The delay is more than 30 seconds on a site which has 70 visits/day!


(Matthieu Aubry) #2

That should definitely not happen. For 70 visits the widgets should all load in less than 1-2 seconds. There must be some problem… Do you have other info?


#3

Here is the beginning and the end of this night archive log, exited with no error:


INFO [2014-02-03 23:07:01] [4a8ea] ---------------------------
INFO [2014-02-03 23:07:01] [4a8ea] INIT
INFO [2014-02-03 23:07:01] [4a8ea] Querying Piwik API at: http://myserver/piwik/index.php
INFO [2014-02-03 23:07:01] [4a8ea] Running Piwik 2.0.4-b4 as Super User: paolo
INFO [2014-02-03 23:07:01] [4a8ea] ---------------------------
INFO [2014-02-03 23:07:01] [4a8ea] NOTES
INFO [2014-02-03 23:07:01] [4a8ea] - Reports for today will be processed at most every 82800 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO [2014-02-03 23:07:01] [4a8ea] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO [2014-02-03 23:07:01] [4a8ea] - Archiving was last executed without error 23 ore 56 minuti ago
INFO [2014-02-03 23:07:05] [4a8ea] - Will process 10 websites with new visits since 23 ore 56 minuti , IDs: 1, 2, 3, 4, 5, 6, 9, 10, 11, 13
INFO [2014-02-03 23:07:05] [4a8ea] - Will process 4 other websites because the last time they were archived was on a different day (in the website's timezone) , IDs: 7, 8, 12, 14
INFO [2014-02-03 23:07:05] [4a8ea] ---------------------------
INFO [2014-02-03 23:07:05] [4a8ea] START
INFO [2014-02-03 23:07:10] [4a8ea] Archived website id = 1, period = day, Time elapsed: 5.161s
INFO [2014-02-03 23:07:14] [4a8ea] Archived website id = 1, period = week, 21496 visits, Time elapsed: 4.245s
INFO [2014-02-03 23:07:19] [4a8ea] Archived website id = 1, period = month, 71159 visits, Time elapsed: 4.730s
INFO [2014-02-03 23:07:25] [4a8ea] Archived website id = 1, period = year, 1056739 visits, Time elapsed: 6.419s
INFO [2014-02-03 23:07:25] [4a8ea] Archived website id = 1, today = 3031 visits, 4 API requests, Time elapsed: 20.556s [1/14 done]
INFO [2014-02-03 23:07:28] [4a8ea] Archived website id = 2, period = day, Time elapsed: 2.068s
INFO [2014-02-03 23:07:29] [4a8ea] Archived website id = 2, period = week, 347 visits, Time elapsed: 1.922s
INFO [2014-02-03 23:07:32] [4a8ea] Archived website id = 2, period = month, 1344 visits, Time elapsed: 2.239s
INFO [2014-02-03 23:07:36] [4a8ea] Archived website id = 2, period = year, 20925 visits, Time elapsed: 4.106s
INFO [2014-02-03 23:07:36] [4a8ea] Archived website id = 2, today = 37 visits, 4 API requests, Time elapsed: 10.337s [2/14 done]
....
INFO [2014-02-03 23:09:59] [4a8ea] Starting Piwik reports archiving...
INFO [2014-02-03 23:09:59] [4a8ea] Done archiving!
INFO [2014-02-03 23:09:59] [4a8ea] ---------------------------
INFO [2014-02-03 23:09:59] [4a8ea] SUMMARY
INFO [2014-02-03 23:09:59] [4a8ea] Total daily visits archived: 26192
INFO [2014-02-03 23:09:59] [4a8ea] Archived today's reports for 14 websites
INFO [2014-02-03 23:09:59] [4a8ea] Archived week/month/year for 14 websites
INFO [2014-02-03 23:09:59] [4a8ea] Skipped 0 websites: no new visit since the last script execution
INFO [2014-02-03 23:09:59] [4a8ea] Skipped 0 websites day archiving: existing daily reports are less than 82800 seconds old
INFO [2014-02-03 23:09:59] [4a8ea] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
INFO [2014-02-03 23:09:59] [4a8ea] Total API requests: 56
INFO [2014-02-03 23:09:59] [4a8ea] done: 14/14 100%, 26192 v, 14 wtoday, 14 wperiods, 56 req, 173757 ms, no error
INFO [2014-02-03 23:09:59] [4a8ea] Time elapsed: 173.757s
INFO [2014-02-03 23:09:59] [4a8ea] ---------------------------
INFO [2014-02-03 23:09:59] [4a8ea] SCHEDULED TASKS
INFO [2014-02-03 23:09:59] [4a8ea] Starting Scheduled tasks... 
INFO [2014-02-03 23:18:03] [4a8ea] task,output
CoreAdminHome.purgeOutdatedArchives,Time elapsed: 1.617s
PrivacyManager.deleteReportData,Time elapsed: 0.003s
PrivacyManager.deleteLogData,Time elapsed: 0.000s
Piwik\Plugins\CorePluginsAdmin\MarketplaceApiClient.clearAllCacheEntries,Time elapsed: 0.001s
CoreAdminHome.optimizeArchiveTable,Time elapsed: 5.388s
DBStats.cacheDataByArchiveNameReports,Time elapsed: 477.472s
INFO [2014-02-03 23:18:03] [4a8ea] done
INFO [2014-02-03 23:18:03] [4a8ea] ---------------------------

Is it correct that when period = day there is no visit number reported?

It seems that a site’s dashboard doesnt’ take a long time if it has been loaded yesterday. The most visited site, which I check every day, takes 2 seconds