wp_adrotate_tracker question

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.

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

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

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