Small site, big data


#1

Hello,

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 !


(Matthieu Aubry) #2

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.


#3

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


#4

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.