Presently running a 60GB piwik db with records over 2 years.
The cost of hosting it is getting exorbitant and for my usage I really only require recent data say 3-6months.
The two tables that take up the most space and date back the furthest appear to be piwik_log_visit & piwik_log_link_visit_action.
Are these the right DB’s to truncate in order to trim the Piwik DB? On a mirror of my production DB, I’m presently testing deleting all records older than 90days from both tables and as expected is taking a huge amount of time.
Is this the ideal way to go about trimming piwik to hold records only for the last x days?
Into the future, is it better to a run a db cleanup script to do this every month? Or utilize piwik’s own settings? Anybody have any tricks, methods or scripts that would achieve what i’m after?