wpeh_wfconfi Daatabase problem

  • I haave a bug caused by a large amount of data inserted and deleted by Wordfence and Mysql 5.7 which does not automatically optimize the wpeh_wfconfig table.

    The result is that this table seems huge but in fact it is all “empty” space that has not been deallocated, in fact just run the query “optimize table wpeh_wfconfig” to solve the problem.

    The Hosting server is Siteground.

    How is possible fix the problem?

    Thank you

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @andrea76bo, thanks for reaching out about this!

    A large wfconfig table, which appears to not be clearing down properly has in some cases been fixed by customers upgrading to MySQL v8.0.19. If the natural upgrade process of Wordfence (when a new version is released) doesn’t fix the table, you will probably need to optimize it. The original issue appears to be that overwritten data wasn’t marked as safe to delete, leaving it orphaned.

    If you optimize the table in MySQL with no improvement, it may be appropriate to delete the Wordfence tables on deactivation of the plugin and reinstall it.

    You can backup your Wordfence settings via the Export option. Navigate to Wordfence > Tools > Import/Export Options and click Export. You can also take note of the current Whitelisted URLs you have in Wordfence > Firewall > All Firewall Options > Whitelisted URLs as these are NOT included in the Import/Export, and will be lost during the re-install.
    Here is what is exported: https://www.wordfence.com/help/tools/import-export/
    During the export, you will be given a long string of text. Keep this safe, you’ll need it in a few minutes.

    After that, enable the option to Delete Wordfence tables and data on deactivation in All Options > General Wordfence Options. You will want to remember to disable this after you reinstall Wordfence again.

    After you enable that option, you can deactivate Wordfence from the Plugins area of your site, then delete it. Next, from the plugins area, search for and re-install Wordfence like normal.

    It will be like setting Wordfence up for the first time. You will need to enter an email address, and then go into Tools > Import/Export Options and paste that string of text into the Import Wordfence Options field and click the button there.

    The firewall will be in Learning Mode by default for 7 days. I would recommend switching this to Enabled and Protected as soon as possible.

    For your reference, there’s a full list of our database tables on the following page: https://www.wordfence.com/help/advanced/remove-or-reset/

    Thanks,
    Peter.

    Thread Starter andrea76bo

    (@andrea76bo)

    Hi,

    thank you very much for the detailed explanation, but none of these suggestions solved the problem, except the update of the mysql version, that I didn’t try because the server is shared and I have no technical support if issues to my ecommerce come out.

    Other options?

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wpeh_wfconfi Daatabase problem’ is closed to new replies.