• In the database the wp_top_ten_daily table has over 190,000 rows in it. How can I safely purge unwanted data in there?

    thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ajay

    (@ajay)

    You can turn on the Maintenance Mode in the settings page. This should clean out entries older than 180 days by default.

    Thread Starter mattc_uk

    (@mattc_uk)

    Great thanks, I’ll set it to temporarily run daily and set the time to 5 minutes time. Then I’ll set it to weekly once the time has past.

    Will check the SQL tables afterwards

    Thanks

    Plugin Author Ajay

    (@ajay)

    Actually, you can set it once and leave it. When enabled, it will clean up anything older than 180 days. Set daily, it will keep running it daily.

    Usually weekly or even monthly is fine unless you have a very high traffic site.

    Thread Starter mattc_uk

    (@mattc_uk)

    I have CRON disabled via the “DISABLE_WP_CRON’, ‘true'” parameter in wp-config. Instead I set a wp-cron.php to run in cron jobs on the server to run once every half an hour.

    I’m presuming if I had set the plugin maintenance job to run at say 2:30, it may have missed the wp-cron job on the server and be picked up on the next one at 3:00 ?

    Not really sure how the relationship works

    Plugin Author Ajay

    (@ajay)

    I don’t know how the replacement cron-job would work as above – but the best test would be to check if the rows got reduced.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘top_ten-daily table has over 190,000 rows’ is closed to new replies.