Delete Reports For A Specific Month


#1

We have an issue where one month we have 6.2G in data for archived reports in it’s archive_blob. This is abnormal because the other months surrounding it were around 70M. When reviewing the statistics for this one month, there is nothing that is different than the other months surrounding it.

Is it possible to delete just the archived reports for this one specific month without it affecting piwik negatively? Would it be as simple as deleting the archive_blob and archive_numeric associated with it, or is there a more specific method?

I know that we can purge all data before a specific date, but upper management would prefer to keep as many of the existing reports as possible.

Thank you for your help.


(Matthieu Aubry) #2

You are experiencing a bug probably which we will fix soon

you can safely remove the archive table especially if you still have the old logs to reprocess the data