Title: Huge Database? Last modified: August 20, 2016 --- # Huge Database? * Resolved [ncdesignz](https://wordpress.org/support/users/ncdesignz/) * (@ncdesignz) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/) * I am using the latest version of AdRotate, and have been doing some database cleanup for my client. * Why is it that we are running 63 ads, and yet there are 1,984,944 rows in the WP AdRotate Tracker table? * [http://wordpress.org/extend/plugins/adrotate/](http://wordpress.org/extend/plugins/adrotate/) Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/huge-database-1/page/2/?output_format=md) [→](https://wordpress.org/support/topic/huge-database-1/page/2/?output_format=md) * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469493) * The tracker table has a running set of rows logging clicks and such. Records older than 24 hours should be automatically purged. * [stuartmcnair](https://wordpress.org/support/users/stuartmcnair/) * (@stuartmcnair) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469550) * 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](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469558) * 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. * [stuartmcnair](https://wordpress.org/support/users/stuartmcnair/) * (@stuartmcnair) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469559) * 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](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469561) * 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](https://wordpress.org/support/topic/huge-database-1/info@ajdg.net?output_format=md) * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469562) * I think I fixed it 🙂 [http://www.adrotateplugin.com/download/changelog/](http://www.adrotateplugin.com/download/changelog/) * [stuartmcnair](https://wordpress.org/support/users/stuartmcnair/) * (@stuartmcnair) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469563) * Thanks Aman, I’ll give it a try and yes, I was able to sort the database out. * [stuartmcnair](https://wordpress.org/support/users/stuartmcnair/) * (@stuartmcnair) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469564) * When is the updated version likely to be released? Are we just waiting for WP to approve it? * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 2 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469565) * I’m finishing up some things, I’m trying for tuesday/wednesday. * [baga](https://wordpress.org/support/users/baga/) * (@baga) * [13 years, 1 month ago](https://wordpress.org/support/topic/huge-database-1/#post-3469584) * I have the same problem, how can I solve? Is there a MySQL command I can run to shrink the database? * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 1 month ago](https://wordpress.org/support/topic/huge-database-1/#post-3469585) * Update to the latest version and manually re-activate the plugin to reset the cleanup schedule. * [baga](https://wordpress.org/support/users/baga/) * (@baga) * [13 years, 1 month ago](https://wordpress.org/support/topic/huge-database-1/#post-3469586) * That worked, thanks a lot! * Plugin Author [Arnan](https://wordpress.org/support/users/adegans/) * (@adegans) * [13 years, 1 month ago](https://wordpress.org/support/topic/huge-database-1/#post-3469587) * 🙂 * [ajaykumarsinghuk](https://wordpress.org/support/users/ajaykumarsinghuk/) * (@ajaykumarsinghuk) * [12 years, 4 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469617) * 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](https://wordpress.org/support/users/adegans/) * (@adegans) * [12 years, 4 months ago](https://wordpress.org/support/topic/huge-database-1/#post-3469618) * 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) 1 [2](https://wordpress.org/support/topic/huge-database-1/page/2/?output_format=md) [→](https://wordpress.org/support/topic/huge-database-1/page/2/?output_format=md) The topic ‘Huge Database?’ is closed to new replies. * ![](https://ps.w.org/adrotate/assets/icon-256x256.gif?rev=3117289) * [AdRotate Banner Manager](https://wordpress.org/plugins/adrotate/) * [Frequently Asked Questions](https://wordpress.org/plugins/adrotate/#faq) * [Support Threads](https://wordpress.org/support/plugin/adrotate/) * [Active Topics](https://wordpress.org/support/plugin/adrotate/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/adrotate/unresolved/) * [Reviews](https://wordpress.org/support/plugin/adrotate/reviews/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * 17 replies * 5 participants * Last reply from: [Arnan](https://wordpress.org/support/users/adegans/) * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/huge-database-1/page/2/#post-3469621) * Status: resolved