Remove action_scheduler data from db after uninstall

#518388
  • Resolved Neil Ingoe

    2 years, 1 month ago

    Rank Math free

    I am having to downsize my site in order to save on hosting costs, and one casualty of this is Rank Math, due to the amount of DB space required.

    I’ve added the filter to remove all data on uninstall and all RM tables have now gone from my DB.

    However, there are 65k rows, taking up 80MB of space in the tabls actionscheduler_actions which use Rank Math hooks.

    Please advise whether and how (DB script or php) these can be safely deleted. Clearing this data gets me most of the way to the target DB size.

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Reinelle

    2 years, 1 month ago

    Hello,

    Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for any inconvenience this issue may have caused you.

    The wp_actionscheduler is a WordPress script that many plugins, including Rank Math, utilize for creating scheduled actions. The tables are created to make the Analytics module work and pull data from your search console and Google Analytics profiles.

    However, ActionScheduler is required for Rank Math Analytics. If you’re not using it, you can manually delete the wp_actionscheduler_logs data.

    If you check the actions inside that table and you see most are completed ones you can safely delete those from the actions table.

    It’s likely that you’ll see some actions related to our Analytics module there but it will also have actions from other plugins that rely on the ActionScheuler plugin.

    Head over to WordPress Dashboard > Tools > Scheduled Actions and see what actions you have on that list.

    Any action that has a status of completed can be safely deleted from the list.

    Please note that we always recommend creating a backup first when working with databases and making such actions.

    Hope that helps.

    Thank you.

    Neil Ingoe

    2 years, 1 month ago

    Rank Math free

    Hi,

    And what does one do if Tools > Scheduled actions is not visible?

    I don’t have that option. And as I said above, there are 65k lines of data attributable to Rank Math.

    Manual deletion is therefore not an option I’m keen on.

    Neil Ingoe

    2 years, 1 month ago

    Rank Math free

    Thanks for your help on this. After investigating further, I’ve realised another plugin using Action Scheduler had hidden the UI – very naughty of them.

    After deactivating that plugin I’ve been able to access the UI.

    Reinelle

    2 years, 1 month ago

    Hello,

    We are super happy that this issue is already resolved. If you have any other questions in the future, know that we are here to help you.

    If you don’t mind us asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

    If you have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.

    Thank you.

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

The ticket ‘Remove action_scheduler data from db after uninstall’ is closed to new replies.