Delete old logs should also delete unused urls from piwik_log_action
|Reported by:||matt||Owned by:|
|Priority:||critical||Milestone:||1.12.x - Piwik 1.12.x|
Currently, "Delete logs older than X Months" does not delete unused rows in the lookup table piwik_log_action
We could however remove all entries from this table, that is not currently referenced in piwik_log_link_visit_action.
we could run a JOIN query to delete unused rows from this table. This query might run extremely slowly on large tables, so it would be nice to test it on a good example.
suggestion directly from the high traffic piwik thread
Change History (21)
comment:1 Changed 23 months ago by matt (mattab)
- Milestone changed from 1.8 Piwik 1.8 to 1.7 Piwik 1.7
comment:14 Changed 20 months ago by capedfuzz (diosmosis)
- Resolution set to fixed
- Status changed from new to closed