Wordfence mess in the database

  • Resolved pajik

    (@pajik)


    4 years, 10 months ago

    Hi,
    my database size has grown from a few tens of MB to a few hundred MB! The problem was solved here several times, but it was not solved. The problem still persists.
    Is there a permanent or automatic solution to remove the mess in the database?
    I’ve done the procedure several times:
    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.

    But doing it over and over and over again … is pretty annoying
    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hey @pajik,

    Can you please share which table(s) is causing the bloat? Then I can ask the developers for their thoughts.

    Please let me know.

    Thanks,

    Gerroald

    Thread Starter pajik

    (@pajik)

    The problem is in the “_wfconfig” file, which is 699.4 MiB in size.

    • This reply was modified 4 years, 10 months ago by pajik.
    • This reply was modified 4 years, 10 months ago by pajik.
    Thread Starter pajik

    (@pajik)

    Hi, is anyone here?
    my database is growing!
    The problem is in the table “_wfconfig” which is constantly growing and already has a few MB of something around 1GB

    Hey @pajik,

    My apologies for the delayed response.

    Can you please try completely resetting Wordfence and let me know how it goes?

    https://www.wordfence.com/help/advanced/remove-or-reset/#remove-or-reset

    Also, can you send me a Diagnostics report so I can get a better overview of your environment? Please navigate to Wordfence > Tools > Diagnostics. Here you can select SEND REPORT BY EMAIL. Please include your www.ads-software.com username and update this thread after you’ve sent it.

    Thanks,

    Gerroald

    Hey @pajik,

    We haven’t heard back from you in a while, so I’ve gone ahead and marked this thread as resolved.

    Please feel free to open another thread if you’re still having issues with Wordfence.

    Thanks,

    Gerroald

    Thread Starter pajik

    (@pajik)

    The problem still persists.

    • This reply was modified 4 years, 4 months ago by pajik.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Wordfence mess in the database’ is closed to new replies.