I have a Piwik installation with 50 small websites tracked.
I disabled the browser triggered archiving, set the processing report to 30minutes (1800 seconds) and I’m running the auto-archive cron script every hour.
Thanks to new features in new version (1.5) I set the weekly automatic purge of logs older than 180 days.
My Piwik database is stll “big”, about 700 Mib. I read on that forum and some blogs around the net that I can drop the tables “piwik_archive_blob_*” and “piwik_archive_numeric_*”, because they’re rebuilt automatically when they are needed.
Is this correct? Can i purge that tables without losing old data?
I know, with log purge I delete everything but access statistics.
I can’t understand if access statistics are related to piwik_archive_blob_* or piwik_archive_numeric_*, but I have to reduce database usage
Thanks in advance!