Support » Plugin: WooCommerce Admin » Lots of ActionScheduler in wp-comments

  • Resolved anta12345

    (@anta12345)


    Hello,

    We’re seeing load issues with this plugin on several of our customer’s WordPress/Woocommerce deployments. It appears that this plugin creates numerous ActionScheduler in the wp_comments table. This causes problems when backup systems try to backup the database.

Viewing 4 replies - 1 through 4 (of 4 total)
  • @anta12345

    Action Scheduler actions are stored in the comments table.

    Plugin Author Ron Rennick

    (@wpmuguru)

    Action Scheduler will automatically purge the completed actions after 30 days.The next version of Action Scheduler will implement custom tables instead of the current custom post type.

    Hello Ron,

    Does this mean the volume of these rows stay the same in the custom tables? Because the sheer amount of rows inserted poses a problem for backup functionality of Installatron. Installatron tries to make a dump of the database and hangs on dumping the wp_comments table. The problem becomes larger when the next day the same schedule tries to backup the same database again. We’re seeing cases we’re the SQL server is dealing with upwards of 50k SQL queries per second because of this.

    Plugin Author Ron Rennick

    (@wpmuguru)

    Does this mean the volume of these rows stay the same in the custom tables?

    The number of rows will be the same but the size of the rows will not be the same. In a SQL backup they will be substantially smaller.

    We’re seeing cases we’re the SQL server is dealing with upwards of 50k SQL queries per second because of this.

    That sounds like you may have something going into a recursive loop or similar. Neither WC Admin or Action Scheduler add any DB queries to the front end of the site. Any queries they are generating are coming from the dashboard or WP CRON.

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