Excessive size increasing of wfConfig table

  • Resolved WPBeppe

    (@wpbeppe)


    9 years, 5 months ago

    Excessive size increasing of wfConfig table

    WordFence plugin is a very good plugin but there is a problem: when it work (for example during a scan) the size of table wfConfig on MySql undergoes a significant increase.

    I’ve made a little test: on two consecutive scans, the table size has increased from 13 Mib to about 22.5 Mib;
    last month, in 15 days plugin’s activity, the database has increased from 14 Mib to about 130 Mib, surpassing the available quota.

    Is there any way to solve this problem or is it necessary to proceed periodically to the manually cleaning of the database?
    In the second case, which is the MySQL quota necessary to avoid those too frequent cleaning activities?

    Thanks

    https://www.ads-software.com/plugins/wordfence/

Viewing 1 replies (of 1 total)
  • Plugin Author WFMattR

    (@wfmattr)

    Can you confirm that it is the wfConfig table, and not one of the other “wf” tables? I haven’t seen wfConfig get larger before, but another of others store a large amount of temporary data during scans.

    If it is one of the other tables, make sure that your MySQL user has “all privileges” on the whole database, and not just certain tables — this is the recommended setting for WordPress installations. Wordfence does use the “truncate” command, which requires privileges to drop a table.

    Also, you can confirm on the Scan page, if Wordfence is actually completing scans, or if there is an error message at the end of the scan summary or detailed activity box on those pages. If scans are failing, they may not be cleaning up the temporary data at the end.

Viewing 1 replies (of 1 total)
  • The topic ‘Excessive size increasing of wfConfig table’ is closed to new replies.