wp_options table overflow from plugin

  • Resolved georgeatmatsidis

    (@georgeatmatsidis)


    1 year, 11 months ago

    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

    (@shameemreza)

    1 year, 11 months ago

    Hi @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 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

    (@georgeatmatsidis)

    1 year, 11 months ago

    I checked everything, and this is still growing. Any know why this happen?

    omarfpg a11n

    (@omarfpg)

    1 year, 11 months ago

    Hi @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). 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

    (@omarfpg)

    1 year, 11 months ago

    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.