Enormous size of 2 Wordfence database tables

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wfmark

    (@wfmark)

    Hi @jeriss , thank you for reaching out.

    The size of the tables (wffilemods and wfknownfilelist) may be explained by the number of files being scanned. Do the database tables double in size every time a scan runs? If not, you should be good to go if the scans are working.

    wp_wffilemods and wp-wfknownfilelist?should be truncated at the start of new scans. If you visit?Wordfence > Tools > Diagnostics > MySQL, are your privileges to INSERT, UPDATE, TRUNCATE etc. here reporting back as OK? It should be safe to empty the tables as it’s meant to happen next time a scan runs, but the size.

    Thanks,

    Mark

    Thread Starter Jeriss Cloud Center

    (@jeriss)

    Hello,

    1) Yes, all the privileges under MySQL are reported as OK.

      See screenshot : https://jeriss.tinytake.com/msc/OTg1Njk5Ml8yMzUxMzU0Mw

      2) I’ve just run a new scan and the size of those tables are still the same.

      What else to do to fix this problem ?

      Plugin Support wfmark

      (@wfmark)

      Hi @jeriss,

      Apologies for the delayed response. I mistakenly forgot to enable notifications for new responses on this topic.

      As all the permissions are okay, the size of the tables (wffilemods and wfknownfilelist) may be explained by the number of files being scanned on the site. If there are other sites in subdirectories outside WordPress core files that are included in the scan, you can exclude them from this site’s scan to reduce the number of files.

      Thanks,

      Mark.

    Viewing 3 replies - 1 through 3 (of 3 total)
    • You must be logged in to reply to this topic.