DB double size in Report Tables


#1

I’m managing a single Piwik instance with 6 web sites with about 2.5 millions pageviews a month.

Usually monthly reports are around 300 000 rows and 300 M size and January, as usual, are bigger because it contain the precedent year report.

What changed between February 2014 and 2015 is Piwik version 1.12 vs. 2.11.b3 and that line in my config:

enable_processing_unique_visitors_year = 1

Could that single line explain why my DB size has double ?

See screenshot :

[attachment 2174 2015-02-2310_11_03-PiwikAdministration.jpg]


(Matthieu Aubry) #2

Hi there,

no this line cannot explain the DB size doubling. Can you please create a bug report with your screenshot in our tracker: Issues · matomo-org/piwik · GitHub
we will investigate then!


#3

Done in DB as doubled in size after upgrade from 2.7 to 2.11 · Issue #7281 · matomo-org/piwik · GitHub