Wordfence wp_wfHoover

  • Tintin Thai

    (@tintin-thai)


    7 years, 2 months ago

    Hello,

    I have a recurring problem with Wordfence, sometime “wp_wfHoover Table” get more than 2Go, and my DataBase become in reading mode.

    Before, I just need to open PhpMyAdmin and clean this table, but now when I am on “Reading mode” it is not possible so I need to use a save.

    How can I solve this problem ?

    Kind regards,

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • wfdave

    (@wfdave)

    7 years, 2 months ago

    Hi @tintin-thai,

    Is your database locked because your host locked it automatically?

    Here are the options:

    1. Ask your host to run the query (or if you have access to the database, run this query):

    DELETE FROM wp_wfHoover;

    2. Try to manually unlock your database:

    SET GLOBAL read_only = 0;
UNLOCK TABLES;

    After unlocking, try to run the above query.

    Dave

    Thread Starter Tintin Thai

    (@tintin-thai)

    7 years, 2 months ago

    Thanks Dave,

    In fact, my host locked my database, and I am not able to delete table.
    So I install a save of my database. Now it is ok, but many time I did it…

    My ask is about the recurring problem of Wordfence and “wp_wfHoover Table” become so heavy.
    It is not normal, is there an issue ? A parameter to avoid it ?

    wfdave

    (@wfdave)

    7 years, 2 months ago

    Hi again,

    There are three settings you can disable – which will reduce the amount of memory wp_wfhoover will use.

    Can you go to Wordfence -> All Options -> General Options, and disable…

    – Scan files outside your WordPress installation
    – Scan images, binary, and other files as if they were executable
    – Enable HIGH SENSITIVITY scanning

    For example: https://i.imgur.com/yS9T8HU.png

    Dave

    Thread Starter Tintin Thai

    (@tintin-thai)

    7 years, 2 months ago

    Hi Dave,

    Before wrotte this publication, I read already some…
    And I alrealdy check this
    – Scan files outside your WordPress installation
    – Scan images, binary, and other files as if they were executable
    – Enable HIGH SENSITIVITY scanning

    It was already disable.

    So the problem come from somewhere else.

    Thread Starter Tintin Thai

    (@tintin-thai)

    7 years, 2 months ago

    Aww, I was waiting your help.

    Again 1.2 Go for wp_wfHoover table. I can not clean this table.
    Only can use a DataBase ‘s Save.

    If you can not provide a solution, I will uninstall Wordfence.

    Kind regard,

    Thread Starter Tintin Thai

    (@tintin-thai)

    7 years, 2 months ago

    I install a clean saved Database, 3 hours ago
    And now 3Go.

    WFSupport

    (@wfsupport)

    7 years, 1 month ago

    The hoover table is used to temporarily store URL’s found during a scan before we check them against the Google Safe Browsing (GSB) list of known malware and phishing URLs. This is used during a scan and in other places we check things against the GSB.

    You can disable the scans for malicious URLs but I’d check to see if the database user has all permissions. If I remember correctly that table is purged before scans start.

    Tim

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

The topic ‘Wordfence wp_wfHoover’ is closed to new replies.

Tags