Large piwik_options table


#1

Hi!

My piwik_options table is very large, and grows really fast, piwik gets unresponsive, this is since lst move of piwik onto a new hosting provider.
Is this normal? I see a warning in the system Status regarding “LOAD DATA INFILE”. Is that the problem?

In phpmyadmin I see a lot entries like this

dbstats_cached_piwik_archive_blob_2010_01_byArchiv… a:49:{i:0;a:3:{i:0;a:4:{s:5:“label”;s:15:"Actions
this entry is 6211 times in this table, and so on …

Regards

Marco


#2

Anyone an idea? :wink:


#3

Again: this table grows every day and it seems to be the same data that is inserted again and again. I need a solution.


(Matthieu Aubry) #4

Please go to Administration > DB Stats
you can see there advanced statistics about your datatable tables


#5

And then …


#6

I have a lot of other Piwik installations running, but there the piwik_option table is about 1 MB, here it grows and grows. every day about 150 MB


#7

A lot of cached_piwik_archive_blob filling up this table, but cached means they should get deleted, or am I wrong?


(Matthieu Aubry) #8

I don’t know what you’re referring to, can you show a screenshot or more information?


#9

Hi!

I listed below just 3 rows for dbstats_cached_piwik_archive_blob_2010_01_byArchiveName, there are a lot more in the DB (at this Moment 216, and for each month since using piwik)
Additionally I can’t activate automatic deletion of old stats, the admininterface tells me that saving was successful, but the options are again disabled, an I can’t hit the delte now button.

Regards

Marco


dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}	0
dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}	0
dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}


#10

Hi!


dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}	0
dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}	0
dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}
... to be continued

At this Moment there are 216 Entries just for dbstats_cached_piwik_archive_blob_2010_01_byArchiveName and dbstats_cached_piwik_archive_blob_2010_02_byArchiveName and so on, and so on, …

Regards

Marco


#11

Hi!

Piwik adds a lot of this entries into piwik_options:


dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}	0
dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}	0
dbstats_cached_piwik_archive_blob_2010_01_byArchiveName 	a:49:{i:0;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_actions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"11523";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:1;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_actions_*";s:9:"row_count";i:11;s:9:"blob_size";i:2129;s:9:"name_size";i:199;}i:1;a:0:{}i:3;N;}i:12;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_actions_url";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"28357";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:13;a:3:{i:0;a:4:{s:5:"label";s:21:"Actions_actions_url_*";s:9:"row_count";i:15;s:9:"blob_size";i:11546;s:9:"name_size";i:345;}i:1;a:0:{}i:3;N;}i:28;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_downloads";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"225";s:9:"name_size";s:2:"17";}i:1;a:0:{}i:3;N;}i:29;a:3:{i:0;a:4:{s:5:"label";s:19:"Actions_downloads_*";s:9:"row_count";i:2;s:9:"blob_size";i:5519;s:9:"name_size";i:42;}i:1;a:0:{}i:3;N;}i:31;a:3:{i:0;a:4:{s:5:"label";s:15:"Actions_outlink";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1066";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:32;a:3:{i:0;a:4:{s:5:"label";s:17:"Actions_outlink_*";s:9:"row_count";i:23;s:9:"blob_size";i:7414;s:9:"name_size";i:437;}i:1;a:0:{}i:3;N;}i:55;a:3:{i:0;a:4:{s:5:"label";s:18:"Actions_sitesearch";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:56;a:3:{i:0;a:4:{s:5:"label";s:27:"CustomVariables_valueByName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:57;a:3:{i:0;a:4:{s:5:"label";s:20:"DevicePlugins_plugin";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"270";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:58;a:3:{i:0;a:4:{s:5:"label";s:31:"DevicesDetection_browserEngines";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"328";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:59;a:3:{i:0;a:4:{s:5:"label";s:32:"DevicesDetection_browserVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"2382";s:9:"name_size";s:2:"32";}i:1;a:0:{}i:3;N;}i:60;a:3:{i:0;a:4:{s:5:"label";s:27:"DevicesDetection_osVersions";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"554";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:61;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsCategory";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:62;a:3:{i:0;a:4:{s:5:"label";s:24:"Goals_ItemsCategory_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:63;a:3:{i:0;a:4:{s:5:"label";s:15:"Goals_ItemsName";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"15";}i:1;a:0:{}i:3;N;}i:64;a:3:{i:0;a:4:{s:5:"label";s:20:"Goals_ItemsName_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:65;a:3:{i:0;a:4:{s:5:"label";s:14:"Goals_ItemsSku";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:66;a:3:{i:0;a:4:{s:5:"label";s:19:"Goals_ItemsSku_Cart";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:67;a:3:{i:0;a:4:{s:5:"label";s:22:"Goal_*_days_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:706;s:9:"name_size";i:109;}i:1;a:0:{}i:3;N;}i:68;a:3:{i:0;a:4:{s:5:"label";s:24:"Goal_*_visits_until_conv";s:9:"row_count";i:5;s:9:"blob_size";i:654;s:9:"name_size";i:119;}i:1;a:0:{}i:3;N;}i:77;a:3:{i:0;a:4:{s:5:"label";s:20:"Provider_hostnameExt";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10573";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:78;a:3:{i:0;a:4:{s:5:"label";s:27:"Referrers_keywordByCampaign";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1207";s:9:"name_size";s:2:"27";}i:1;a:0:{}i:3;N;}i:79;a:3:{i:0;a:4:{s:5:"label";s:29:"Referrers_keywordByCampaign_*";s:9:"row_count";i:18;s:9:"blob_size";i:3215;s:9:"name_size";i:576;}i:1;a:0:{}i:3;N;}i:97;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_keywordBySearchEngine";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1124";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:98;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_keywordBySearchEngine_*";s:9:"row_count";i:26;s:9:"blob_size";i:14380;s:9:"name_size";i:910;}i:1;a:0:{}i:3;N;}i:124;a:3:{i:0;a:4:{s:5:"label";s:31:"Referrers_searchEngineByKeyword";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"24081";s:9:"name_size";s:2:"31";}i:1;a:0:{}i:3;N;}i:125;a:3:{i:0;a:4:{s:5:"label";s:33:"Referrers_searchEngineByKeyword_*";s:9:"row_count";i:999;s:9:"blob_size";i:138338;s:9:"name_size";i:35797;}i:1;a:0:{}i:3;N;}i:1124;a:3:{i:0;a:4:{s:5:"label";s:14:"Referrers_type";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"412";s:9:"name_size";s:2:"14";}i:1;a:0:{}i:3;N;}i:1125;a:3:{i:0;a:4:{s:5:"label";s:22:"Referrers_urlByWebsite";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"4273";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1126;a:3:{i:0;a:4:{s:5:"label";s:24:"Referrers_urlByWebsite_*";s:9:"row_count";i:152;s:9:"blob_size";i:74076;s:9:"name_size";i:4104;}i:1;a:0:{}i:3;N;}i:1278;a:3:{i:0;a:4:{s:5:"label";s:24:"Resolution_configuration";s:9:"row_count";s:1:"1";s:9:"blob_size";s:5:"10797";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1279;a:3:{i:0;a:4:{s:5:"label";s:21:"Resolution_resolution";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"5862";s:9:"name_size";s:2:"21";}i:1;a:0:{}i:3;N;}i:1280;a:3:{i:0;a:4:{s:5:"label";s:25:"SiteSearch_followingPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"25";}i:1;a:0:{}i:3;N;}i:1281;a:3:{i:0;a:4:{s:5:"label";s:19:"SiteSearch_keywords";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1282;a:3:{i:0;a:4:{s:5:"label";s:20:"SiteSearch_noResults";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}i:1283;a:3:{i:0;a:4:{s:5:"label";s:24:"SiteSearch_previousPages";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"24";}i:1;a:0:{}i:3;N;}i:1284;a:3:{i:0;a:4:{s:5:"label";s:22:"SiteSearch_refinements";s:9:"row_count";s:1:"1";s:9:"blob_size";s:2:"21";s:9:"name_size";s:2:"22";}i:1;a:0:{}i:3;N;}i:1285;a:3:{i:0;a:4:{s:5:"label";s:16:"UserCountry_city";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"16";}i:1;a:0:{}i:3;N;}i:1286;a:3:{i:0;a:4:{s:5:"label";s:19:"UserCountry_country";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1679";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1287;a:3:{i:0;a:4:{s:5:"label";s:18:"UserCountry_region";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"207";s:9:"name_size";s:2:"18";}i:1;a:0:{}i:3;N;}i:1288;a:3:{i:0;a:4:{s:5:"label";s:23:"UserSettings_wideScreen";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"294";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1289;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_daysSinceLastVisit";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"250";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1290;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_pageGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"220";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1291;a:3:{i:0;a:4:{s:5:"label";s:23:"VisitorInterest_timeGap";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"227";s:9:"name_size";s:2:"23";}i:1;a:0:{}i:3;N;}i:1292;a:3:{i:0;a:4:{s:5:"label";s:34:"VisitorInterest_visitsByVisitCount";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"214";s:9:"name_size";s:2:"34";}i:1;a:0:{}i:3;N;}i:1293;a:3:{i:0;a:4:{s:5:"label";s:19:"VisitTime_localTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:3:"785";s:9:"name_size";s:2:"19";}i:1;a:0:{}i:3;N;}i:1294;a:3:{i:0;a:4:{s:5:"label";s:20:"VisitTime_serverTime";s:9:"row_count";s:1:"1";s:9:"blob_size";s:4:"1538";s:9:"name_size";s:2:"20";}i:1;a:0:{}i:3;N;}}

Here are just 3 of 929 at this moment for just one month of old logs,it seems that those entries are all the same.

Regards

Marco


#12

Hi!

Piwik adds a lot of this entries into piwik_options:

While the forum thinks I’m a robot when posting some rows from db and adding an txt file as attachment is not possible, I added it to my webspace. http://www.needful.de/piwik_option.sql.zip (included are just the first 5000 rows) the complete table would be much larger.

Regards

Marco