Lots of ActionScheduler in wp-comments

@anta12345

Action Scheduler actions are stored in the comments table.

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.

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.