I have started seeing this behaviour where it takes 20-30 seconds for piwik to return the tracking request. See attached screenshot.
Here is what I have found so far:
It happens only on initial pageload if the page has not been accessed for some time.
If you wait it out (20-30 seconds) and then reload the page, the response on the second pageload is instant.
There are no slow queries
I checked the mysql slow query log, nothing is output. (I put 5 seconds as the slow query threshold).
Has anyone seen something like this? How do you fix it??
I have checked the logs that I collect from Piwik CRON and it has been running at 15 * * * * schedule correctly for months.
Can the CRON somehow lock the data tables? Because it does take 60-120 seconds to run the job each hour.
Also, is there any way I can explicitly disable jobs from running during a tracking request? Like a config flag?
If you disable in the “Settings > general settings” and set Browser trigger archiving to FALSE then the Tracking API piwik.php requests will not trigger the scheduled tasks. Maybe this will help?
“Allow Piwik archiving to trigger when reports are viewed from the browser” was already set to “No” under Settings > General.
I tried changing "Reports for today (or any other Date Range including today) will be processed at most every "
from 10 to 1800 seconds. Could that help with this issue?
I deactivated the Provider plugin as you suggested. I think the feature is not very useful (what can you do with provider data anyway?) and absolutely not worth incurring a DNS request for every visitor, so thanks for the suggestion!