WordPress.org

Ready to get started?Download WordPress

Forums

AdRotate
[resolved] wp_adrotate_tracker question (5 posts)

  1. eberthtorres
    Member
    Posted 1 year ago #

    Hi, I have used the plug over a year and wp_adrotate_tracker table has become very heavy, more than 100MB, how can I avoid accumulating more MB?, or how can I debug or empty that table?

    Thanks

    http://wordpress.org/extend/plugins/adrotate/

  2. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

    That table should hold no records older than 24 hours.
    It's a running log of stats and such to prevent people inflating your stats.

    There is a schedule/wp_cron job to clean that up. Whcih should run every so much hours. If it doesn't work for you now, try disabling and enabling the plugin to reinstate the schedule.

  3. frenchws
    Member
    Posted 1 year ago #

    Hi there,

    Just seen this post and realised that my wp_adrotate_tracker table has 1.4 million rows(!) and is currently 80ish MB... which by the sounds of things isn't quite right!

    I haven't tried disabling and re-enabling the plugin yet, but if that fails is there any other "clean" way to clear it down to the expected levels?

    Cheers
    P

  4. Arnan de Gans
    Member
    Plugin Author

    Posted 1 year ago #

    click "clean up database" from AdRotate Settings should remove the exessive records.

  5. frenchws
    Member
    Posted 1 year ago #

    Unfortunately, that didn't work.

    What is the query/stored procedure that the cron job runs to clear down the table? If that's available, I can run the query/SP manually

    Cheers,
    P

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.