I’m using Piwik 2.7 and I’m checking MySQL’s log and found that piwik read piwik_option table many times:
I copied some values from my small log file:
Count_selects table
764 piwik_log_conversion
764 piwik_log_link_visit_action
764 piwik_log_visit
32450 piwik_option
SELECT option_value FROM piwik_option
WHERE option_name =
456 lastTrackerCronRun
3194 PrivacyManager.doNotTrackEnabled
3195 PrivacyManager.ipAddressMaskLength
3193 PrivacyManager.ipAnonymizerEnabled
3195 PrivacyManager.useAnonymizedIpForVisitEnrichment
2222 SitesManager_EnableSiteSpecificUserAgentExclude
2219 SitesManager_ExcludedIpsGlobal
2221 SitesManager_ExcludedQueryParameters
2221 SitesManager_ExcludedUserAgentsGlobal
2223 SitesManager_KeepURLFragmentsGlobal
2225 SitesManager_SearchCategoryParameters
2224 SitesManager_SearchKeywordParameters
6 TestingIfDatabaseConnectionWorked
3195 usercountry.location_provider
is it possible that piwik_option table can save in cache?
Regards
Mariano