Hello, maybe this is a suggestion that is impossible to apply…
What about to archive old data to file instead of database?
Example 1: I have a limited MySQL quota and piwik_archives tables are becoming too big. I don’t want to loose old statistics, but I need to free up space and I have unlimited file space. I don’t need to look every day to old months/years statistics, so maybe old archives can be saved and can be automatically called from file when I need them, freeing up the database.
Example 2: I want to purge old log entries as suggested in the wiki. But in the future if I need to rebuild archives I don’t want to loose data. Maybe old log entries can be periodically saved to file before deleting them from the log.
Is this something possible?