Title: wp_options table overflow from plugin
Last modified: June 1, 2024

---

# wp_options table overflow from plugin

 *  Resolved [georgeatmatsidis](https://wordpress.org/support/users/georgeatmatsidis/)
 * (@georgeatmatsidis)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/wp_options-table-overflow-from-plugin/)
 * After a research on database i saw the wp_options is huge. For example when i
   execute the following query SELECT option_name, option_value FROM wp_options 
   WHERE option_name LIKE ‘wc_facebook%’; it provide me 181.088 records with option_name
   as wc_facebook_background_product_sync_job_0000abdc06ca0381567b43c77151e6da and
   option_value with status completed request, some update and created date. 
   We
   have a leak or this is normal? What if i delete those records the plugin will
   broke?Those numbers of records is not normal

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

 *  [Shameem – a11n](https://wordpress.org/support/users/shameemreza/)
 * (@shameemreza)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/wp_options-table-overflow-from-plugin/#post-17796509)
 * Hi [@georgeatmatsidis](https://wordpress.org/support/users/georgeatmatsidis/)
 * This is not typical. It seems like there might be an issue with the plugin’s 
   background synchronization process, which is causing an excessive number of records
   to be created. Can you please navigate to WooCommerce > Status > Scheduled Actions
   and check whether any pending or failed actions related to Facebook exist?
 * Deleting these records may disrupt the plugin’s functionality, so I recommend
   backing up your database to prevent any potential data loss if something goes
   wrong.
 * Additionally, clear any caches related to your website, including server cache,
   browser cache, and any caching plugins you may be using. Also, install a plugin
   like [WP Crontrol](https://wordpress.org/plugins/wp-crontrol/) to monitor whether
   the cron function is working correctly.
 * I hope this clarifies your concern. If you have any other questions, feel free
   to ask.
 *  Thread Starter [georgeatmatsidis](https://wordpress.org/support/users/georgeatmatsidis/)
 * (@georgeatmatsidis)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/wp_options-table-overflow-from-plugin/#post-17805016)
 * I checked everything, and this is still growing. Any know why this happen?
 *  [omarfpg a11n](https://wordpress.org/support/users/omarfpg/)
 * (@omarfpg)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/wp_options-table-overflow-from-plugin/#post-17805243)
 * Hi [@georgeatmatsidis](https://wordpress.org/support/users/georgeatmatsidis/),
 * Which version of the plugin are you using? Since version 2.6.0 the plugin has
   included a daily task that cleans out the old finished jobs. It does it by eliminating
   around 250 jobs a day (learn more [here](https://github.com/woocommerce/facebook-for-woocommerce/pull/1962)).
   So if you have a large number it should take some time to clean things out. From
   what you are saying you have a very large number of old jobs and the 250 entries
   deleted per day may not be fast enough.
 * The other thing that may be happening is that for some reason on your site the
   entries are created abnormally often – this would suggest issues of a different
   sort.
 * Either way, it is safe to remove the entries even without disabling the plugin
   as long as you are targeting only the completed jobs with the status “completed”.
   
   This should speed up the other queries.
 * After removing the completed entries please observe the DB and check if the cleanup
   code is able to remove the completed entries daily.
 * I hope that this helps!
   -OP
 *  [omarfpg a11n](https://wordpress.org/support/users/omarfpg/)
 * (@omarfpg)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/wp_options-table-overflow-from-plugin/#post-17820225)
 * Hi there 👋 ,
 * We haven’t heard from you in a while; this is to check if you’ve been able to
   proceed with the troubleshooting steps provided before and if you still need 
   help.
 * Thanks!
   -OP

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

The topic ‘wp_options table overflow from plugin’ is closed to new replies.

 * ![](https://ps.w.org/facebook-for-woocommerce/assets/icon.svg?rev=3469606)
 * [Meta for WooCommerce](https://wordpress.org/plugins/facebook-for-woocommerce/)
 * [Support Threads](https://wordpress.org/support/plugin/facebook-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/facebook-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/facebook-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/facebook-for-woocommerce/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [omarfpg a11n](https://wordpress.org/support/users/omarfpg/)
 * Last activity: [1 year, 11 months ago](https://wordpress.org/support/topic/wp_options-table-overflow-from-plugin/#post-17820225)
 * Status: resolved