Archived topic
Memcache question
9 replies · Started by Alana on May 16, 2019
Hi,
Does GeneratePress work well with Memcached (as provided by SiteGround)? Do you recommend activating this caching option through SiteGround? Thanks!
Hi there,
It should - GP should work with anything that's built to work with WordPress.
Don't have any recommendations for specific caching plugin etc.
We only do this on our site:
https://generatepress.com/fastest-wordpress-theme/
Definitely recommend leaving caching plugin off during development though.
Hi,
I have a problem with Memcache on Siteground hosting. The Siteground technical support say me:
Still, I have managed to perform several tests and I believe the issue is caused by the GeneratePress plugin that is generating a large chunk of data and stores it in the wp_options table. Later, when this information is about to be stored in the Memcached, the operation failed because the data is too large. Since this is your live site, I was not attempted to disable the plugin without your confirmation.
I have the latest versions of the GeneratePress theme and plugins GenerateBlocks and GP Premium. I think it's a big issue.
Others info by SiteGround Technical Support:
The issue here is related to the data the GP-Premium plugin is adding to the wp_options table in your database. What I have found are two rows with quite long value added and both are related to the GeneratePress. I am listing their values in the option_name column below:
generatepress_sites
edd_sl_9b4b9278ab03eed62e9ded0113d4678e
edd_sl_db7d03ab6ea36103a1b2af06be40a06c
These rows generated by GP-Premium plugin contain a large chunk of data which most probably is causing the issue.
Hi there,
Neither of these options should be cached - so my recommendation would be to exclude both of them from Memcache altogether.
We can likely decrease the size of the edd_sl_** one, but the generatepress_sites one is required as of right now.
Thanks, Tom.
Will the decrease the size of the edd_sl_** be a future plugin update?
Hi Tom,
The problem is persistente. SiteGround has excluded the options but nothing, Memcache fails and freezes.
These the feedback by SiteGround:
We tried excluding the options from Memcache that we listed and other options we found in the database from GeneratePress but to no avail.
Based on our investigation, the GeneratePress plugin is most likely causing this. The plugin keeps a lot of data in the database, including its CSS, based on that, we guess that one of its options is causing this problem.
You can look for an option to keep the CSS in a file or any other way out of the database and see if this will resolve the issue but at the moment the plugin is not compatible with our Memcache, and both can't work at the same time.
I am using the external file for the css of the theme, but I don't see the option for its plugins.
Ideas?
The external file option stores all CSS (from the theme and plugin) in the same file.
You can also turn off the dynamic CSS cache in "Customize > General".
That being said, these are not huge chunks of data. I don't see why something as powerful as Memcache would have issues with it, as Memcache should be capable of caching huge chunks of data.
The EDD SL thing will be smaller in a future version.
Thanks, Tom.
SiteGround has fixed the issue.
Great to hear :)