Database size wp_actionscheduler_actions & wp_actionscheduler_logs

  • Resolved glew

    (@glew)


    3 months ago

    Hi i have a problem with the database wp_actionscheduler_actions & wp_actionscheduler_logs

    https://prnt.sc/zDzqc6h_5gfB

    I have 2 woocommerce site, and in one this 2 tables they are cleaned periodically automatically, but in the second site, as seen in the image, they are not cleaned and it has 6 million records.

    Almost all the records are “wc-admin_import_orders”

    I see i can clean via phpmyadmin, but i like to do automatically.

    What i can check to see why woocommerce are failing clean this 2 tables.

    Thanks

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @glew

    The tables you mentioned are used by WooCommerce to schedule and log actions. If these tables are not being cleaned up automatically, it could be due to a couple of reasons:

    1. WooCommerce uses WordPress cron jobs to schedule tasks. If the cron jobs are not working correctly, the cleanup process might not run.
    2. WooCommerce has a system status tool that allows you to clean the database. If this tool is not working correctly, it might not clean up these tables.

    To resolve this issue, I suggest you check the following:

    1. Check if your WordPress cron jobs are working correctly. You can use a plugin like WP Crontrol to view and manage the cron jobs.
    2. Check if the WooCommerce database cleanup tool is working correctly. You can find this tool in WooCommerce > Status > Tools.
    3. If the above steps don’t work, you might want to consider using a plugin like WP-Optimize. This plugin can help you clean your database automatically.

    Remember to backup your website before making any changes.

    I hope this helps! Please let us know how it goes or if you need further assistance.

    Thread Starter glew

    (@glew)

    Hi @shameemreza thanks for the fast reply.

    About the crons, i have the cron running on the server side, and the crons on WordPress look great all running.

    About the Woocommerce – Status – Tools which tool i need to use i dont have any say “WooCommerce database cleanup”

    If nothing work i go to install any Database optimizer, but i prefer to try to fix the problem without add any plugin.

    Thanks

    Hey, @glew!

    If nothing work i go to install any Database optimizer, but i prefer to try to fix the problem without add any plugin.

    I understand it and it makes sense. However, for this particular task, there’s no way to do it by default.

    We recommend WP-Optimize?and?Advanced Database Cleaner.

    We also have a guide with more information and tips about cleaning the database, you can check it here.

    I hope this was clarifying. Please let us know if there’s anything else we can do to help or if you have any questions.

    Have a wonderful day!

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.