[li] You can activate the DBStats plugin in Piwik. It will show you which tables use up your database the most.
[/li][li] 40MB? That is a pretty bad hosting plan if they set the quota to only this. Piwik will easily outscale this limit.
Well, 40MB is probably a low number considering today’s plan.However, as I told you this was perfectly fiiting the needs since 2006.
The cms tables (modx) is only 980Ko …
Now we have a 400MB quota.
But I actually need to understand why this brutal DB consumption grow up since this very last update.
and also why now when I change the period in the dashboard (last day to week) the graphic for last visits and synthesis took may be 40sec to display.
Choosing month… no widget get data or it’s erratic
A CMS only stores text data. Piwik is not a cms. It stores data for every visit and page view your website gets. This data is then processed and archived. The latest update to 1.11.1 did not change any archiving and the DB size should not have grown dramatically.