Recently I have discovered the feature to delete old visitor logs from the database via the PIWIK admintool and keeping the processed archived ones. I had a database size of about 17GB, that shrunk to 9GB. Great tool
Is it possible that the table log_action did not improve from this feature? It is still about 2.6GB with 23 million records. The problem is, that i have many URLs with a unique hash in it. These are one time URLs for my user to download something. Therefore I do not need them later, but they can still be found in log_action.
Is there a possibility to integrate log_action into the purge mechanism?