WP download log large

  • Resolved dyin

    (@dyin)


    1 year, 4 months ago

    I was cleaning up the database of my site and I have a fairly large database table with the name “wp_download_log”.
    It has 27000 entries and is about 11,5mb large.
    Is this something created by download monitor? It there a safe way to decrease its size?

    It could be related to something else but I can’t find any info online

    Thanks for the help

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hi

    Surprisingly, DLM doesn’t automatically purge old logs so two tables grow indefinitely (download_log and dlm_reports_log).

    You have to delete the old entries yourself before the tables become too big.

    See https://www.ads-software.com/support/topic/does-dlm-automatically-purge-old-logs/

    Plugin Author Cristian Raiber

    (@cristianraiber-1)

    We’ll look into this. Normally, logs aren’t auto purged because the Reporting system relies on these logs (logs are parsed to create the reports).

    We could probably add a setting that allows users the time frame they’d like to keep data for. So someone could say I only want to store logs for 3 months and I don’t care about anything past that point.

    Would a solution like this help?

    Thread Starter dyin

    (@dyin)

    @nenesse8 thank you for the tip on how to purge

    @cristianraiber-1 It would be awesome if the plugin would take into account how long you would need the data. Personally I don’t need the history at all but if users would get the options for a certain timeframe that would work too.
    I am on a shared host so I need to take care of the amount of data I keep.

    Plugin Author Cristian Raiber

    (@cristianraiber-1)

    I’ll have a chat with my dev team on Monday about it, see how we could handle something like this.

    Thread Starter dyin

    (@dyin)

    @cristianraiber-1 Awesome. Any tips to manually clean it are also welcome. Eg: a mysql command

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WP download log large’ is closed to new replies.