huge db table wp_adrotate_tracker

  • I have had this issue in the past and it seems to be coming up again.
    My table in the database for wp_adrotate_tracker is now huge again (30gb!)
    When I look under adrotate settings, I do see a date set under “Clean Trackerdata next run”.
    I also tried running the manual “cleanup database” link in the settings.

    I want to set something up to manually clean this up regularly but don’t want to mess up the data.
    Is there a direct link I can use to call the cleanup script?
    Or can you provide me with the SQl needed and I will create my own cron job?

    My understanding is that the table should not have items more than 24 hours old, so if I truncate the table will I at most lose 24 hours of statistics or am I risking losing more than that?

    https://www.ads-software.com/plugins/adrotate/

  • The topic ‘huge db table wp_adrotate_tracker’ is closed to new replies.