Title: SG Optimizer Memcache disables automatically Last modified: July 18, 2020 --- # SG Optimizer Memcache disables automatically * Resolved [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/) * Since last update (5.4.2) SG Optimizer disables Memcache automatically and displays the message: * SINGLE OBJECT SIZE TOO BIG Your site tried to store a single object above 1MB in Memcached which is above the limitation and will actually slow your site rather than speed it up. Please, check your Options table for obsolete data before enabling it again. Note that the service will be automatically disabled if such error occurs again. * Flushing, dis/enabling memcache in super cacher and dis/enabling memcache in SG Optimizer in any order does not help. Avg. Server Response Time (sec) on SiteGround has more than doubled. - This topic was modified 5 years, 9 months ago by [smartalert](https://wordpress.org/support/users/smartalert/). * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsg-optimizer-memcache-disables-automatically%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/page/2/?output_format=md) * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13143524) * Flushing caching will not solve the error message and memcached will not work unless you take a look at your database and perform a cleanup. * Most probably, you have big content in the options table that’s set to autoload which exceeds the limit of the single object size. * Note, that if we don’t disable Memcached while your site is producing such big single objects it will be signifficantly slowed down. * [JawaScript](https://wordpress.org/support/users/crimsonguard/) * (@crimsonguard) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13146475) * Hi. I have the exact same issue. I don’t know what to do, except rolling back to previous version, maybe 5.5.6 since the Memcached feature was changed on 5.5.7( but currently it broke my site). I looked through wp_options table, not sure what I ned to look for. It’s only 11 MB, since this is a very big site, it doesn’t seem to ave wrong lines. * Thread Starter [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13146513) * Thanks for the pointer, very helpful! Removed some stuff from the options table, uninstalled some plugins, optimized DB. The Query for ALL autoloaded data: “SELECT SUM(LENGTH(option_value)) as autoload_size FROM wp_options WHERE autoload=’yes’;” returns now 741086, which is less than 1 MB. The whole options table is 1.8 MB. * Still, SG Optimizer memcache returns the same error. Do you have some other pointers? Maybe Logging I could provide? * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13148485) * It doesn’t make any sense to revert and enable Memcached if you see this error. Options are not the only tables queried and cached. If you are generating single objects bigger than 1MB then that’s a problem and Memcached will actually **slow down** your site. It is better to keep it off until you figure out what is causing it. * We will add logging to 5.6.1 so it’s easier to track which keys cause large objects. * [JawaScript](https://wordpress.org/support/users/crimsonguard/) * (@crimsonguard) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13148936) * Thank you [@hristo-sg](https://wordpress.org/support/users/hristo-sg/) for your reply Having a way to detect wich keys cause large objects would be a real help for many users, yes. * On my side, I carefully reviewed the wp_options table and found the largest keys was ‘aviaAsset_avia-head-scripts’ (9.47 MB only on this key!). This key is linked to the Enfold theme and relates to their File Compression feature (merges and compresses all theme CSS/JS files). * It is indeed a feature I had enabled recently. Disabling the feature made my wp_options table drop from 12 MB to 2.5! And then the Memcached error message was gone. ^^ * I hope this will help other users understanding how to try and fix this. [@smartalert](https://wordpress.org/support/users/smartalert/) are you by chance an Enfold user too? * Thread Starter [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13149870) * [@hristo-sg](https://wordpress.org/support/users/hristo-sg/) Ok, waiting for the logging in 5.6.1 to be able to resolve this. * [@crimsonguard](https://wordpress.org/support/users/crimsonguard/) All autoload keys TOGETHER are below 1MB in my case. No, I don’t use Enfold. * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150262) * [@crimsonguard](https://wordpress.org/support/users/crimsonguard/) great! Glad that you’ve found what’s causing it. Marking this as closed 🙂 * [@smartalert](https://wordpress.org/support/users/smartalert/) please, open a separate thread, provide your URL so we can look into it. I am afraid we can’t troubleshoot issues without information. - This reply was modified 5 years, 9 months ago by [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/). * Thread Starter [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150272) * URL is embedded in OP * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150505) * Your options are above 1MB for sure. The problem is that WordPress does not make difference in the cache group between options with autoload enabled and the others. * [https://developer.wordpress.org/reference/functions/wp_load_alloptions/](https://developer.wordpress.org/reference/functions/wp_load_alloptions/) * I will discuss this in the WP Core channel since at this point there is no way around that. * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150532) * So, at some point WordPress tries to store a cache, which tries to get into Memcached and has a size above 1MB. For example here are the options with biggest values: * _transient_feed_d117b5738fbd35bd8c0391cda1f2b5d9 rs-templates _transient_feed_5eb173ec8534c3094fdc6da9d8253a67 _transient_feed_9bbd59226dc36b9b26cd43f15694c5c3 _transient_wpseo_site_information * Thread Starter [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150539) * [@hristo-sg](https://wordpress.org/support/users/hristo-sg/) Ok, thanks. JFYI: The biggest chunk are the theme related settings (td_011_settings). I am using Newspaper by Tagdiv, latest version and that’s how they save their state-of-the- art “cloud-template” settings which are supposed to be much faster than their old implementation. * Thread Starter [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150552) * Regarding: transient and memcache. How can I investigate from here? I am only using SG Optimizer and no other caching plugin. * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150633) * Give me some time, we’re bashing our head against the wall hard and starting to see some cracks in the wall 🙂 * Plugin Author [Hristo Pandjarov](https://wordpress.org/support/users/hristo-sg/) * (@hristo-sg) * SiteGround Representative * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150661) * Patched your site 🙂 Could you check and verify that everything is working? * Thread Starter [smartalert](https://wordpress.org/support/users/smartalert/) * (@smartalert) * [5 years, 9 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/#post-13150663) * Cool, thanks a lot! I am checking the sizes of those objects and somehow don’t understand what a single object is (all of the transients together?) Also I’ll try to get rid of the rs-templates in staging, to see if it breaks the setup. * _transient_feed_d117b5738fbd35bd8c0391cda1f2b5d9 329079 rs-templates 286944 _transient_feed_5eb173ec8534c3094fdc6da9d8253a67 111019 _transient_feed_9bbd59226dc36b9b26cd43f15694c5c3 104800 _transient_wpseo_site_information 55183 Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/page/2/?output_format=md) The topic ‘SG Optimizer Memcache disables automatically’ is closed to new replies. * ![](https://ps.w.org/sg-cachepress/assets/icon-256x256.gif?rev=2971889) * [Speed Optimizer - The All-In-One Performance-Boosting Plugin](https://wordpress.org/plugins/sg-cachepress/) * [Support Threads](https://wordpress.org/support/plugin/sg-cachepress/) * [Active Topics](https://wordpress.org/support/plugin/sg-cachepress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/sg-cachepress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/sg-cachepress/reviews/) * 23 replies * 5 participants * Last reply from: [101tech](https://wordpress.org/support/users/101tech/) * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/sg-optimizer-memcache-disables-automatically/page/2/#post-13640854) * Status: resolved