_wfconfig grows from a few MB to a few GB

  • Resolved pajik

    (@pajik)


    4 years, 4 months ago

    Hi,
    my database file “_wfconfig” grows from a few MB to a few GB.

    I used a tutorial that reduces the file to a few “_wfconfig” MB, but after a few days I have the “_wfconfig” file again a few GB.

    1. On the Options page, down bottom, click Export WordFence settings.
    That will save your configuration to the WordFence server(s). and give you a token-ID. (Save that Token)

    2. On Options page, make sure to select “Delete Wordfence tables and data on deactivation” and then save the options.

    3. Deactivate the WordFence plugin on the plugins page.. It should now delete all current WF tables from the database.

    4. Re-enable WordFence on the plugin page. It should on activation detect the missing tables and re-create them.

    5. If you want, then go on the options page and “Import” your configuration using the Token-ID you saved earlier.

    When I use the instructions, the file “_wfconfig” is reduced to a few MB. Then, when I look at the database in a few days, the “_wfconfig” file grows again and has over 2.5GB!

    Please help me.

    Thank you.

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support WFAdam

    (@wfadam)

    Hello @pajik and thanks for reaching out to us!

    There are a few versions of MySQL that have a bug to duplicate the data in the tables repeatedly.

    Can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    I’ll be able to check on this for you!

    Thanks!

    Thread Starter pajik

    (@pajik)

    Thank you for your response. I just submitted a report. I own about 5 websites and my database is growing everywhere.
    Thank you.

    Plugin Support WFAdam

    (@wfadam)

    Thanks for sending those reports @pajik

    The Data_length column is actually quite large at 1256554496, though the table is only 256 rows (It’s normal to see around 200-300 rows).

    Could you enable PHP error logs and then delete the tables again. I want to see what errors are possibly coming up when the table is expanding.

    Thanks!

    Thread Starter pajik

    (@pajik)

    Deprecated: Volaná metoda konstruktoru t?ídy pro WP_Widget v Feature_Posts je zastaralá od verze 4.3.0! Místo toho pou?ijte __construct(). in /home/www/XXX.net/domains/XXX.cz/www/wp-includes/functions.php on line 4870

    Warning: Cannot modify header information – headers already sent by (output started at /home/www/XXX.net/domains/XXX.cz/www/wp-includes/functions.php:4870) in /home/www/XXX.net/domains/XXX.cz/www/wp-includes/functions.php on line 6274

    Deprecated: Function create_function() is deprecated in /home/www/XXX.net/domains/XXX.cz/www/wp-content/plugins/file-gallery/includes/media-tags.php on line 48

    Deprecated: Function create_function() is deprecated in /home/www/XXX.net/domains/XXX.cz/www/wp-content/plugins/file-gallery/includes/media-tags.php on line 55

    Deprecated: Function create_function() is deprecated in /home/www/XXX.net/domains/XXX.cz/www/wp-content/plugins/file-gallery/includes/media-settings.php on line 43

    Warning: Cannot modify header information – headers already sent by (output started at /home/www/XXX.net/domains/XXX.cz/www/wp-includes/functions.php:4870) in /home/www/XXX.net/domains/XXX.cz/www/wp-admin/includes/misc.php on line 1310

    Warning: Cannot modify header information – headers already sent by (output started at /home/www/pyramida.net/domains/mandaly-obrazky.cz/www/wp-includes/functions.php:4870) in /home/www/XXX.net/domains/XXX.cz/www/wp-admin/admin-header.php on line 9

    • This reply was modified 4 years, 4 months ago by pajik.
    Plugin Support WFAdam

    (@wfadam)

    Thanks @pajik

    All the errors I see there are caused by other plugins, or by WP itself (likely caused indirectly by the other plugin). Seeing the whole error log might help, though they’re still might be nothing relevant.

    Cannot modify header information is often caused by having display_errors enabled. Diagnostics showed that it was off, so it may have been enabled when error logging was. (Ideally, that should be off.) Sometimes it can also be caused by bugs in a plugin/theme, where they echo content or trigger something else that’s displayed, too early.

    If you have the entire error log and want to send it to wftest @ wordfence . com, we might be able to review it further.

    Thanks!

    Thread Starter pajik

    (@pajik)

    I don’t know how to make a bug report. I can only use the wp-config.php and set “define (‘WP_DEBUG’, true);”.
    But when I turn on debug, my entire web stops appearing.
    Is there a plugin that would do that bug report?

    Thank you.

    Plugin Support WFAdam

    (@wfadam)

    Hello again @pajik

    https://www.ads-software.com/support/article/debugging-in-wordpress/#wp_debug_log will help you create a debug log.

    Let me know if this helps!

    Thanks!

    Thread Starter pajik

    (@pajik)

    I couldn’t get the debug log. I have the database reduced back. But in time I believe it will grow again to hundreds of GB. So far, after the database is shrinking, it keeps happening to me that when I come back over time, I see a huge increase in the size of the database.

    Plugin Support WFAdam

    (@wfadam)

    You could try to Optimize the database but only do that during off-hours as it sometimes can take a while and will use up a lot of resources. I have seen that fix the issue in the past.

    Let me know what you find!

    Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘_wfconfig grows from a few MB to a few GB’ is closed to new replies.