Viewing 16 posts - 1 through 16 (of 16 total)
  • Author
    Posts
  • #1236596

    Hi,

    our website crashed down due to a huge wp_options table that contained over 5M lines with 40GB size! I used the WP-Optimize plugin to clean up this table and reduce the size to ca 2.5 MB. I have also turned off all merging and compression on the Performance tab of Enfold Theme options so there are enabled only:
    – Self hosted videos and audio features (WP-Mediaelement scripts) – Default only load when needed
    – Disable Emoji/Smiley Support
    – Responsive images

    However, this morning the wp_options table increased from 2MB to 51.6 MB with 745 lines. I’m afraid the situation starts repeating and the size of this file will be enormous in a few days again.

    I read the relating thread about “cleanup wp_options table” at https://kriesi.at/support/topic/cleanup-wp_options-table-aviaasset_avia-head-scripts/
    Anyway, this is quite suspicious that the size of wp_options table is being increased despite the fact I have deactivated all options in Performance of our Enfold theme.
    What should I do to prevent increasing the size of wp_options table?

    #1236833

    Hey cukrmi,

    Sorry for the problem. Please send us a temporary WordPress admin login and login URL so that we can have a closer look. You can post the details in the Private Content section of your reply.

    Best regards,
    Rikard

    #1236898

    I have attached the login details.

    #1237248

    Hi,

    Thanks for that. Does your site have a URL as well? We can’t login to your site without one.

    Best regards,
    Rikard

    #1237293

    Hi,

    I’am sorry! Please find it attached,

    #1237974

    Hi,

    Thanks for that, the details don’t seem to work though:

    CHYBA: Špatné uživatelské jméno nebo heslo.

    Please check and verify.

    Best regards,
    Rikard

    #1238418

    Hi,
    I’m sorry again. Now the attached details should work properly. I checked them.

    #1238740

    Hi,

    Thanks for that, login details are working now. First off, could you try updating the theme to the latest version (4.7.6.3) to see if that helps please? https://kriesi.at/documentation/enfold/how-to-install-enfold-theme/#theme-update.

    Also make sure that you activate the Advanced Options toggle under Enfold->Performance, and try out the different options in the Unique timestamp of merged files and WP object cache bug dropdown. The bottom options should likely work for the problem you are having.

    Best regards,
    Rikard

    #1238744

    Hi,

    Thanks for the suggestions. I’ve updated the theme even though I rather suppose that settings relating to Unique timestamp under Enfold > Performance may affect and hopefully solve the problem (after 5 days wp_options had 130k lines and the size 127MB – I cleaned using WP optimize plugin and we will see if the change in settings prevents the increasing size of wp_options).

    Best,

    Michal

    #1238891

    Hi cukrmi,

    Glad you got it working for you! :)

    If you need further assistance please let us know.

    Best regards,
    Victoria

    #1239053

    Hi,

    I’m not sure if it helps us. Today I found out the size of wp_option was 50 MB. I have changed the setting in Enfold > Performance from “FIx WP Bug, add unique timestamps” to “FIx WP Bug, disable unique timestamps”. However, if it doesn’t change anything, I won’t know what to do tomorrow.

    Best,

    Michal

    #1240410

    Hi,

    Did you delete the following entries in the database after disabling the timestamp? After deleting these entries, the theme will just regenerate them automatically when necessary.

    aviaAsset_avia-head-scripts 
    aviaAsset_avia-footer-scripts 
    aviaAsset_css_filecontent 
    aviaAsset_js_filecontent 
    

    Please note that these entries will contain the content of every js and css files in the site, so expect the entries to get big specially when there are a lot of plugins installed in the site.

    If you’re still having the issue after deleting the entries, you might have to just disable the Performance > File Compression settings and instead use a third party plugin such Autoptimize or WP Super Minify to minify or compress the resource files.

    Best regards,
    Ismael

    #1240595

    Hi,

    I checked the wp_options table today and found out its size is only 3 MB.
    The mentioned lines aviaAsset are not in our wp_otpions table.
    Anyways, it seems the problem has been fixed. Perhaps, it lasted a few days to apply the changes from Performace?

    Best,

    Michal

    • This reply was modified 4 years, 3 months ago by cukrmi.
    #1240674

    Hey!

    The mentioned lines aviaAsset are not in our wp_otpions table.

    Did you disable the Performance > File Compression settings? The avia asset entries should be automatically added in the database when the option is enabled.

    Best regards,
    Ismael

    #1241168

    Hi Ismael,

    I’ve already disabled all file compression settings before. Maybe I had to wait a few days that all changes from the Performance tab were applied.
    I have also removed some lines related to removed plugins such as Updraft that were still in our wp_options table.
    Now our wp_options table has 588 lines and 2,8 MB that is suitable. No increasing size happens now. All is good.

    Best regards,

    Michal

    #1241647

    Hi,

    Alright. Glad it’s all good. Please don’t hesitate to open a new thread if you have new inquiries.

    Have a nice day.

    Best regards,
    Ismael

Viewing 16 posts - 1 through 16 (of 16 total)
  • The topic ‘wp_options table is too large (40 GB!)’ is closed to new replies.