-
AuthorPosts
-
March 23, 2020 at 6:05 pm #1195542
Hi,
I use WP Engine to host my websites. For at least the last few weeks (maybe longer) the server has been running out of memory which has been crashing my server or forcing it to reboot. I’ve been told that the issue has to do with autoloaded data within the wp_options table. Almost all my websites that use Enfold has this issue with the data stored in this table is way too large. For example here are four websites that WP Engine sent to me that are problematic:
Install=website1 Table=wp_options Data=5079325
Install=website2 Table=wp_options Data=1656772
Install=website3 Table=wp_options Data=3490285
Install=website4 Table=wp_options Data=2639425They stated that at most autoloaded data should be at 800k max. They also stated that the top items in each of these cases look to contain the string “aviaAsset”.
I’ve been at WP Engine for almost a year and this hasn’t been a problem until the last few weeks. Now I’ve been adding many websites to my WP Engine server over time to be fair. I understand that more websites means more memory so it could be that within the last few weeks I finally got to a point where all the websites together are using too much memory and Enfold may have been using this much memory since the beginning.
My question then is has Enfold made any adjustments in how it stores autoloaded data in the last few patches or has Enfold always stored this large amount of autoloaded data within the wp_options table? In either case how can I stop this all this data from being stored? I need to shrink this data to get it to the recommended value of 800k. Also, is the autoloaded data being created because of the “performance” options I’m selecting within the Enfold theme? Is this much data being stored anticipated or there another problem?
Any suggestions or insight will be greatly appreciated. Thank you!
March 29, 2020 at 7:00 pm #1198916Hi,
Just checking to see if anyone has any ideas.
March 30, 2020 at 4:55 am #1198998Hi!
Thank you for the inquiry.
To temporarily fix the issue, you can disable the theme’s Performance > File Compression settings to keep it from storing data from merged files in the database. You can then use a plugin like Autoptimize or BWP Minify in place of the default compression.
If you want to keep using the default compression, you can also try the fix that we provided in the following thread.
Best regards,
IsmaelDecember 13, 2020 at 1:19 am #1266833@codeSamurai
I have been facing the exact same issue .. i am with Dreamhost and they told me the exact same thing !
Did you find a solution ?
@Ismael solution worked for me for a while .. but once i installed Autoptimize the site started to crash again .. although i dont see any reason for extra load .. no new plugins (except for Autoptimize) and no new major changes .. the site crashes every time i try to edit a page or post or product ..December 14, 2020 at 10:51 pm #1267270@Cloudypro
I just turned off all the performance settings within the theme and cleared the cache. Once I did that the wp_options table didn’t have the autoloaded data any longer. I use WP Rocket mostly for my caching. The plugin seems to use a large amount of space for its cached files, but other than that, I haven’t had issues with autoloaded data or running out of memory as I did previously. I hope that helps some.December 16, 2020 at 4:46 am #1267654Hi,
@CodeSamurai: Thank you for the info. Did you install a different minification plugin?
@CloudyPro: Have you tried using a different compression plugin? Most cache plugins also have this option by default, so you might have to test the options or the plugin settings to find out which combination works best for your server.Best regards,
IsmaelDecember 17, 2020 at 12:01 am #1267963@codesamurai Thank you for your answer !
@ismael Thank you for clarifying this. Yes i noticed that and i currently disabled the plugin ! it seems to be working fine (at least for now) still need more time to test things out ..Thanks for the support
December 18, 2020 at 8:53 pm #1268485Hello again
So after trying for few days, i still get site crash !
only when i try to make any edits on the site, it goes down ! this is so frustratingDecember 21, 2020 at 12:26 pm #1268997Hi,
@Cloudypro: Would you mind creating your own ticket or thread for the issue? Please include the login details to the dashboard, cpanel and the file server so that we could check the issue properly. We will close this one for now.Best regards,
Ismael -
AuthorPosts
- The topic ‘autoloaded data is too large and crashing my server’ is closed to new replies.