Support » Plugin: AdRotate Banner Manager » Huge Database?

Viewing 15 replies - 1 through 15 (of 17 total)
  • Plugin Author Arnan de Gans

    (@adegans)

    The tracker table has a running set of rows logging clicks and such. Records older than 24 hours should be automatically purged.

    This problem seems to still be on going.

    The function adrotate_clean_trackerdata(); isn’t being called so the table is never being purged.

    Any ideas?

    Thanks

    Plugin Author Arnan de Gans

    (@adegans)

    THat function should be called on periodically by wp-cron.
    Can you confirm that that doesn’t happen? So far it seems to work for me.
    I’ll look into it for the next release.

    Hi Aman,

    It def. didn’t run on one of our clients installations, the table had nearly 2.5 million entries in and caused the db to crash.

    Plugin Author Arnan de Gans

    (@adegans)

    Nuts, I’ll look into it and see if I can make it more reliable 🙂
    Were you able to repair the database? Need help? – info@ajdg.net

    Plugin Author Arnan de Gans

    (@adegans)

    Thanks Aman, I’ll give it a try and yes, I was able to sort the database out.

    When is the updated version likely to be released? Are we just waiting for WP to approve it?

    Plugin Author Arnan de Gans

    (@adegans)

    I’m finishing up some things, I’m trying for tuesday/wednesday.

    I have the same problem, how can I solve? Is there a MySQL command I can run to shrink the database?

    Plugin Author Arnan de Gans

    (@adegans)

    Update to the latest version and manually re-activate the plugin to reset the cleanup schedule.

    That worked, thanks a lot!

    Plugin Author Arnan de Gans

    (@adegans)

    🙂

    Updating to latest version, deactivating – activating doesn’t clean up database. I’ve tried it many times.

    I ended up with 110MB of *adrotate_tracker.MYD table for one of my blog. It doesn’t even have massive traffic. This blog had massive traffic in the past so I’m assuming plugin doesn’t clean up old entries.

    I manually triggered wp-cron.php but it doesn’t do cleanup.

    Any solution?

    Is there a way to disable tracking? I’m not interested in tracking I just want to serve ads.

    Plugin Author Arnan de Gans

    (@adegans)

    If you look at the AdRotate Settings, near the bottom. There should be some schedules listed. What does it say there?

    Also, please post in your own topic next time. This is not related to the original topic.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Huge Database?’ is closed to new replies.