Maintenance mode doesn’t work

  • nestormarius

    (@nestormarius)


    1 year, 1 month ago

    Hi, I am having issues with the maintenance mode. Whatever I set in there it doesn’t seem to work. The top_ten database table has over 2 milion entries and the top_ten_daily has over 700K entries. Both have about 50MB in size each, so 100MB in total.

    It’s not the first time I am having issues. Even if I disable the plugin, the tables are still there. What are my options to clean up the tables because I believe it slows down my website?

    Edit: WP CRON is not disabled in wp-config. Is there a way to manually perform cleaning of the tables?

    Thank you!

    • This topic was modified 1 year, 1 month ago by nestormarius.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter nestormarius

    (@nestormarius)

    1 year, 1 month ago

    I found this in class-cron.php

    DELETE FROM {$table_name_daily} WHERE dp_date <= %s

    I could use this to manually delete the entries, but this looks to alter only the top_ten_daily table and not the top_ten table whcih has over 2 milion entries. Does it also work for the top_ten table? Also, what’s the correct syntax for running this command in PhpMyAdmin?

    Plugin Author Ajay

    (@ajay)

    1 year, 1 month ago

    Hi @nestormarius

    What I’m surprised to hear is that the top_ten table has 2 million entries. I take it that you don’t have that many posts, right? because that table should have at max the number of posts (all kinds) – maybe a bit more if posts were deleted.

    Are you able to check what you have recorded there in the columns? I have a feeling that there might be duplicates in there for some reason because instead of recording a single entry, it’s recorded duplicates. Unsure how long you’ve been running this plugin.

    What you can do as the first step is to backup your database – at least those folders. Then go to the Tools page and run “Merge duplicates across blog IDs” which should consolidate entries.

    The next step would be to Recreate Tables.

    The maintenance mode is designed only for the daily tables and the reason for that was because that’s the one that can blow up given each post could have up to 24 entries per day.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Maintenance mode doesn’t work’ is closed to new replies.