mansooryusaf
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] wp_options table growing fast in sizeI reactivate asset cleanup pro and wp_options size start growing. With some additional workout there were two facebook pixels plugin running. I disabled additional “Facebook for wordpress” plugin and now wp_options is 100% fixed.
- This reply was modified 3 years, 9 months ago by mansooryusaf.
Forum: Plugins
In reply to: [WooCommerce] wp_options table growing fast in sizeThe another culprit was asset cleanup pro where I disabled different scripts on different pages. I disabled asset cleanup pro and my issue is completely resolved. I will reactivate asset cleanup pro later and try to find out the issue.
Forum: Plugins
In reply to: [WooCommerce] wp_options table growing fast in sizeI found the glitch. It was wprocket optimize css (rucss) feature which was calling woocommerce scripts repeatedly. The cron autoscheduler job for wprocket was stuck in wp_actionscheduler_actions. I clear the cron using command
"UPDATE wp_options SET option_value = '' WHERE option_name = 'cron';"and all went well. It took my 10 days to diagnose and fix the job. Thanks.Forum: Plugins
In reply to: [WooCommerce] wp_options table growing fast in sizethese are the database size detail as guide of kinsta for top 10
name value
autoloaded data in KiB 1956
autoloaded data count 4142
wpseo_taxonomy_meta 228817
rewrite_rules 224211
widgetopts_global_taxonomies 183379
wpseo-premium-redirects-export-plain 89350
asp_updates 55128
p3_scan_scan_2020-12-31_8ff23f1c 54418
wphb_scripts_collection 52815
wpseo_titles 47178
duplicator_pro_package_active 42044
wphb_styles_collection 38004Forum: Plugins
In reply to: [WooCommerce] wp_options table growing fast in sizeI spend 1 week and did all optimizations as you mentioned using wp optimize and following the guides you mention in these links particularly kinsta. In addition I used advanced db cleaner pro plugin. Wp Optimize, advanced db cleaner and phpymyadmin optimize table all of them instantly reduced table size to 12MB from 5GB. but in few minutes wp_options table grows to 200MB and in 1 hour from 1.5 to 2GB and keep growing.