SG Optimizer Memcache disables automatically

Unfortunately not ??

1. Login into wp-admin: Message memcache disabled
2. Turning on memcache in SG Optimizer settings
3. reloading the URL
4. Switching to dashboard and back to SG Optimizer settings
5. Error message like in OP

Double entry removed

• This reply was modified 4 years, 8 months ago by smartalert.

@hristo-sg Here’s my update, which might help you to fix the bug:

I have reverted to 5.5.6 and it does not display the message, but also does not help in any way in terms of performance (Pingdom page load time still > 4s)

Interestingly in both cases this process is running with approximately the same size:
/usr/bin/memcached -d -p 20082 -u xxx -m 64 -c 256 -P /var/run/memcached/xxx/memcached-20082.pid -l 127.0.0.1 352356 kB 32304 kB

When updating from 5.5.6 to 5.6.0 with enabled memcache, the popup message does not appear, the Error box described in OP is displayed, but the memcache box stays on.
I’ve checked with the Query Monitor plugin you installed and “External object cache in use” seem to confirm this.

My root problem is that the SiteGround avg server response time went through the roof end of May (from less than a second to over 3 secs) and stayed there. Accordingly traffic halved over the last 2 Months, as people don’t like slow sites. SG Optimizer seems no help here. ??

I’ve uninstalled the Query Monitor plugin you’ve installed. Is there anything else I should clean up from your session yesterday, eg your “patch”?

Your response times have nothing to do with Memcached – if your Dynamic caching is working properly, requests won’t even reach it. I will look into your site after we fix the memcached problem that we’re working on right now. It is better to keep it off, until we can find a workaround for this and exclude the options that are causing it. Meanwhile, you can check if your Dynamic caching is actually working.

@hristo-sg Thank you! I am aware that dynamic caching could help (please see my 2 support tickets from 3 months ago). Unfortunately I have to exclude pages from dynamic, because otherwise my i18n (geotargeted) ads on these pages don’t work. I have now contacted the ad plugin developer to see if he has an idea how to tackle this.

Memcache is turning off on me for no reason. It displays the same message as everyone else. I setup the site in question on staging and dug through the database. Only one table was over 1MB. From there I deleted literally every plugin, deleted every column that wasn’t a standard WordPress database option and the message is still displayed.

There aren’t any objects in the database over 1MB. I’ve reached out to support but everyone seems to be dodging the issue. Any idea what is going on and how to fix this issue?

————————————

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.

Memcache is turned off because you have an object that is above its limit. This is actually better than having it working and constantly throwing object too big errors because your site will be slowed.

The object is a result of the query which includes more than one row from your database, so yes, your site is generating ones bigger than the limit. In the next update we will add functionality to remove the biggest rows from objects until they go under the limit. Meanwhile, either perform some maintenance on your databse or just keep Memcached off for the time being.

Reverse Your PHP version which is site ground recommended, Issue will be resolved.

Thanks ??
101Tech