Myqsl - piwik_option - many queries


(Mariano Fernández) #1

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