Jump to content

Archived

This topic is now archived and is closed to further replies.

davidcosgrove

WPEngine crashing our DMS website, pl-settings row too large

Recommended Posts

davidcosgrove

Hi,

 

Our website www.rootstock.com has been running on WPEngine for months without any problems.

 

Within the past 3 weeks, they have crashed it 5 times.

 

After much back and forth with their support staff, they came back to us with the following explanation and insist that our theme developer needs to fix this problem (snippet from them is below) -

 

----------------------

There's an autoloaded row that's used by your theme ( pl-settings ) that is storing just past 1MB of data, that is going to be cleared out when our nightly processes are run within the environment. This would explain the header and footer being mangled, but the rest of the page being intact.

 

To remedy this, you will want to contact your site's developer and review the information being stored within that row and keep it as far under one megabyte as possible. If you would like to see the amount of data stored within rows on your end (in bytes), feel free to use the following command within PHPMyAdmin. You'll need to select your desired database (wp_ for production and snapshot_ for staging), then click on the SQL tab near the top:

 

max-width: 100%">SELECT option_name, LENGTH(option_value), autoload FROM `wp_options` WHERE autoload = 'yes';

 

Arrange the rows in descending order by "LENGTH(option_value)" and you'll get the rows holding onto the largest amount of data within your "wp_options" table. Also, to help speed things up, it's best to keep the total amount of autoloaded data as low as possible. Ideally, being under 300KB is best. Here's a query to show the total amount of autoloaded data:

 

max-width: 100%">SELECT SUM( LENGTH( option_value ) ) FROM  `wp_options` WHERE autoload =  'yes';

 

Let me know if this helps to move things forward on your end. If there are any other questions that I can answer, please feel free to ask!

----------------------

 

Is this a DMS-centric issue or is WPEngine able to remedy this?  Is this an issue that every website hosting company will have with DMS?

 

Thank you for your help.

 

David

Share this post


Link to post
Share on other sites
dario

Kinda new to phpMyAdmin (and databases in general) but when I run the first query on my three local dev sites the biggest table is pl_gfonts.

It's almost 300k on each of the three sites.

 

I'm not using any google fonts but load three customs ones instead.

This makes me wonder:

  • Does pl_gfonts need to store anything if no google fonts are being used?
  • If not, how does one clear it?

Share this post


Link to post
Share on other sites
Simon

WordPress uses LONGTEXT for the wp_options table values. LONGTEXT has a limit of 4GB, yes thats right 4GB for EACH option, this is why WP did that.

WPENGINE have decided to limit WP options to 1MB? Thats utterly ridiculous.

 

  

Share this post


Link to post
Share on other sites

  • Similar Content

    • Lisa Haran
      By Lisa Haran+
      Hi 
      I have a map here http://www.iloveoffset.com/maps/
      I want to add several pointer locations to the map, but when I do they do not appear.
      On this map there are 2 pointer locations and as you can there is only one visible.
      Earlier today I added 7 and could only see 4 so there is something odd going on.
      My theme is up to date
    • clj182
      By clj182+
      Hello,
      I've been having trouble unlocking the template section for past couple of weeks. When I try clicking nothing happens. 
      I've deleted my custom css and removed plugins. Im down to having only the following plugins:
      Akismet
      Contact Form 7
      DMS Professional Tools
      Pagelines Updater
      WooCommerce
      It was working fine before i have no idea what's going on with it.
    • flourishdesignstudio
      By flourishdesignstudio+
      My DMS 2 site http://www.heart-stone.com/ will not save any new custom css... I can still edit templates and publish those but any custom css that I enter never saves.
      All WP files, themes, and plugins are up to date. 
      Any thought about what might be causing this?
    • flourishdesignstudio
      By flourishdesignstudio+
      Is there a way to edit the custom CSS via FTP? I know I can edit the custom code in the Chrome editor but is there a file path I can use to find and edit the CSS directly from our FTP?
      Thanks in advance for the help!
    • nizami
      By nizami+
      Using navbar section with correctly configured WP menu to display main navigation at https://elenaangel.com. 
      All fine in desktop viewport. Menu displays twice in hamburger mode. How to fix this please? 

×