Small site, big data


I’ve installed Piwik for a small site (6k visists/day) and I get rather big data files:

-rw-rw---- 1 mysql mysql 25G Jul 15 00:54 piwik_archive_blob_2011_07.MYD

Why is it so big and how can I keep it lower ?

Thanks !

Normally, these should get cleaned up every day or so, you should see much lower size. (reports that are “outdated” will be cleaned up)

But, I suspect you haven’t setup cron as explained in: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo

make sure that you disable “browser trigger archiving” and also set a higher timeout, for example 1 hour timeout. This will ensure that reports are not re-processed every time you look at them, and therefore dont create huge tables.

Thanks matt for pointing me to the right docs, I’ll try this and come back here to update status on this problem.

Now after a few days everything is ok so I think this issue (more like a non-issue !) is closed. Thank you for your help.