I got a piwik_log_action, piwik_log_link_visit_action and piwik_log_visit that are all around 6GB, except for log_visit, which is around 2GB.
I’m trying to clean this up by running the purge-old-data console command, but, it’s very, very slow with executing this.
Any way to speed this up, or could you tell me why this isn’t optimized ?
My database server is very fast, but this is ridiculously slow.
piwik_log_actions and the other table that is huge, is not being purged.
How can I safely purge it for like a week of data stays in there ?
the purge-old-data seems to be broken.