Massive wffilemods and wfknownfilelist tables, diagnostics okay

  • Resolved Corrinda Campbell

    (@corrinda)


    2 years, 10 months ago

    After discovering very large WF database files I “reset” the installation by uninstallting the plugin and all of it’s data and reinstalling it with a new license.

    Following the new installation the db levels were acceptable and on par with WF installations on other sites I manage.

    However, following a scan two of the tables are huge again:

    wffilemods 89.69 mb
    wfknownfilelist 39.56 mb

    The MySQL Version is 5.7.39 and in the “MySQL Database version and privileges” section of WF Diagnostics all elements are checked as ok.

    This is the summary of the log following the latest scan:

    [May 11 14:13:23:1683836003.917131:1:info] Scan Complete. Scanned 173767 files, 58 plugins, 2 themes, 203 posts, 47 comments and 0 URLs in 1 hour 56 minutes 50 seconds.[May 11 14:13:23:1683836003.915562:2:info] Wordfence used 78.64 MB of memory for scan. Server peak memory usage was: 191.21 MB

    From doing a little research, I think the issue is that the tables aren’t truncated following the conclusion of the scan.

    Is there a remedy for this issue?

    Is the site too large?

    How much database memory needs to be available to support the WF scans?

    Thank you for your feedback.

Viewing 1 replies (of 1 total)
  • Plugin Support wfjanet

    (@wfjanet)

    2 years, 10 months ago

    Hi @corrinda,

    Thank you for reaching out.

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

    Do all the files belong to a single site? If there are other sites in subdirectories that are also running Wordfence, you can exclude them from this site’s scan to reduce the number of files.

    We do have plans to improve this in a future version but I cannot commit to a timeline here in Forums.

    Thanks,

    Janet

Viewing 1 replies (of 1 total)

The topic ‘Massive wffilemods and wfknownfilelist tables, diagnostics okay’ is closed to new replies.