mysql database to big size

Hey @tuhinbiswas98 – Thanks for reaching out!

Kindly follow the steps below but before doing anything, please make sure to backup your database so that you can easily roll back just in case something goes wrong.

To remove all WPForms data including wp_wpforms_tasks_meta table:

• Reinstall WPForms Lite plugin
• Check?“Uninstall WPForms”?checkbox under?wp-admin/admin.php?page=wpforms-settings&view=misc
• Save Settings
• Deactivate and uninstall WPForms Lite plugin

To remove Action Scheduler tables (proceed with caution since it’s a shared library and can break other code):

• After removing WPForms Lite, go to this page to download the latest version of the Action Scheduler plugin by clicking on the “Source code (zip)” link.
• Install and activate the downloaded Action Scheduler zip in WordPress > Plugins.
• Go to Tools > Scheduled Actions or use the wp-admin/tools.php?page=action-scheduler URL to make sure no other actions except wpforms` are scheduled.
• If actions from other plugins/themes/custom code is present, Action Scheduler tables should not be removed because it will likely break other code.
• If there are still wpforms’ actions and no other actions, delete all wpforms’ actions.
• Deactivate and remove Action Scheduler plugin.
• Remove Action Scheduler tables from DB via phpMyAdmin or other DB management tools.

I hope this helps.

• This reply was modified 1 year, 10 months ago by Prashant Rai.

after reinstal WPForms then instal Action Scheduler plugin??

and any way to save my forms??

Hey @tuhinbiswas98,

Kenneth here, filling in for Prashant.

Before we can proceed further, could you please help us to collect some details from your site so that we can understand the root cause of the issue? To get started, could you please head over to WPForms > Tools > Scheduled Actions and share a screenshot of this page?

I’m looking forward to your response! Thanks ??

ok look at this https://ibb.co/ww2wrGS

Hey @tuhinbiswas98

Thank you for sharing the screenshot, it really helps. However, the number of WPForms actions listed on the screenshot suggests that our plugin might not be clogging up the database table. Please note that the Action Scheduler library is a third party library that is used by a couple of plugins. It is likely that you have another plugin on your site that is queueing several background actions that are piling up the table.

Could you please install the WP Crontrol plugin and check the recurrence of the cron schedules that are enabled on your site? This plugin should also help to manage the schedules and stop the ones that are firing to often and stuffing your database.

I hope this helps. Thanks!

look at this https://ibb.co/x5Ts4kb

but i have 2 site i use all same plugins but 1 site dont have this problem..

MySQL look like this and its take 1.3gb

https://ibb.co/NTVDSqJ

Hey @tuhinbiswas98,

Thank you for the additional details. It is a bit odd that this is only happening on one of the sites. Is it possible that the affected site is significantly larger? To help us troubleshoot this further, could you please add the following code snippet to your site to stop the registration of the Action Scheduler task for scanning locations and then keep an eye on this and let me know if the table fills up again after 24 hours?
add_filter( 'wpforms_tasks_actions_forms_locator_scan_task_interval', '__return_zero' );
In case it helps, here’s our tutorial with the most common ways to add custom code like this.
For the most beginner-friendly option in that tutorial, I’d recommend using the Code Snippets plugin.

Hi @tuhinbiswas98

We haven’t heard back from you in a few days, so I’m going to go ahead and close this thread for now. But if you’d like to share the results of our test above, please feel welcome to continue the conversation.

Thanks!