Support » Plugin: Wordfence Security - Firewall & Malware Scan » Confused by Database Tables Count Used by Wordfence

  • Resolved Yet Another WP User

    (@yet-another-wp-user)


    I’m very confused which are the required database tables used by the latest version of Wordfence plugin?

    Following official page lists only 27 tables:

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

    But I have following 29 tables in my database:

    wp_wfBadLeechers
    wp_wfBlockedCommentLog
    wp_wfBlockedIPLog
    wp_wfBlocks
    wp_wfBlocks7
    wp_wfBlocksAdv
    wp_wfConfig
    wp_wfCrawlers
    wp_wfFileChanges
    wp_wfFileMods
    wp_wfHits
    wp_wfHoover
    wp_wfIssues
    wp_wfKnownFileList
    wp_wfLeechers
    wp_wfLiveTrafficHuman
    wp_wfLockedOut
    wp_wfLocs
    wp_wfLogins
    wp_wfNet404s
    wp_wfNotifications
    wp_wfPendingIssues
    wp_wfReverseCache
    wp_wfScanners
    wp_wfSNIPCache
    wp_wfStatus
    wp_wfThrottleLog
    wp_wfTrafficRates
    wp_wfVulnScanners

    So following 2 tables are extra:

    wp_wfLiveTrafficHuman
    wp_wfTrafficRates

    Are they necessary? If yes, you should update the official page to include these new tables.

    Also I read in following topic that wp_wfLeechers table is not used by Wordfence:

    https://wordpress.org/support/topic/wp_wfleechers-and-wp_wftrafficrates-wp_wffilemods-tables/

    So you should remove the table from official page.

    Now I want to know among the 29 tables in my database, which tables should I drop?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support wfdave

    (@wfdave)

    Hi @yet-another-wp-user,

    The following tables are no longer used in the latest version of Wordfence, and may be safely dropped from the database.

    wfBlocks
    wfBlocksAdv
    wfLockedOut
    wfThrottleLog
    wfNet404s
    wfBlockedCommentLog
    wfVulnScanners
    wfBadLeechers
    wfLeechers
    wfScanners

    You can run these set of queries:

    DROP TABLE wp_wfBlocks;
    DROP TABLE wp_wfBlocksAdv;
    DROP TABLE wp_wfLockedOut;
    DROP TABLE wp_wfThrottleLog;
    DROP TABLE wp_wfNet404s;
    DROP TABLE wp_wfBlockedCommentLog;
    DROP TABLE wp_wfVulnScanners;
    DROP TABLE wp_wfBadLeechers;
    DROP TABLE wp_wfLeechers;
    DROP TABLE wp_wfScanners;

    Dave

    Yet Another WP User

    (@yet-another-wp-user)

    @wfdave
    Thanks for your reply. I’ll drop them from the database.

    I wonder why Wordfence plugin didn’t delete the unused old tables from the database itself?

    Shouldn’t the plugin be programmed in a way that it deletes the unnecessary tables automatically from database?

    If I didn’t create this topic and ask the question, the unused tables would have remained in the database forever?

    Or Wordfence team should make an announcement whenever a table becomes obsolete in a new version of the plugin so that plugin users can manually delete the table from database.

    Plugin Support wfdave

    (@wfdave)

    Hi again,

    The tables remain in the database so that the developer can make backups or view historical data from them.

    The unused tables are removed upon deactivation (Wordfence -> All Options -> Delete Tables on Deactivation).

    I think a good suggestion would be to add a button within Wordfence diagnostics to remove unused tables. (So users can easily remove them without having to manually run a query)

    Dave

    Yet Another WP User

    (@yet-another-wp-user)

    Yes. Wordfence team should provide a way to remove unused tables from database.

    Also an official announcement should be made whenever one ore more tables become unused by a new version of plugin.

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