[AndrewD]

Originally Posted by hydn

We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.

Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.